Your saved list appears to contain more businesses than the spreadsheet you downloaded. The quickest way to investigate is to trace one missing place through the process rather than immediately importing the whole list again.
Trace a missing place from the Maps list to the imported records and then the workbook. Check loading, account, source file, filters, and export selection at the stage where it disappears.
Choose one recognizable missing business and find the last stage at which its record is present.
Separate the source list from the export
Write down three counts: places in the intended source list, records visible after import, and rows in the exported workbook. Exclude the header row from the workbook count.
Those numbers answer different questions. If the organizer contains the expected records but the workbook does not, investigate export scope. If the organizer itself is short, investigate capture or source coverage. If the downloaded source file lacks the place, the issue precedes the extension.
Use several recognizable places to check the counts. A total can hide a missing record and an unwanted duplicate that cancel each other out.
Check whether the full list was loaded
A live Google Maps tab and an account export are different inputs. Prospect's listing says Maps tab imports read currently loaded places and advises keeping Maps open while importing saved-list cards.
Open the intended list, inspect how far its cards have loaded, and keep the tab available while processing it. If your purpose is to cover a large owned list, compare against a Takeout export rather than assuming a single tab import includes everything in your account.
Do not interpret a loaded-list limitation as evidence that the businesses were deleted from Google Maps. Confirm the actual saved list before changing anything.
Verify the Google account and export category
For saved lists, Google's export instructions specify the Saved category in Takeout. A different account or a differently scoped Maps download may not contain the list you expected.
Open the extracted files and search for a missing business name or place link. Check the file's list identity and the export's age. A business added after the export was requested may require a newer archive; Google notes that changes during the archive process may not be included.
A list shared by someone else also deserves a scope check. Being able to view a list does not by itself establish that your account export contains the same records.
Check filters and selection before reimporting
If the organizer shows the missing place when searched by name, the import may already have worked. Clear the search box, choose All prospects and Any time, and inspect the export scope. Export Excel exports the entire collection; Export filtered exports the current filtered view; Export selected exports checked rows. For a Maps import preview, also check the selected and imported counts and use Select next 100 to continue after a completed batch.
| Symptom | First place to check |
|---|---|
| Place is in organizer but absent from Excel | Filter or export selection |
| Place is in Maps but absent from imported records | Loaded-list coverage and import review |
| Place is absent from the downloaded source | Account, category, list scope, and archive date |
| Company appears once but has several branches | Company-versus-location handling |
Review branches separately. A company name search may find the parent business without proving that the specific branch was preserved.
Resolve one missing place before repeating the import
Choose a missing business whose source link you can identify. Work through this sequence:
- Confirm that the place is still in the intended Maps list.
- If using Takeout, look for its name or link in the extracted source file.
- Search for the business and branch in the organizer, with filters cleared.
- If it is present, check the selection used for the workbook export.
- If it is absent, retry that place through the appropriate individual workflow and record the outcome.
Maintain an exception table with Place, Source link, Last stage found, Action, and Result. This separates missing source data from an import problem or export-selection mistake.
In an illustrative 50-place list, three entries might not reach the first reviewed collection. If two are intentionally excluded and the third is recovered, the accepted list contains 48. Record both exclusions; do not force the workbook back to 50 by adding businesses that do not belong.
Keep a simple batch record
Save the source list name, export date, imported count, accepted count, and unresolved exceptions. This takes less effort than rediscovering the same issue next month.
The useful success measure is a reconciled list of intended businesses. A spreadsheet with the expected number of rows can still contain the wrong places, so finish by checking identity and location as well as totals.
Related Questions
Does an empty email field mean a place was not imported?
No. The place may have imported correctly while its email remains unavailable. Check the company, source link, and location first, then treat missing contact fields as separate research questions.
Should I keep retrying the whole list?
Diagnose one or two missing records first. If the problem is a filter, selection, or partial loading, a repeated full import may add work without fixing the cause. Keep an exception list and resolve its entries deliberately.
Return to exporting saved places to Excel for the main workflow, or use the Takeout import guide for a downloaded list.
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.