Google Sheets

Map a public Google Sheet in Felt by pasting its link, and keep the layer current as the sheet changes.

Add a public Google Sheet to a Felt map by pasting its link. Felt places rows the same way it does for an uploaded spreadsheet. See Spreadsheets and geocoding.

Add a Google Sheet to a map

Felt reads only sheets that anyone with the link can view, not sheets shared only with your organization or with specific people.

1. In Google Sheets, click Share. Under General access, select Anyone with the link, with the Viewer role.

2. Open the tab you want to map, and copy the link from the browser's address bar. A link to a specific tab ends with gid= and a number.

3. Paste the URL in Felt: click the map and press Cmd+V (Mac) or Ctrl+V (Windows). The layer appears in the legend with the sheet's name.

To map several tabs, add each tab's link, and each tab becomes its own layer.

If the sheet is private, Felt shows Google Sheet is private, try updating its permissions. Change the sharing, and then click Check again.

Keep a Google Sheets layer in sync

To pick up changes to the sheet automatically, turn on Live for the layer. See Set up a live layer. Edits you make to the layer in Felt don't sync back to the sheet.