How to Plot Multiple Addresses on a Map: 3 Free Ways

September 12, 2026 ·8 min read

Sometimes you do not need a route at all. You need to see where the addresses are: how far apart they sit, whether one of them is nowhere near the others, whether the job is worth taking. That is a different question, and it has a faster answer. Below are three free ways to put a list of addresses on one map, and how to choose between them.

Short answer

The quickest way to put a list of addresses on a map is to paste the whole column at once into a planner that accepts a list. Every address becomes a numbered pin, and you can look at the shape of the day before deciding anything. Building a route is a separate action you can simply not take.

If you want to try it right now, paste your addresses into our free address-plotting tool. It takes up to 200 addresses at a time, with no account.

The three free ways, in short:

1. Paste the list into a map tool that accepts many addresses at once. Best for a quick look at up to 200 stops.
2. Copy a column from Excel or Google Sheets and paste it as text. Best when the list already lives in a spreadsheet.
3. Import a file into Google My Maps. Best for a permanent map of hundreds of locations.

Way 1: paste the list and look at the pins

Plenty of real questions are answered by the picture alone:

• Is this day even feasible? Twelve stops in one neighborhood and twelve stops spread over sixty miles are very different days.
• Should we take this contract? Seeing the cluster tells you more than a row count.
• Which driver gets which half? Splitting work by geography needs a map, not a spreadsheet.
• Did the export come through correctly? One pin in the wrong state is instantly visible and completely invisible in text.

For all of these, pasting is the fastest path. Here is how it works in three steps:

1. Prepare one address per line. Street, city, state and ZIP in one line works best. A missing city is the most common reason a pin lands in the wrong place.
2. Paste everything at once. Copy the whole list from a note, an email or a document and paste it into the box in one go. Typing addresses one at a time is fine for three stops and painful for thirty.
3. Look at the map. Every address becomes a numbered pin. Anything the tool could not find is listed separately, so you can fix it and paste again. Stop here if the picture was all you needed.

In Daymilo this takes a few seconds for up to 200 addresses per paste. The pins are numbered in list order, the list and the map stay linked, and computing a driving order is a separate button you do not have to press.

The point of this method is speed. You are not setting up a project, naming layers or choosing pin colors. You are answering one question about one list, and then you are done.

Way 2: plot addresses from Excel or Google Sheets

Most address lists start life in a spreadsheet: an export from an order system, a customer list, a sign-up sheet. You do not need to save a file or upload anything to see those rows on a map. Copying the column as text is usually faster.

1. Get the full address into one column. If street, city, state and ZIP sit in separate columns, join them first. In Excel or Google Sheets a formula like =A2&", "&B2&", "&C2&" "&D2 in a new column does it. Fill it down to the last row.
2. Select and copy the column. Click the first cell, shift-click the last one, then Ctrl+C (Cmd+C on a Mac). Skip the header row, or delete it after pasting.
3. Paste it as is. Each row becomes one address and empty rows are skipped. If you want the stops in driving order rather than only on a map, use the Excel addresses to route page, which takes the same pasted column and orders it for you.

A few spreadsheet habits that save time:

• Watch for merged or wrapped cells. A line break inside one cell can split one address into two rows.
• Keep apartment and suite numbers after the street, not in a separate column you forget to join.
• Check the ZIP column format. Spreadsheets sometimes drop the leading zero from ZIP codes in New England and New Jersey, and 02139 becomes 2139. Format the column as text before you join it.

Way 3: Google My Maps for bigger sets

If the list runs to hundreds of rows, Google My Maps is the better tool. It imports a spreadsheet file directly, reads the address column and drops a pin per row, and you can style pins by a category column.

It is heavier to set up, it requires a Google account, and it is not built for the quick look. For a one off question about twenty addresses, pasting a list is faster. For a permanent map of four hundred customer sites, My Maps is the right home.

A sensible split: use My Maps for the map you keep and share with the team for months, and use a paste tool for the map you need in the next two minutes.

Comparison: free ways to map a list

Google Maps directions are listed because people often try them first. They are built for driving a short list in the order you typed, not for seeing a large set of addresses at once.

What a map shows that a list cannot

A column of addresses hides everything about geography. The same twenty rows could be one tight neighborhood or a shape spread across a county, and the spreadsheet looks identical either way.

On a map you see immediately:

• how many natural clusters there are;
• which stops sit between clusters and could belong to either;
• whether a river, a highway or a bridge splits the day in a way that the straight line distances do not suggest;
• whether one address is an obvious mistake.

That last point matters more than it looks, so it gets its own section.

Spotting a bad address

This is the most valuable thing the map does for you, and it is worth being blunt about why.

Geocoders very rarely say "not found". Given something ambiguous they return the closest plausible match, with a confident looking pin. A missing city, a misspelled street, an apartment number in the wrong field: each of them quietly resolves to a real place somewhere, and the only signal that anything is wrong is that the pin sits away from everything else.

A pin fifty miles from the rest of the day is either a real job or a typo. Both are worth knowing about before you start driving.

When you find one, the fix is almost always the same: add the city, state and ZIP to that line and paste it again. If the pin still lands far away, the address itself may be wrong in the source data, and that is worth a call to the customer before the driver goes looking for it.

Doing this on a phone

It works, and for a quick check in the field it is often where you are. Paste from a message or an email, let the pins land, pinch to fit them all on screen. The map sits below the list on a small screen so you can scroll the addresses without losing the picture.

One thing to know: on a phone a single finger scrolls the page and two fingers move the map. Without that rule a full screen map turns into a scroll trap.

If someone else will drive the stops, you do not need to send them a spreadsheet. Once the route is built, tap Share and send the link by text or chat. The driver opens it in the phone's browser and sees the stop list in order, with no app and no account. From there each stop can be opened in their usual maps app for turn-by-turn directions.

From pins to a driving order

If the picture makes you want the route after all, nothing is lost: the addresses are already in. Set a start, press the button, and the same pins get renumbered into a computed driving order.

That is the sequence most people actually want: look first, decide second. The map tells you whether the day makes sense; the route tells you the order to drive it. For a longer list, or when you know from the start that you need the shortest order, go straight to the multi-stop route planner, which takes up to 200 stops and reorders them into a shorter drive.

Ready to see your own list? Paste your list into the map tool and every address becomes a numbered pin in seconds. Free, no sign-up.

FAQ

How do I put multiple addresses on one map?

Paste the column of addresses into a tool that accepts a list, and each row becomes a pin. Adding them one at a time works too but is much slower past a handful.

How do I map addresses from Excel?

Put the full address in one column, copy that column and paste it into a map tool as text. Each row becomes one pin. If street, city and ZIP are in separate columns, join them with a formula first.

Can I do this without building a route?

Yes, and often you should. Plotting the pins and computing a driving order are separate steps, and the picture alone answers plenty of questions.

How many addresses can I plot at once?

In Daymilo, up to 200 addresses at a time. Google My Maps handles much larger sets if you need hundreds of pins.

Can I import a spreadsheet file?

Google My Maps imports files directly. For a quick look, copying the address column and pasting it as text is usually faster than any upload.

Why is one of my pins far away from the others?

Either it is a genuinely distant job or the address was ambiguous and the geocoder picked the wrong match. Both cases are worth checking before you drive.

Does plotting addresses cost anything?

No. Putting a list of addresses on a map is free in Daymilo and in Google My Maps alike.