prospectA saved Maps list may contain businesses gathered over months of research. Google Takeout can help retrieve that collection, but the downloaded records still need a clear scope and a review process.
Choose the relevant Takeout file, preserve the original, and import supported records into Prospect. Reconcile the businesses, qualify them against your target, then export a working list with sources and next actions.
Inspect the extracted file first, then keep a batch record that explains every exclusion and unresolved place.
Export the right collection
Sign in to the Google account that contains the intended list. Google's saved-list export guidance points to the Saved category in Takeout. Choose the delivery and archive options and request the download.
When the archive is available, save and extract it. Keep an unchanged copy of the original. Do not upload unrelated account data into a prospecting workflow simply because it arrived in the same archive.
Identify the file that contains the list you mean to use. Inspect a few recognizable names and links rather than trusting a filename alone. Google's download guidance also notes that changes made during the export process may not appear in the archive.
Understand the file before importing it
A CSV contains tabular text. GeoJSON stores geographic records in a structured format. These formats are not interchangeable, and renaming an extension does not convert the content.
Look at the fields actually present. You may have names and source links without every address or contact detail you want. Treat missing fields as a reason to plan additional research, not as permission to fill them from assumptions.
If the source list contains restaurants, personal destinations, and business targets together, separate the relevant records before turning them into a sales queue. The fact that a place was saved does not explain why it belongs in today's campaign.
Import a small recognized batch
Prospect's listing describes importing Saved CSV and Maps GeoJSON exports from Google Takeout in batches of up to 100. Begin with a small recognizable set so you can compare the result against the source.
In version 1.3.0, open Saved prospects, click Import Google Maps, and use Or choose a Google Takeout file to select the extracted CSV or GeoJSON. Choose the list file, not the ZIP archive. The file input rejects files larger than 10 MB.
The preview initially selects up to 100 places. Review the selection, uncheck unwanted entries, and click Import selected places. Preserve the source list name and capture date in your batch notes. For a larger file, continue with the built-in batching control described below.
Do not assume that importing a file establishes the completeness of every business field. Review company identity, website, and location before relying on contact details.
Handle a larger file without damaging its structure
Keep the original list intact and record a batch label for each processed group. After each group, note the source entries considered, records accepted, and exceptions still unresolved.
Do not split a CSV by copying arbitrary text lines: quoted fields can contain commas or line breaks. Use a CSV-aware spreadsheet workflow if you must prepare smaller files, preserving headers, encoding, and source links. GeoJSON likewise needs a format-aware method; a cut-and-paste fragment may no longer be valid.
Use Select next 100 after each completed import. It selects up to 100 entries not already marked imported in the current preview. Completed entries are disabled; unsuccessful entries can remain eligible for review or retry. For example, 205 valid places can be processed in groups of 100, 100, and 5. Keep the same preview open: choosing a file again resets the preview’s imported markers. Reconcile the saved records rather than assuming every selected place succeeded.
Reconcile source places with imported businesses
Track four quantities: source records considered, imported records, accepted prospects, and unresolved exceptions. They may differ for good reasons, but you should be able to explain those reasons.
For example, a fictional 80-place source might contain six personal destinations and four businesses outside the target area. Excluding them produces a smaller accepted list without indicating an import failure.
Use source links to trace ambiguous entries. When a company has multiple locations, compare each branch before treating a repeated domain as a duplicate. A parent-company list and a territory list may require different treatment.
Add a qualification pass
Review each imported business against your target rules. Record a fit reason supported by a company page or another relevant source. If the business looks suitable but a critical detail is missing, assign a bounded research action.
A practical working layout includes:
| Field | Reason it belongs |
|---|---|
| Source list and source URL | Trace the record back to the collection |
| Record ID and parent ID | Keep identity stable through edits |
| Fit reason | Explain why it is a candidate |
| Checked date | Distinguish reviewed details from imported details |
| Status and next action | Convert the record into usable work |
These fields describe your working process. They are not all implied by the Takeout archive or automatically supplied by an import.
Export a reviewed working list
Once the relevant records are checked, export the selection to Excel. Inspect the workbook and preserve the original source separately from the file you use for ownership and follow-up.
If a later Takeout export includes the same places, compare it against the working list instead of replacing the entire table. New source data should not erase qualification, activity history, or contact restrictions.
A useful final review asks whether another person can identify the business, understand its fit, return to the source, and complete the next task. If those answers are clear, the archive has become a prospecting resource rather than just another downloaded file.
Related Questions
Will Takeout give me every contact field I need?
Inspect the actual file rather than assuming a fixed set of business fields. Saved-place records and company contact research serve different purposes. Use the company website to review details missing from the export.
Why keep the original archive after import?
The original preserves the source record and helps explain later discrepancies. Keep it separate from the working spreadsheet so cleanup, qualification, and follow-up changes do not remove your ability to trace the imported data.
For missing records, use the export troubleshooting checklist. For the wider strategy, read Google Maps prospecting for local B2B sales.
Published by Stephen Modliszewski, publisher of Prospect — Sales Bookmarks. ProspectClip is the extension’s website. Fictional examples and illustrative calculations are teaching aids, not customer results.