Feature available in: PRO plan
Whether you want to look at your portfolio of customers or your suppliers’ locations, the ability to add points to a map can be a key functionality for analyzing your catchment area.
Important: All data imported into smappen is stored locally on your computer, in order to guarantee the security and confidentiality of your data.
With smappen, for more detailed analysis, you can import your own pins onto the map from an Excel file.
Preparing the file to be imported #
To import pins onto the map, you must have an Excel file containing the list of addresses or GPS coordinates corresponding to your datapoints.
- Clean Address with the country (United States, United Kingdom, …)
- Postal Code/ zip Code with the city and the country
- Lattitude, Longitude
The first line of your file absolutely must be a header. There must be at least one column for the addresses or GPS coordinates. Here is an example of a format that could be imported:
Your file can have as many columns as you want.
Important: The cells containing the addresses must not contain any line breaks.
Saving the file as a CSV #
To import your file into smappen, you must save it in CSV format. In Excel, the procedure for saving a file as a CSV file is as follows:
- Click “File” > “Save As”.
- Pick the location where you want to save the file.
- In the “Save As” dialog box, browse to your chosen location.
- Click on the arrow in the “Save as type” box and pick “CSV UTF-8 (Comma delimited)”.
Importing the data #
To start importing the data, click on “Add your data” on the data-analysis panel:
Then, click on “Add Data”:
This opens the data-import window:
Enter the name you want to give your dataset, and choose the .csv file to import.
Then, select the name of the column containing the data that will enable geolocation of your datapoints:
Click on the “Import” button. Wait until the importing process is completed and then click on “Close”.
To go further: