How to turn a Google Maps saved list into a lead list

You have clicked Save on a few dozen businesses in Google Maps that look like a good fit. Now you need them in a spreadsheet, with emails and owner names, so you can reach out.

This guide shows how to create a lead list from Google Maps saved places by hand. It covers what Google's export actually gives you, how to fill the gaps, and when a category-and-area search will get you further in less time.

The short version: create a lead list from Google Maps saved places in 5 steps

Save businesses to a custom list, export it with Google Takeout, then add the contact fields the export leaves out. Here is the full workflow at a glance:

1. Create a custom list in Google Maps and save each target business to it, with a short note on why it fits.
2. Export the list through Google Takeout, which gives you a CSV file per list.
3. Open the CSV in a spreadsheet and add columns for website, phone, email, owner name and title.
4. Fill those columns from each business's Maps listing and website.
5. Verify the emails, then import the list into your outreach tool.

Steps 1, 2 and 5 are quick. Steps 3 and 4 are where nearly all the time goes, and that is what decides whether the manual route is worth it for you.

When a hand-picked Google Maps list makes sense for prospecting

A saved list works best when you want a small number of carefully chosen targets and the choice depends on judgment a filter cannot capture. If you need hundreds of leads in one category, a search is the better tool.

Good reasons to hand-pick:

• Account-based outreach. You want 20 to 50 named businesses in a territory, not everyone in the category.
• Visual judgment. You are choosing based on storefront photos, a dated website, a thin menu, or how the owner replies to reviews.
• Field sales routes. The list doubles as a map of who to visit, so seeing the pins together is useful.
• Testing a new niche. You want to look closely at 15 businesses before committing to a bigger campaign.
• Mixed categories. Your targets span several business types that no single keyword would return.

It stops making sense when you notice you are saving nearly every result for a search anyway. At that point you are doing by hand what a search does automatically.

How to create a custom list in Google Maps for leads

Open a business in Google Maps, click Save, and choose New list. Every business you save to that list afterward will show up together and export as one file.

On desktop

1. Go to Google Maps and sign in with the Google account you want the list stored in.
2. Search for a business and open its profile.
3. Click Save.
4. Choose New list, give it a name, and save.
5. For each next business, click Save and tick the same list.

On mobile

1. Open the Google Maps app and tap a business.
2. Tap Save.
3. Tap New list the first time, or pick your existing list after that.

Set the list up for prospecting, not travel

A few habits make the export far more useful later:

• One list per campaign. Name it by niche, area and month, for example: Leads – Dentists – North Austin – May. Takeout exports one file per list, so a clean split saves sorting later.
• Keep it away from default lists. Do not mix leads into Favorites or Want to go, which usually hold personal places.
• Use the note field. In the list view, each saved place has an option to add a note. Notes come through in the export, so this is where you record why you picked the business.

A one-line note format that works well:

Fit: A | Angle: no online booking | Site: dated | Owner: unknown

When you write your first email, that note becomes the personal line. It is the one thing a hand-picked list has that a raw search does not.

How to export a saved Google Maps list with Google Takeout

Google Maps has no download button for lists, so the export runs through Google Takeout. It packages your saved lists as CSV files you can open in any spreadsheet.

1. Go to takeout.google.com while signed into the same Google account that holds the list.
2. Click Deselect all so you do not export your whole account.
3. Scroll to Saved and tick it. This product holds your custom Maps lists.
4. If you also used the old star feature, tick Maps (your places) as well. Starred places export separately from custom lists.
5. Click Next step. Choose delivery by email link, export once, and .zip as the file type.
6. Click Create export and wait for the email from Google. A Maps-only export is usually small, but timing varies.
7. Download and unzip the file. Inside the Saved folder you will find one CSV per list, named after the list.

Open the CSV in Google Sheets or Excel. If the file looks empty, check that you exported from the right account and that the list actually has places in it.

What the export contains and what it is missing for outreach

The Takeout CSV gives you the business name, your note and a Google Maps link for each place. It does not include phone numbers, websites, emails or owner names, so it is a target list rather than a lead list.

Column names have shifted over the years, but a recent export typically shows a title, a note and a URL, plus a couple of columns that are usually blank. Here is how that compares to what outreach needs:

Field	In the saved list CSV?	Needed for outreach?
Business name	Yes	Yes
Your note	Yes	Useful for personalization
Google Maps URL	Yes	Useful for lookup
Address	Usually not (the starred places file does include it)	For local context
Phone number	No	For calls
Website	No	For finding emails
Category, rating, review count	No	For filtering and angles
Email	No	Yes, for cold email
Owner name and title	No	Yes, for personalization
Social profiles	No	Optional extra channel

The gap is bigger than most people expect. The export keeps your selection and your notes, but every contact detail still has to come from somewhere else. For a sense of what a full Google Maps record can hold, see every column in a Google Maps export explained.

Adding emails, owner names and phone numbers to a saved list

Work row by row: open each Maps link for the phone, website and address, then open the website for an email and the owner's name. Record where each detail came from so you can trust it later.

A spreadsheet layout that keeps you organized

Add these columns to the right of the Takeout data:

