How Syncing Works


Connecting to Google Sheets allows you to easily sync changes between your spreadsheet and the map's locations. Once linked, changes from the spreadsheet will be reflected in your map's respective locations. Likewise, changes from Boldmapper will reflect in the spreadsheet on the next sync.

Locations are automatically synced about every hour, but can also be manually synced via the "Sync Now" option on the settings page.

If the same location is updated in both the spreadsheet and Boldmapper, the spreadsheet's change is given priority during sync.

The Sync Template

When you connect a new spreadsheet, you will clone from a sync template. The template includes the following columns:

Column name



Used internally by Boldmapper to track locations in the spreadsheet. As a location is imported to Boldmapper it will be assigned an alphanumeric ID and will be stored in this column. Do not edit these values directly.


The location's name.


The address of the location.


The location's latitude (allowed values: -90.0 to 90.0).


The location's longitude (allowed values: -180.0 to 180.0).


The location's description field.


The location's phone number.


The location's email address.


The location's URL value.


A comma-separated list of the location's tags (e.g. Free WiFi, Open Late). Only tags that have been configured for your map will be applied during sync.

Any cells which have been colored gray in the spreadsheet should not be edited (e.g. headers, internal columns, etc.). Modifying these cells runs the risk of breaking the sync functionality for your map.


By default, your map is automatically synced to the spreadsheet every hour. If you want more granular control of when syncs are performed, you can disable auto-sync from the location sync settings page (Settings > Location Sync > click the clock icon).

To enable auto-sync again, simply click on the same icon.

Last updated