Designer Data Copy and Paste from Spreadsheet

 Copy and Paste Data into CMaps Analytics

Pasting tab delimited data directly from Excel is supported in CMaps Designer, as an approach to quickly prototype and test layers.


Data Formatting Logic and Security

CMaps Analytics Designer provides a mechanism to test and preview simple data sets directly inside of Designer by copying / pasting from Excel.


You should copy / paste data into CMaps Designer to quickly prototype maps, test features, or deliver a map where the data does not change.


Copying and pasting data into CMaps Designer will keep the data in your browser and embed it inside the .CMaps template file.


CMaps Analytics will NOT transmit data that you copy and paste into CMaps Designer. Instead this data is loaded onto your map locally, within the browser.


If you want to load data into CMaps Analytics from a cloud data store, we recommend using CartoDB for cloud storage, or for more robust data models and dashboards Antivia DecisionPoint (supports CMaps Templates).

Data Column Definitions and Ordering

Column ordering grants control to a designer to modify the default column data order based on your original data set. While it is generally recommended to load data into CMaps Designer using the default order, there could be scenarios where a map may need to accommodate data that is slightly different in ordering of columns. Simply drag and drop the columns to change the order.



Any address value or comma separated latitude,longitude: Example: 43.43434,-33.54545


The label is the name of each asset (point of interest or shape) displayed in the InfoWindow, chart, tile, and other views. It is the primary identifier visible to mobile users. Example: Dr Klauss

Value (measure)

A value is a numeric value associated with each point or region. This value is used for dynamic icon sizing, alerts, and chart visuals. Currently CMaps Designer supports 1 measure at a time. You can easily toggle between measures using the CMaps Designer API. Example: 45000


If you want to define the color in your data rather than the property sheet you can use hexidecimal color codes to change the color of points or shapes: example: #FF0055


Category is a placeholder for future functionality, including embedded pie charts, and other visualization options.

Drill ID

Drill ID represents the parent and child elements when you are drilling between multiple layers. The Drill ID establishes a simple hierarchy. When using more than 2 levels, any layer in between top and bottom must contain both the parent, and current drill levels with a “|” delimiter.

Examples are illustrated below:

Example 1 is 2 Layer Hierarchy

Layer 1

Label  |   Drill ID

West    West
East     East

Layer 2

Label  |   Drill ID

CA    West
NV     West
NY    East
FL     East

Example 2 is 3 Layer Hierarchy

Layer 1

Label  |   Drill ID

West    West
East     East

Layer 2

Label  |   Drill ID

CA    West|CA
NV     West|NV
NY    East|NY
FL     East|FL

Layer 3

Los Angeles    CA
San Diego       CA
Nevada           NV
Reno               NV