5 tips to turn data into maps and create a map data visualization

Create a map data visualization with these 5 tips


At Spotzi we believe that a map tells you more than any Excel sheet or data table. The Spotzi Geocoder enables you to turn addresses into points on a digital map. Got any data by postal code area? In that case the Spotzi boundary data and the Join App might come in handy.

Our location data specialists are turning data into maps every day. That’s why we asked them some PRO tips you can use when you want to create maps/dashboards with our Spotzi Plans.

Tips

1. Think about what kind of map you want to create

Do you want to turn your data into points on the map or do you want to add your data to areas on the map? Every solution needs a different approach. Remember that you need the Spotzi Geocoder to turn addresses into points on the map and you need the Join App and postal code boundaries to add your data to areas on the map.

5 tips to turn data into maps and create a map data visualization

2. Make your Excel geocode-ready

To make sure the Spotzi Geocoder can process your CSV/Excel well, please create a file where you give as much information as possible. The more information you give the better the Spotzi Geocoder will determine the right location.

5 tips to turn data into maps and create a map data visualization

3. Check for hidden rows or special characters

Always check your CSV/Excel before importing it into the Spotzi Mapbuilder. Check if your file contains any hidden rows or special characters that might cause errors when geocoding. This article shows the most common errors when importing a file.

5 tips to turn data into maps and create a map data visualization

4. Consider using our addresses database

Do you have a file with more than 10,000 locations that you want to plot on the map? In that case you might want to consider one of our addresses data sets.

5 tips to turn data into maps and create a map data visualization

5. Connect points to areas with spatial join

Did you already turn your Excel file into a map with points, but do you want a map with areas? In that case, you might need a spatial join. This functionality connects the information of points to the areas it intersects with.

UC2-data-maps5(1)

Turn data into maps with our Location Plan

Our Location Plan offers you all the tools you need to map out your data. You can geocode addresses from your Excel file or you can join your data per postal code to the boundary data that is included in this package.