Select to view content in your preferred language

Map a Google Sheet

1408
9
07-31-2023 12:36 PM
Labels (1)
Kylie
by Esri Regular Contributor
Esri Regular Contributor
6 9 1,408

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

GoogleSheetPubToCSV.gif

(*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

3773f597-449c-409b-a240-b0c5ee8f2875.gif

  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!

9 Comments
About the Author
Our kids need GIS in their problem-solving toolboxes. I'm working to get digital maps into each K-12 classroom and the hands of each child. A long-time Esri employee, I've previously worked on Esri's mobile apps, focused on documentation and best practices. Out of the office I'm a runner often found on the trails or chasing my children.