In a previous post, we covered how you can use a spreadsheet (CSV file) from a Web location to add a layer to your ArcGIS Online map. You can do the same using Google Docs by following these simple steps.
In this example we have a Google Docs spreadsheet of crime locations containing latitude and longitude values. Under File choose Publish to the Web.
In the next dialog change the link setting from the default option of Web page:
To CSV by opening the drop-down list, as shown below:
Then copy the URL so you can add it to your map:
Adding from Google Docs using the ArcGIS.com Map Viewer
Using the map viewer click Add, then choose Add Layer from Web:
Choose CSV and paste the Google Docs URL, as shown below, then click Add Layer:
Once added, you can rename, configure the pop-up, and change symbols, just like any other layer. Below we’ve chosen to symbolize the crimes from our Google Docs spreadsheet based on the time of day:
Add from Google Docs using ArcGIS Explorer Online
Using Explorer Online click Add Content and choose Import, then CSV:
Choose Enter URL, as shown below:
Then paste the Google Docs URL into the input. Once you’ve added your Google Docs spreadsheet you can rename it, change symbols, configure pop-ups, and use the layer in Explorer Online dashboards and presentations.
Like other URL-based CSV sources, when the map is opened or refreshed any changes to the layer’s source will be displayed in the map.
For more information see:
- Adding features from a file (Map Viewer)
- Import CSV file (Explorer Online)
I follow your instruction, but it does not work. Instead I get this message:
The CSV, https://docs.google.com/spreadsheet/pub?key=0AhIYeErFjpUOdGtKdTNmRnY1XzYxbkZ0OFFubmR2eFE&output=csv, is not accessible and cannot be added to the map.
Curious if you had any suggestions to help me publish my .csv files to an arcgisonline map.
Cheers
Jesse
PS
Is it due to the x and y values that arcGIS online won’t accept it?
accuas -
I checked the .csv link you posted here – and the latitude / longitude format has special characters within it. Try converting to decimal degrees (I have used this technique within MS excel http://support.microsoft.com/kb/213449).
- Paul
How come the CSV layer does not show up when I open the map in ArcGIS for IOS or Android apps?
Yep can’t see it too on an Android device. It did show up on the ArcGIS.com Map Viewer, Explorer, and a Basic Viewer web app. My csv layer was coming out of Dropbox.
I’ve just been around with Support about the iOS issue, it’s now a registered bug
[#NIM079191 Web map layers with csv layers referenced via http do not display in ArcGIS for Android. ]
[#NIM079189 Web map layers with csv layers referenced via http do not display in ArcGIS for IOS. ]
It’s the same problem with referenced KML layers.
When I add a new record to my google doc .csv file, it doesn’t update in the map I have in ArcGIS Online. Has anyone else had this problem?
Pingback: Map Of The Western Caribbean
Pingback: Creando aplicaciones web con ArcGIS « Bitácora