CMaps Analytics Extension Google Sheets, provides custom Google Maps visualizations right inside of your spreadsheet. With CMaps Analytics Designer you can create your ultimate maps experience from your browser, and import templates into Google Sheets, so you can connect to your spreadsheet data.
What is a custom template?
A custom template can include your custom regions and territories, public facing feeds with weather, standard geographies like country, state and zip, advanced visualizations for drive time and hub-spoke diagrams. Simply Open CMaps Analytics Designer, create your map, publish to Google Drive and import it into any Google Sheet.
Requisites
- Install CMaps Analytics Extension Point
- A valid login for CMaps Analytics Designer
Have created a first Google Map in Google Sheets
Build a Map Template with CMaps Analytics Designer
CMaps Analytics Designer Resources
CMaps Analytics Designer Portal
5 Minute Tour of CMaps Designer
Learn how to build your first map in CMaps Analytics Designer
Expanding your first Map’s Business Value
Known Compatibility Limitations
- CMaps Analytics Add-On for Google Sheets currently supports single layer maps only. This is currently under development and will be supported soon.
Exporting Map Template from CMaps Analytics Designer
The output of CMaps Analytics Designer is a template file (.CMAPS). This file contains all of the details you will need to build maps.
With CMaps Analytics Designer open, and your desired map view created, Click on the Save and Export” which will display all of the export options available to you.
Save a Template / Project file to your local PC.
Load CMaps Analytics Template into Google Sheets
With Google Sheets open in your web browser, click on Add-Ons > CMaps Analytics> Start
Select the Design Tab
Link your .CMAPS template from Google Drive OR from a URL.
Load from Google Drive
Select Google Drive
Click on the radio button for the template you would like to use.
Hover over the “i” icons to view descriptions which can be edited in Google Drive.
Load from URL
If you would like to host your template on another internal / external server, you can load a template into CMaps Analytics Add-on using a URL.
You must use a URL with HTTPS to successfully load your template.
Set the Data Properties to your Spreadsheet Columns 
Select the column that corresponds with each property using the dropdowns. The first row for your data will contain the titles used in the dropdown.
IMPORTANT NOTES FOR CMAPS DESIGNER LAYER TYPES
Regions- For regions like states, countries, counties, etc, the data contained in the Location column must correspond to the Shapefile keys.
