Back to Google Sheets Portal

CMaps Analytics for Google Sheets User Guide

IntroInstall CMaps Analytics Add-InRemove CMaps Analytics Add-InLaunch CMaps Analytics Add-OnData TabDesign TabPreview MapMaximized Map ToolsCreate and Import a Custom TemplateVideosTroubleshooting

Introduction

CMaps Analytics Extension for Google Apps allow users to create and analyze Location Intelligence directly inside of Sheets. This geographic visualization and analysis solution injects the Business Intelligence functionality to the average business user.

screenshot

Install CMaps Analytics Add-In for Google Sheets

FROM GOOGLE SHEETS

In the main menu, select Add-onsGet Add-ons to launch the Google Marketplace

install

In the upper right corner of the Google Marketplace, you can search for “CMaps”

Capture

Click on the icon for CMaps Analytics

960_4

Click on the “FREE” button to install the Add-in

free

The Add-on will prompt you, indicating there are permissions requirements to use CMaps Analytics in Google Sheets.

permission

Press Continue

Google Sheets will present you with a list of permissions, similar to other Add-ins.

Review the CMaps Analytics Permissions and Security guide for a complete review of permissions and how CMaps Analytics uses those permissions.

permission2

Press “Allow”

Google Sheets will refresh and notify you where to access your new Add-on and which one you need to select.

where

You are now ready to fire up CMaps Analytics Add-on and start building amazing maps experiences!

Remove CMaps Analytics Add-On for Google Sheets

In the main menu, select Add-ons > Manage Add-0ns

remove1

Locate CMaps Analytics and click on the Manage button

Click on Remove

remove2

The add-on will no longer be available for use.

Settings that you previously saved for the add-on may no longer be available.

CMaps Analytics is accessible from the Add-On menu in Google Sheets

cmapssheets

Data Tab

Data tab is where you connect data from your spreadsheet into the map.

screenshot3

The data tab has 1 mandatory property and 3 optional properties:

Locations (Geographic Locations)

Select the column with your geographic locations. It can be a state, country, address, or comma separated latitude,longitude. Note, that addresses are limited to 100 locations in standard and lite versions

Latitude Longitude

Here we are using Latitude,Longitude if you didn’t have latitude and longitude in the same cell, your can use a simple formula to combine 2 columns with latitude longitude like this =A2&”,”&B2

Examples Type Limits per Sheet
37.7693911,-122.4175 Latitude,Longitude Unlimited

Address / Cities

Here we are using an address. The more details you provide, the more accurate your geocode.. Note that in the standard version you can only do up to 250 geocodes, so if you have more points, you can use unlimited Latitude,Longitude

Examples Type Limits per Sheet
1333 Camino Del Rio S, San Diego CA Address or City 200

States

When using States, it is a best practice to use the state and country to ensure you get an accurate result. You can plot as many states/provinces in a map as you like and don’t have to worry about using uppercase / lowercase values

Examples Type Limits per Sheet
TEXAS, usa State 200

Countries

You can use a country name or abbreviation to plot points. You can place as many countries on the map as you like.

Examples Type Limits per Sheet
Canada Country 350

Postal Codes / Counties

Examples Type Limits per Sheet
85260, AZ Postal Code 1100

You can use postal codes for most counties in CMaps Analytics. Note that for zipcodes, you generally want to include the zip and state to ensure the best accuracy

Map Labels

Select the column with labels that you would like to see when you click on individual points or regions. The for intermediate to advanced users, you can combine (concatenate) multiple columns and also use HTML to format your labels.

Simple Examples

Doctor 4243434
Category 1

HTML

Doctor <b>424343</b></br>Category 1

Numeric Values

Select the column with numeric values that you would like to view in the map and use for other functionality like color (choropleths) or other additional features in CMaps Designer.

NOTE: Value formatting is stripped out, so inside of CMaps Analytics $ are removed and % is represented as decimals. This is a future planned functionality to inherit cell formatting.

Colors

(Optional) This is an optional column where you can define colors using hexadecimal color codes.

Example Color Red:
#FF0000

Design Tab

Design tab is where you choose the visual template and user experience for viewing and interacting with your data.

screenshot2

CMaps Analytics currently ships with 6 standard templates that offer the greatest span of functionality for visualizing data in any geography.

Points

Basic points on the map.

standard

Bubble

Bubble view uses the values in your spreadsheet to modify the icon size.

bubble

Choropleth

Choropleth uses the values in your spreadsheet to modify the color and highlight high / low values using color intensity.

choropleths

Clustered Summary

Clustered summary will group together locations in close proximity, summarize the values and provide a count.

choropleths_clustered

Density Map

Density map will display color-based density as locations overlap on top of each other.

heatmap

Advanced InfoWindow

What if Google designed its side panel for analyzing data instead of viewing restaurant ratings? Our Advanced Infowindow was built for Business Intelligence for filtering, ranking, searching, and analyzing your data within a map.

advancedinfowindow

Custom Maps Templates

To create and import custom templates, you need CMaps Analytics Designer

You can customize any of the maps templates that come out of the box, or create your own with additional functionality like regions, additional interactivity, and one of over 15 other layer visualization types. These templates can be loaded from CMaps Analytics onto Google Drive.

Launch CMaps Designer

Custom templates can be loaded into CMaps Analytics Add-On from Google Drive, or from another server where you have the CMAPS template file hosted.

gdrive url

View Map

Preview map provides instant access to your data in a map view, so you can quickly explore and experiment.

screenshot

Maximize

max

When you click “Maximize” it will open your map into a larger popup window, so you can further explore, analyze, and drive action

Maximized Map Tools

max

On the Map View tab, when you click “Maximize” it will open your map into a larger popup window, so you can further explore, analyze, and drive action using additional tools

Export Locations to Spreadsheet

CMaps Analytics contains multiple features to make maps more useful in a spreadsheet application. Currently the map tools are available when the map is maximized

options

 

Visible on Map

As you pan and zoom in CMaps Analytics, it will filter out locations that are not visible on the map. Clicking on “Visible on Map” will export on the visible locations to a brand new tab.

Selected on Map

Using the “Multi-Select” options in CMaps located in the upper right corner, you can use a variety of interactions and gestures to select items within the map. When you select more than 1 location, you gain the ability to export those selected item to a new tab by clicking “Selected on Map”

 

multiselect

When you are ready to move beyond the standard templates, or want to further customize CMaps Analytics templates, you can utilize CMaps Analytics Designer to further customize maps to your business requirements, and then import them into CMaps Analytics Add-On directly from Google Drive.

TUTORIAL: Import CMaps Analytics Designer templates

mapsanalytics

Videos Coming soon!