Business | Note | Maps URL | Website | Phone | Address | Email | Email type | Owner name | Owner title | Source page | Verified

The Email type column is simple: mark it personal (jane@) or role (info@, office@). You will want to treat those differently when you write.

The per-row routine

1. Click the Maps URL. Copy the phone number, website and address from the listing.
2. On the website, check the Contact page, the footer, the About or Team page, and any booking or privacy policy page. Emails often hide in the last two.
3. For the owner, look for an About page, a Meet the team section, a named founder in the copy, or owner-signed replies to reviews on the Maps listing.
4. Paste the page URL where you found each detail into Source page.
5. If the listing's website field points to a social profile instead of a real domain, note it and move on. There may be no email to find there.

For deeper tactics, see how to get emails from Google Maps businesses and how to find business owner names.

Time it before you commit

Run the routine on your first five rows with a timer. If each row takes about five minutes, a 40-business list costs you over three hours before you send a single email. That is fine for a high-value account list and painful for anything bigger.

Mistakes to avoid

• Guessing emails from a pattern (firstname@domain) and sending without checking. Guessed addresses bounce.
• Saving the same business twice across different lists. Dedupe on business name and address before you import.
• Losing chain context. For multi-location businesses, the website may be a head office page. Note which location you are targeting.
• Dropping your notes. Keep the Note column through every step; it is your personalization.

When to stop saving places by hand and run a search instead

Switch to a search once your criteria can be written as a category and an area, or once enrichment is eating more time than outreach. A search returns the same businesses with contact fields already attached.

	Hand-saved list + Takeout	Category and area search
Best list size	Roughly 10 to 50	Dozens to thousands
How businesses are chosen	Your judgment, one by one	Keyword and location
Fields in the export	Name, note, Maps link	Full listing data plus enrichment
Emails and owner names	Found by you, by hand	Found automatically where available
Repeating for a new city	Start from zero	Change the area and rerun
Cash cost	Free	Paid per lead

Signs it is time to switch:

• You need more than about 50 leads for one campaign.
• You are saving nearly every result for a category anyway.
• You want to run the same campaign in a second or third city.
• You spend more hours filling columns than writing and sending.

One caveat: a single search in Google Maps only shows a limited number of results per query, so large areas need to be broken up. This explains why a Google Maps search stops early and how to work around it.

Rebuilding the same list from a category and area search in Prospect Cheap

Run a search for your list's category in the same area, let the enrichment fill in contacts, then match the results against your saved list so your hand-picked businesses stay at the top.

Prospect Cheap collects live business leads from Google Maps for a keyword and area, then uses AI to read each lead's website for emails, the owner's name and title, phone numbers and social profiles. You pay one credit per lead found. You start with 150 free credits, and monthly plans begin at $29 (pricing).

Worked example: 30 saved dentists in North Austin

1. Pick the keyword from your list. Your saved places are mostly dentists, so search dentist.
2. Match the area. Use the same neighborhood or city you were browsing when you saved them.
3. Run the search. You get the dentists you saved plus the ones you skipped, each with listing data and any emails, owner names and socials the AI found on their sites.
4. Export to CSV and put your Takeout CSV on a second tab named Saved.
5. Flag your hand-picked rows. In a new column, use a formula like =IF(ISNUMBER(MATCH(A2,Saved!A:A,0)),"Hand-picked","") where column A is the business name.
6. Carry your notes across with XLOOKUP or VLOOKUP on the same name column.

Exact name matching can miss small differences, like a trailing LLC or a different ampersand. Normalize both columns first: lowercase, trim spaces, and strip suffixes.

The result is a tiered list. Hand-picked businesses with notes become Tier A, and the rest of the search becomes Tier B for a broader campaign, all with contact details already filled in.

Filtering, verifying and sending the finished list to your outreach tool

Cut the rows that cannot be contacted or do not fit, verify every email, then push the list to your sending tool. This applies whether you enriched by hand or ran a search.

Filter first

• Remove rows with no email if this is an email campaign. Keep them on a separate call list if they have a phone.
• Separate rows with an owner name from rows without one. They need different openers.
• Drop businesses outside your category or area that slipped in.
• Dedupe on business name plus address.

Verify before you send

Bounced emails hurt your sender reputation, and hand-found or pattern-guessed addresses are the most likely to bounce. On paid Prospect Cheap plans you can verify emails in one click; for a manual list, run it through a verifier before import. More on why in verifying emails before sending.

Send it

You can import the CSV into any outreach tool, or send leads directly from Prospect Cheap to GoHighLevel, Instantly, Smartlead or lemlist without a file in between.

Map your Note column to a custom field so it can drive the first line. A note that says no online booking turns into something like: I tried to book a cleaning on your site last night and could only find a phone number. That line only exists because you saved the place by hand and wrote down why.

Next steps

• Today: create one custom list for a single niche and area, save 20 businesses, and add a one-line note to each.
• This week: export it with Takeout, enrich five rows by hand, and time yourself.
• Then decide: if each row takes more than a few minutes or you need hundreds of leads, run a category-and-area search, match it against your saved list, and send your hand-picked Tier A first.