How to show customer locations on a map from Excel
A list of addresses becomes far easier to read on a map. Here is what your spreadsheet needs.
The short version
- Address columns or lat/long
- Counts and totals per location
- Filter the map with your dashboard
How do I map a list of addresses from Excel?
Make sure each address is in its own columns (street, city, state, zip), or has latitude and longitude. Upload the file and add a map to your dashboard.
What columns do I need?
Either the address columns, or a latitude column and a longitude column. Coordinates are instant and exact.
Can I show more than pins?
Yes. Size or label markers by a count or a total, for example open jobs per site.
See it with your own data
Tell us what you want to report on. We will set up a walkthrough built around your own kind of data.
Request a demo