Mapsimise accepts data imports from CSV (comma separated) or XLSX (Excel XML format). Data is imported into Mapsimise Data Tables. Most business applications will allow you to export your data in CSV format.
To put your data on a map with Mapsimise, your exported sheet will need columns containing either Address Lines or a Latitude/Longitude pair (or both!)
Your exported data will also need to have the first row as column headers.
Address Lines
Mapsimise will convert your exported address-based data to latitude and longitude to display it on a map. For this to happen, your data will need one or more of the following fields as columns:
Street Line 1
Street Line 2
Street Line 3
City
County
State
Postal Code/ZIP
Country
It’s not important what the columns are named as Mapsimise allows you to choose the appropriate columns to use as address fields.
Here’s an example of a contact list with address fields, ready to import into Mapsimise:
Note that in this example sheet, only one address line is provided. This would be mapped to Street Line 1 in the Geocode Rule for the uploaded data table.
Latitude/Longitude
If your data already has latitude and longitude values, simply export these with your data and make sure the column headers are labelled as Latitude and Longitude. Mapsimise will automatically detect correctly labelled lat/long columns.
Here’s an example of a dataset with Latitude and Longitude columns:
Not that while there is some address data included in the sheet, Mapsimise will automatically map the data using the Latitude and Longitude fields provided.
Other Data Fields
You may include any other data with your export to import into Mapsimise. You can then show some or all of this data when a marker is clicked on a map, or in the data grid shown below the map view.
Examples of data you might include on a sheet to import into Mapsimise:
Names (first/last/full)
Email address
Phone numbers
Dates
Identifiers (ID fields – numerical, string or GUID)
Currency amounts
Mapsimise will attempt to detect the type of data in each column by inferring it based on a sample of the records in your sheet. In most cases, you can change this type after the data has been imported.