Map an address spreadsheet
Have a list of places with their addresses? In this guide you turn the spreadsheet into a map with one marker for each row. MapHub finds the addresses for you, so you don’t need any coordinates.
To follow along, download the sample spreadsheet chicago_places.xlsx.
Prepare your spreadsheet
- Put one place on each row, with a Name column for the titles and an Address column. Write the full address, including the city, ZIP code and country. Other columns can stay.
Import it
-
In MapHub, click New map at the top. An empty map opens.
-
On the right, click Import, then Select file. Your computer’s file window opens.
-
Click your spreadsheet, then Open.
-
Wait a moment while MapHub finds each address. A marker appears on the map for every row.
Check and save
-
Click a marker to see its details. Your other columns show under the title, and a Website column becomes a link.
-
In the Map tab, type a Title and click Save. Your map is saved and ready to share.
Addresses in several columns
If the street, city and ZIP code sit in separate columns, combine them in a new Address column first. A formula like =TEXTJOIN(", ",TRUE,B2,C2,D2,"USA") does it; fill it down, then copy the column and paste it back as values.
For column names and more options, see XLSX / CSV import.