Help Center / Map Addresses /

Map Addresses

In order to map the locations within your CSV or Excel files you must ensure that your files come equipped with the right geometry data. To do this, simply import your file into Spotzi's platform and use the Spotzi Geocoder to fill in any missing geometry. Continue reading to learn more about this process.


Before you get started

Preparing an Excel file with addresses for geocoding is an essential step to ensure accuracy and efficiency in the geocoding process. Here are some tips to help you prepare your Excel or CSV file for geocoding:

Import your list of addresses

Map addresses

1. Go to your home screen and open the MAP ADDRESSES option to start.

Import addresses file

2. Select the option FROM A FILE and click NEXT STEP.

Start geocoding

3. Name your map and select the CSV or Excel file you would like to import. Click IMPORT to confirm.

Select fields to geocode

4. As your file currently does not contain geometry to plot addresses on the map, the system prompts whether you would like to geocode the addresses. Click on GEOCODE to initiate this process.

5. Inform the geocoder of which dataset columns refer to a specific kind of location (e.g. a city name). Spotzi can autofill most columns for you, but you have the option of choosing other columns if necessary. If you have multiple values listed in one column (such as street names and house numbers) please select the same column for both location types. Press IMPORT when you're ready.

Start geocoding

6. The geocoder will take a moment to analyze the file you provided and will inform you of its progress via a progress bar. Providing as much information as possible in the previous steps of this process will assist the Geocoder in performing a faster analysis. Click OPEN DASHBOARD when the geocoding and mapping of your data is complete.

Open dashboard with pins

7. Congratulations on successfully generating a map with pins from your list of addresses! It's now time to style your map in any way you'd like.

Map Styling Options

Dashboard styling and data blocks

Map styling is an essential part of customizing your geomarketing dashboards. A well-selected range of colors makes a big difference in how a viewer might interpret the data you’re presenting. Spotzi’s predefined map styling options allow users to effortlessly create attractive and insightful dashboards. You can also stylize custom maps in order to match your brand identity — or that of a client! Our interface allows you to customize markers, icons, logos, colours, and even your own CSS. You have the following options:

For more information about Map Styling Options, please visit our page about Map Style Editor.

Customize your dashboard

Now you have styled your map, it is time to customize your dashboard. With Spotzi you can add graphs, text, images, change the layout and many more. Everything to enhance data communication, enabling storytelling and informed decision-making. It engages users, provides context, and offers a deeper understanding of geographic data. Aesthetically pleasing and inclusive, this approach amplifies the impact of your dashboards. In the dashboard customizer you have the following editing options:

For more information about setting up your dashboard further, please visit our page about Dashboard Builder.


Related blog posts

Access the Free Spotzi Explorer

Gain access to our free catalog of maps and dashboards. Find Postal Codes, learn more about global income differences or just get inspired by our community maps. Spotzi Explorer is our free solution for every marketer, researcher, student and beyond. Available as a stand alone solution and part of our price plans.

Get free access to Spotzi Explorer Read more
thumbnail New Partnership with OOH Info LLC: Revolutionizing OOH Optimization


New Partnership with OOH Info LLC: Revolutionizing OOH Optimization