Add a Layer from the Web (.csv) - Google Sheet

10-14-2014 03:05 PM
New Contributor II

I am trying to add my google sheet to ArcGIS Online.  I have the sheet published to the web:


I have some Latitudes and Longitudes, but I am not able to select the fields in ArcGIS to let the program know where to look.  Any suggestions?

0 Kudos
1 Reply
New Contributor II

I was given a little help which is very useful for those using the new Google Sheets.  After selecting the Publish to the Web, you will need to modify the URL.  Replace the last section after the / with /export?format=csv

This will allow you to add the Layer from Web in ArcGIS Online as a csv file and then allows you to select the fields of Latitude and Longitude.