How to Export Google My Business Listings to Excel (Your Own & Others, 2026)

"Export Google My Business to Excel" is a search with two very different intentions behind it. Some people manage dozens of locations and want a spreadsheet of their own listings for an audit or a migration. Others want a spreadsheet of other people'sbusinesses, usually to build a prospect list. Google's tools only handle the first case, and most guides quietly ignore the second.

This guide covers both routes. If you only want a prospect list, the Google Maps leads to CSV tutorial goes deeper on that workflow. Here the focus is on what Business Profile can and cannot export, and on getting either file into Excel without corrupting it.

Google My Business is now Google Business Profile

Google renamed Google My Business to Google Business Profile in 2021, and most single-location owners now manage their listing directly inside Google Search and Maps rather than a separate dashboard. The multi-location management surface, Business Profile Manager, still exists and is where the bulk download lives. If you cannot find an export option, you are almost certainly looking at the single-location interface.

Route A: export the listings you manage

This is the official route and it works only for locations your Google account owns or has been granted access to. The menu labels have changed several times, so the steps below describe what to look for rather than exact button text.

1. Open Google Business Profile Manager: Sign in with the Google account that owns or manages the locations. If you manage more than one location, you land on the business list view rather than a single profile. Single-location owners are usually dropped straight into Google Search or Maps, so look for the link that takes you to the full list of businesses.
2. Select the business group or locations you want: Multi-location accounts are organised into business groups. Pick the group, then tick the locations you want in the export, or select all. Filters for verification status, city, and category help when you only want a subset.
3. Find the download or export option: The list view has a download control (its label has changed several times, so look for an icon or menu item that mentions download, export, or spreadsheet). Choose the spreadsheet format. Google typically offers a CSV or Excel-compatible file.
4. Open the file safely in Excel: Do not double-click the CSV. Instead, open Excel, use the import-from-text option, and set every phone and postcode column to Text before finishing. This stops Excel from turning +1 numbers into scientific notation and stripping leading zeros.
5. Clean and save as .xlsx: Remove any location rows that are closed or duplicated, then save as an Excel workbook so the column formatting is preserved next time you open it.

The resulting file contains the store code, name, address, phone, website, category and hours for each location. It does not include reviews in a usable form and it never includes an email address, because Business Profile does not store one publicly.

Route B: export other businesses as a prospect list

Business Profile Manager has no concept of exporting a business you do not own. Google Maps itself has no export button either. To get a list of, say, every physiotherapist in Manchester into Excel, you need to collect the public listings with a lead tool and export from there.

1. Decide the category and area: Business Profile Manager cannot export businesses you do not own, so this route uses the public map. Start with a specific pairing such as 'accountants in Leeds' or 'dentists in Phoenix'. Narrow searches produce lists you can actually work.
2. Run the search in a lead tool: Enter the same search in LeadOutreach. It collects the public listing data (name, address, phone, website, category, rating and review count) for every matching business in the cloud, so nothing runs on your computer.
3. Let the tool add what the listing does not show: Google Maps listings almost never display an email. LeadOutreach visits each linked website to find a contact address, then verifies it with syntax, MX record and blocklist checks before it reaches your export.
4. Export to Excel: Click Export Excel or Export CSV. The download includes clean phone strings, split address fields, verified emails, review data and an AI lead score for every row.

The difference between the two routes is not just who owns the data. A prospect export is only worth having if the contact details work. Raw email addresses copied from websites bounce 20 to 30 percent of the time, which is enough to get a sending domain throttled. See the features overview for how verification and lead scoring are applied before the file is built.

Excel gotchas that break both exports

Whichever route you take, the file is a CSV and Excel will try to be helpful with it. These are the five problems that come up most, with the fix for each.

What a good prospect export looks like

• One business per row, deduplicated on phone or website rather than name.
• Phone numbers stored as text in a consistent international format.
• Street, city, region and postcode in separate columns so you can filter by area.
• A verified email column, with role-based addresses such as info@ flagged so you can decide whether to use them.
• Review count and rating, which are the fastest qualification signals for local businesses.
• A lead score or priority column, so the list can be sorted before anyone starts calling.

If you are building the list for outreach rather than an audit, the step-by-step guide to finding local business leads covers what to do with the spreadsheet once you have it. Plans and monthly limits are on the pricing page.