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: