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.

Install CMaps Analytics Add-In for Google Sheets

FROM GOOGLE SHEETS

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

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

Click on the icon for CMaps Analytics

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

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

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.

Press “Allow”

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

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

Locate CMaps Analytics and click on the Manage button

Click on Remove

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

Data Tab

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

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

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

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

Countries

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

Postal Codes / Counties

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.

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.

Bubble

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

Choropleth

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

Clustered Summary

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

Density Map

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

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.

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.

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.

View Map

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

Maximize

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

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

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”

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

Videos Coming soon!