Copy and Configure Map Data from Excel

STEP 1: Copy data from Excel or Google Sheets. This is a TSV (Tab Separated Values)

STEP 2: Select copy/paste option

STEP 3: Paste the Excel data into the text box and press OK

STEP 4:

If your data has Titles in the first row (“City�, Label�, etc), you can check the box that tells the data mapping process to use the first row.

NOTE: If you do not have data titles, it is not required. However, if you do have data fields and do not check the box, the map will attempt to render the first row of data on the map, which can cause errors. 

STEP 5: Map your data “Type� using the type dropdown.

Location (required)

CMaps Analytics requires a “Location Type� as the only mandatory field to render data on the map.

For point based layers, location can be a comma separated latitude,longitude,  or any geography which can be geocoded in real-time.

For regions, your location must be an administrative area supported by CMaps Analytics. For custom regions powered by ESRI Shapefiles or GeoJSON, the Location data must match the data keys provided alongside the shapefile. LEARN MORE

 

Labels:

Labels can contain text or basic HTML so you can create more complex popup infowindows.

Values

Values are numeric values which can be used to change color, size, and powers a number of calculations available in Advanced InfoWindow. If you have multiple values, in your data you can use additional “Measure� Types.

To change the value to another measure (column) in the map, you can utilize the Advanced InfoWindow Summary LEARN MORE

SKIP A COLUMN
If there is a column of data that you want to ignore, you can skip the mapping process.