How to map addresses from Excel?

How to map addresses from an Excel?


The Free Spotzi Mapbuilder allows you want to map addresses from an Excel file. This can be achieved by geocoding (what is geocoding?) your Excel file. After geocoding your Excel file with addresses our system will automatically plot them on a map in your Mapbuilder account. To achieve this, please register a free Spotzi Mapbuilder account and read the tutorial below:

We will use the following table to geocode.

Description1 Description2 Street Number Zip_code City Country
Spotzi Office the Netherlands Veilingdreef 35 4614RX Bergen op Zoom The Netherlands
Spotzi Office Canada King Street West 125 M5V 3S5 Toronto Canada

 

Tip! Don’t use any special characters and numbers in the table header
Keep in mind that the use of special characters (%, #, @) and numbers in the table header might cause an error when you want to geocode a CSV/Excel. To make sure that geocoding works properly, please use text-only table headers.

Step-by-step guide


To geocode the data from the above example you have to follow the steps below:

1. Log into your account, go to My Maps and press CREATE MAP.

Create a Map from a CSV with Adresses

2. Click on CREATE MAP FROM FILE.

Create a Map from a CSV with Adresses

3. Type a name for your dataset into the field TABLE NAME  and click on FILE to select the file you want to upload to the Spotzi Mapbuilder. Press IMPORT.

Create a Map from a CSV with Adresses

4. The system checks whether your dataset contains a geometry. If this is not the case Spotzi will display a notification that your dataset needs to be geocoded. Press the GEOCODE button to start this process.

Create a Map from a CSV with Adresses

5. You need to tell the Spotzi Geocoder which colums in your dataset refer to a specific location (e.g. a city name). Spotzi will prefill most columns, but you can choose other columns if necessary. Got multiple values in one column (like street and house number)? Select the same column for both location types. Press IMPORT.

The number of rows is limited
Keep in mind that for free accounts the number of Excel rows is limited to 10,000. If you want to geocode more rows at once, please contact us.

Create a Map from a CSV with Adresses

6. The Spotzi Geocoder is now analyzing your file. It tries to find as many locations as possible. The more information you provided in the previous steps the better it can handle your data. The progress bar  that has appeared on the interface tells you how far the analysis has advanced. 

Create a Map from a CSV with Adresses

7. After your data has been uploaded successfully  you will be able to access your data on your MY DATA homepage. To get to the MY DATA homepage press the link you can now see on the interface. 

Create a Map from a CSV with Adresses

8.  On the MY DATA page you can create a map from your data. In order to do so press the CREATE MAP button on the right side of the name of your dataset.

Create a Map from a CSV with Adresses

9. Give your map a name (max. 48 characters) and press CREATE MAP.

Create a Map from a CSV with Adresses

10. After your map has been created successfully you can open it by pressing OPEN MAP.

Create a Map from a CSV with Adresses

11. Congratulations! You have successfully mapped out your Excel file with addresses. Now it is time to style your map the way you like. For more information about styling your map, please consult the topics styling multiple features or styling each feature individually  in our help center.

Create a Map from a CSV with Adresses

Ready-to-use Addresses Data in the Spotzi Datashop
Did you know that Spotzi also has addresses database with ready-to-use address data you can instantly plot on a map? Visit our datashop and search all our address datasets.