Google Maps to Excel.
Export your Google Maps businesses and open them in Microsoft Excel, with every name and accent intact.
Google Maps rows are businesses, so there is no person name. Company emails found on their websites are free.
Google Maps to Excel in four steps.
Type your searches in plain English, one per line, such as “find 100 dentists in Denver”, and start the background run.
Collect
Collect businesses on the Google Maps page of your dashboard.
Filter and select
Filter and select the rows you want, then choose Menus → Export CSV.
Export the CSV
Double-click the downloaded file to open it in Excel.
Use it
To keep formatting, choose File → Save As and pick Excel Workbook (.xlsx).
What's in the file.
Google Maps rows are businesses, so there is no person name. Company emails found on their websites are free.
| Column | What it holds |
|---|---|
| Business | The business name |
| The best email found on the business website | |
| All emails | Every email found for that business |
| Phone | The business phone number |
| Address | The street address |
| Category | The Google Maps category, such as Dentist |
| Rating | The Google rating |
| Website | The business website |
| Place URL | The Google Maps link |
Get a clean import.
No garbled characters
The file includes a UTF-8 byte order mark, which tells Excel to read accents and symbols correctly.
Turn it into a table
Select the data and press Ctrl+T (Cmd+T on Mac) to sort and filter every column.
Same file for Numbers
Apple Numbers and LibreOffice open the same CSV.
Extraction and every company email are free. Nothing in this guide costs a credit. See pricing.
Export your first Google Maps list today.
Extraction and every company email are free. Nothing in this guide costs a credit.