Map a Google Sheet

[Kylie]

You have information in a Google Sheet that you want to see in a map. No problem! Publish your Google Sheet as a CSV and add it to the map in ArcGIS Online.

Part 1: Publish your Google Sheet as a CSV

(*If you click on a video, you will see it larger.)

1. Open Google Sheets and open your CSV. It might be one that you created, or one that you saved to your sheets.
   Your CSV needs to be properly formatted:
   • Start the table in the top left corner of the sheet.
   • You can't have any non-numeric characters in the latitude and longitude columns. 
   • Watch for random words or sentences above or below the main content.
   • Ensure latitude and longitude values are always in the correct columns - we see some values flipped in some rows of some sheets.
   • The type of your cell (for example, numeric) needs to match the contents in it. In particular, be careful of degree symbols or letters like N and W in numeric fields.
2. Click File > Share > Publish to web.
3. In the link tab, make sure the first drop-down is set to Entire Document and in the second, choose Comma-separated values (.csv).
4. Click Publish.
5. Click OK if asked if you are sure you want to publish.
6. Copy the link that is shown by pressing Control-C on your keyboard.
7. If you want changes to your Google Sheet to automatically appear in the map, verify that Published content & settings > Automatically republish when changes are made is enabled.

Part 2: Add your published CSV to the map

1. Log in to ArcGIS Online and open Map Viewer.
2. Click Add > Add layer from URL.
3. Paste in your URL (click Control-V on your keyboard) and click Next.
4. Choose Reference the file from the URL and add it to the map and click Next.
   By referencing the file, changes you make to your Google Sheet will appear in the map.
5. In the Fields dialog, accept the defaults and click Next.
6. In the Location settings dialog, make sure the fields with latitude and longitude in your spreadsheet were correctly identified. If not, correct them.
7. Click Add to map.

Your data appears in the map! The information from your spreadsheet is available in the pop-ups. Now you can customize the symbology and pop-up, making a great map of your data.

Want to try it out?

Check out the great storymap my coworker Tom put together!