How to export Google Maps results to Excel or Google Sheets
Use a Google Maps export tool that produces a CSV, then import that file into Excel or Google Sheets. Check the exported records against the listings before using the spreadsheet.
The numbers
| Official limit | Places API Text Search returns up to 60 results per query |
|---|---|
| Export formats | CSV, XLSX, JSON or Google Sheets |
| Key fields | Name, address, phone, website, rating, review count, coordinates |
Step by step in Google Maps Business Lead & Email Finder
- Open Google Maps Business Lead & Email Finder on the Apify Store and sign in or create a free account (the Free plan includes $5 a month to spend).
-
Fill in the form:
Field Set it to What do you want to do? Search Google Maps for businesses Search phrases dentists in Leeds, United Kingdom, one search per line; add a line per neighbourhood or postcode for a big city (one Google Maps search shows about 120 places) Country United Kingdom US state All (nationwide) Maximum leads 1,000, the rows you want in all - Click Start. For 1,000 rows the run costs about $1.39 (results and start fee), plus platform usage at $0.80 per hour of run time.
- When the run finishes, open its Output tab and use Export to download CSV or Excel.
- In Excel, open the .xlsx file directly; for the CSV use Data > From Text/CSV and pick UTF-8 so accents stay intact. In Google Sheets use File > Import > Upload and choose "Replace spreadsheet".
Define the business category and location before exporting. Copying the visible browser results can lose fields, so use a structured export and check that the spreadsheet preserves the details you need.
- Search Google Maps for the business category and location you need.
- Choose an export tool that supports your search and provides CSV output.
- Export the matching business listings to CSV.
- Import the CSV into Excel or Google Sheets, treating phone as text.
- Compare a sample of spreadsheet records with the corresponding Google Maps listings.
- Remove duplicate records after checking whether they represent separate business locations.
Where this usually breaks
Browser copy-paste can leave details missing or place them in inconsistent columns. Use a structured export when you need a reusable spreadsheet.
A business can appear in overlapping searches. Check the address before removing repeated names, since separate branches may share a name.
Spreadsheet imports can change phone formatting. Treat phone as text and inspect the imported values.
A completed export does not establish that every relevant business was found. Keep the search location and category in mind when assessing coverage.
What to check before you use the list
Confirm that the records match the business category and area you intended to collect.
Check that the details needed for your task are present; a blank value should remain blank unless you verify a replacement.
Review duplicate records and separate business locations.
Check the source and export service terms for your intended use, including storage and sharing.
Questions
Can I paste Google Maps results straight into Excel?
You can copy visible text, but the result can lose fields and need manual cleanup. A structured CSV export gives you a clearer starting point for a spreadsheet.
Can I use the same CSV in Google Sheets?
Import the CSV into Google Sheets. Check the column alignment and phone formatting after import.
Why are some details missing from the export?
The listing may lack the detail, or the export may not include it. Compare the record with the listing before treating a blank as evidence that the detail does not exist.
Does an export include every business in an area?
Do not assume that an exported search is a complete directory. Review the search category, location and coverage before drawing conclusions from the list.