Map To Sheets makes it easy to connect your map with Google Sheets. This allows you to leverage the power of Google Sheets to manage your map data.
You can add, update, or delete locations on your map directly from Google Sheets. Thanks to two-way synchronization, changes made in Google Sheets will be reflected in the Mapme editor and vice versa.
Leverage Google Sheets formulas and editing power
Although the Mapme editor is designed to be fast and easy to use, Google Sheets can offer many benefits depending on your needs. Some examples include:
- Copying and pasting the same value across multiple locations
- Deleting multiple locations at once
- Using formulas to create dynamic content, such as including a date field in the description
- Concatenating the content from multiple cells for example, if you have streets, cities, and zip codes in different fields.
Two-way synchronization
With Map To Sheets, you can update your map in both the Mapme Editor and Google Sheets. The two-way synchronization insures that the data is always the same.
Automatic backups
You don’t need to manually export your data. You can keep a copy of your map data automatically updated at all times.
If you want to keep older versions of your map data, simply copy and paste the data into different sheets.
User access management
Users can now update their map without logging into the Mapme Editor. You can create two groups of users: one with Mapme Editor access and another with Google Sheets access only. The latter group can only change the map data, so you don’t have to worry about them changing the map settings or accessing another map in your Mapme account.
Manage multiple maps
If you have multiple maps in your Mapme account, you can manage them all using the same Google Sheets file. Each sheet will sync with a specific map.
Conflict resolution
If multiple users are updating the same map location in both the Mapme editor and in the Google Sheets, Map To Sheets automatically detects and displays information about the conflict. You can then easily resolve the conflict in Google Sheets by following the conflict resolution process.
How it works?
Follow these simple steps to keep your Google Sheets and the Mapme editor always in sync.
- Connect your map to Google Sheets by entering the map ID and the security token
- If your map already has data, start the sync process to pull the data to Google Sheets
- Add, update or delete locations in Google Sheets
- Publish your map when needed
Click here for the complete Map To Sheet user guide.