Map to Sheets easily connects your map with Google Sheets. So, you can now leverage the power of Google Sheets to manage your map data.
You can add, update or delete locations and even publish your map. With two-way synchronization, the Mapme editor and Google Sheets are always the same.
Leverage Google Sheets formulas and editing power
The Mapme editor is designed to be fast and easy to use. However, Google Sheets offer many benefits when entering or editing a large amount of data. Here are some examples
- Copy and paste a value across locations
- Delete multiple locations at once
- Use formulas to create dynamic content like including a date field in the description
- Concatenate the content from multiple cells. For example, this can be very useful if you have streets, cities, and zip codes in different fields.
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.
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
You can now have users update your map without the need to login into the Mapme Editor. You can create a group of users with Mapme Editor access and a group of users with Google Sheets access only. Those users can only make changes to the map data. You don’t have to worry about those users making changes to your map settings or making changes to another map in your account.
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.