How-to guide

How to map a list of postcodes from Excel

Copy the rows from your spreadsheet, paste them into Map and choose which column is the postcode. UK postcodes are looked up 100 at a time, so a sheet of jobs or customers is on the map in seconds.

5 stepsFreeVideo 25 seconds

What you need

Step by step

1

Open Paste rows

In Map choose Import → Paste rows from Excel, or press Ctrl+Shift+V.

Open Paste rows - Map
2

Paste the rows

Copy the rows in Excel, headings included, and paste them into the box. Map counts the rows and columns.

Paste the rows - Map
3

Choose the columns

Map guesses the name and postcode columns - check them, and match any others (status, tag, your own fields).

Choose the columns - Map
4

Import

Click Import. UK postcodes are looked up in batches of 100; anything else (a street address, a place name) one a second.

Import - Map
5

See them on the map

The locations appear on the map and in the list - colour them by any column with C.

See them on the map - Map

Tips

Frequently asked questions

Is it free?

Yes. Pasting rows, importing Excel and CSV files and the postcode lookup are free in Map, with no account.

Do I need latitude and longitude?

No. A postcode or address column is enough - Map looks the places up for you.

Where do the postcode locations come from?

From postcodes.io, which uses the Office for National Statistics' postcode directory (Open Government Licence). Other addresses come from OpenStreetMap.

Try Map - it's free