Keyboard shortcuts

Press ← or → to navigate between chapters

Press S or / to search in the book

Press ? to show this help

Press Esc to hide this help

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

  1. 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

  1. In MapHub, click New map at the top. An empty map opens.

  2. On the right, click Import, then Select file. Your computer’s file window opens.

  3. Click your spreadsheet, then Open.

  4. Wait a moment while MapHub finds each address. A marker appears on the map for every row.

Check and save

  1. Click a marker to see its details. Your other columns show under the title, and a Website column becomes a link.

  2. 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.