About this blog...

The people of Esri UK sharing what we do, what inspires us and how we get the most out of Esri technology.

Entries on this blog are the views of the individual authors and do not necessarily represent the views of Esri UK.

Follow us

Search
LVF Blog Page
Schools Blog Page
Technical Support Blog Journal
Think Location
« New Global Elevation data services | Main | The forecast for my GIS desktop is increasingly cloudy. »
Friday
Jul112014

Using Google Docs in your ArcGIS Online maps

Some of you may already have made use of the workflow described in this blog article to use Google Docs in an ArcGIS Online webmap. Since the article was published, Google Docs have removed the ability to publish a Google Spreadsheet to the web as a CSV (comma-separated values).

BUT fear not, there is a way to still complete the workflow in the blog, just follow these steps!

1. In your Google Docs Spreadsheet, under File, choose Publish to Web… >

2. Copy the URL in the ‘Document link’ field >

3. Paste the URL to a notepad/wordpad of your choice -

https://docs.google.com/spreadsheets/d/<GoogleDocsKey>/pubhtml

4. Remove ‘pubhtml

https://docs.google.com/spreadsheets/d/<GoogleDocsKey>/

5. Add ’export?gid=0&format=csv’ to the end of the URL to replace ‘pubhtml’

https://docs.google.com/spreadsheets/d/<GoogleDocsKey>/export?gid=0&format=csv

6. In the ArcGIS Online Map Viewer, click Add, then choose Add Layer from Web:

 

7. Choose CSV and paste the newly formatted Google Docs URL into the URL field and click Add Layer:

Now that your Google Docs CSV is added to the map, if it is updated, the changes will be displayed in the map. Easy! 

PrintView Printer Friendly Version

EmailEmail Article to Friend

Reader Comments (1)

Note that you have to make sure that the document is shared with 'anyone with the link' or 'public on the web', otherwise you might receive the error 'the layer was not created because no locations could be found. Make sure your data has valid addresses or geographic coordinates (latitude/longitude).
July 15, 2014 | Unregistered CommenterChris

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
Post:
 
All HTML will be escaped. Hyperlinks will be created for URLs automatically.