Skip to content
Plans from $19/month

How to Export Google My Business Listings to Excel (Free 2026 Guide)

GuideBy LeadOutreach Editorial Team· 7 min read· Updated
How to Export Google My Business Listings to Excel (Free 2026 Guide)

Key takeaways

  • 'Export Google My Business listings to Excel' means two different things: your own locations, or other businesses on the map
  • Google Business Profile (formerly Google My Business) can download the locations you manage as a spreadsheet via Actions > Download > Businesses, but only those
  • For other businesses you need to collect the public Google Maps listings with a lead tool, then export the CSV and open it in Excel
  • Open the CSV through Excel's text import so phone numbers, leading zeros and accented names survive
  • Google Sheets takes the same file via File > Import > Upload, as long as you set 'Convert text to numbers, dates and formulas' to No
  • A prospect export is only useful if the emails are verified: unchecked addresses copied from websites bounce
Prospect Export
Need other businesses in Excel, not just your own listings?
Start the 7-day trial

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

Short answer:if the listings are yours, sign in to Google Business Profile, select the locations, open the Actions menu and download Businesses as a spreadsheet, then import that file into Excel. If you want other businesses' Google Maps listings, there is no export in Google's tools; you collect the public listings with a lead tool such as LeadOutreach and export them as a CSV that opens in Excel. Both routes are covered step by step below.

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.

Why does "export Google my business listings to excel" have two answers?

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 in a separate dashboard. The management view for accounts with several locations still exists, and that is where the spreadsheet download lives. It only ever contains locations your account manages. Everyone else on the map is public listing data, which Google displays but does not let you download, so that side of the job needs a different route.

How do I export my own Google Business Profile locations to Excel?

This is the official route and it works only for locations your Google account owns or has been granted access to. The menu labels below match Google's help article at the time of writing; if they change, look for a download or spreadsheet option in the same place.

  1. Sign in to Google Business Profile: Use the Google account that owns or manages the locations. Accounts with several locations open on a list of businesses; single-location owners are usually taken straight into Google Search or Maps, so look for the link that shows all of your businesses as a list.
  2. Select the profiles you want to download: Tick the locations you want in the file, or select all of them. If your locations are organised into business groups, pick the group first. Filters for city, category and verification status help when you only want a subset.
  3. Open the Actions menu and choose Businesses under Download: At the time of writing, Google's own instructions say to click Actions in the top right, then click Businesses in the Download section. If the label has changed, look for a menu item that mentions download or spreadsheet. You can also tick boxes to include Google updates and photos.
  4. Choose the file type and click Download: Pick the spreadsheet format you want, then download. Google notes that the download button does not work in every browser, so try Chrome if nothing happens.
  5. Open the file safely in Excel: Do not double-click a CSV. Open Excel first, use the import-from-text option, and set every phone and postcode column to Text before finishing. This stops Excel from turning long numbers into scientific notation and stripping leading zeros.
  6. 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 download is built to be edited and uploaded again, so it follows the same layout as Google's bulk upload spreadsheet: one row per location with the store code, name, address, phone, website, category and opening hours. It does not include reviews in a usable form and it never includes an email address, because Business Profile does not publish one.

How do I export other businesses' Google Maps listings to Excel or CSV?

Business Profile has no concept of exporting a business you do not own. Google Maps itself has no export button either, and a single Maps search only shows a limited number of results, which the Google Maps search results limit guide explains in detail. To get a list of, say, every physiotherapist in Manchester into Excel, you need to collect the public listings with a lead tool such as the Google Maps email extractor and export from there.

  1. Decide the category and area: Business Profile cannot export businesses you do not own, and Google Maps has no export button, so this route reads the public map listings. 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 checks the syntax, filters out placeholder and disposable addresses, and confirms the domain has a live MX record before the email reaches your export.
  4. Export the list and open it in Excel: Export the results as a CSV. The file opens in Excel or Google Sheets and includes phone numbers stored as text, split address fields, the email column and the review data for every row. On plans with AI scoring, the lead score is included too.

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. Email addresses copied from websites without any check include dead and placeholder mailboxes, and enough bounces will get a sending domain throttled. The guide on finding business email addresses from Google Maps explains where the emails come from, and the features overview shows how verification and lead scoring are applied before the file is built. If you are weighing a tool against building your own script, the comparison of the Google Places API and a Google Maps scraper covers the trade-offs, and the guide to whether Google Maps scraping is legal covers the rules before you start.

Why does Excel break the exported file, and how do I fix it?

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.

SymptomCauseFix
Phone numbers show as 1.55E+10Excel treats a long digit string as a number and switches to scientific notation.Import the CSV through the text import wizard and set the phone column to Text, or prefix numbers with an apostrophe.
Leading zeros disappearPostcodes and UK phone numbers such as 0161 lose their first digit because Excel drops leading zeros from numeric cells.Format the column as Text before pasting or importing. Formatting afterwards does not bring the zero back.
Accented names turn into strange charactersThe CSV is UTF-8 but Excel opened it with a legacy Windows code page.Use the import option and choose UTF-8 (65001) as the file origin, or open the CSV in Google Sheets and download as .xlsx.
Addresses land in one columnCommas inside the address were treated as separators, or the source put the whole address in one field.Use a tool that exports street, city, state and postcode as separate columns. LeadOutreach does this by default.
Duplicate rowsThe same business appears under two categories or two service areas.Remove duplicates on the phone or website column, not the name, since the same name can belong to unrelated businesses.

How do I export Google my business data to Google Sheets?

Neither route has a "send to Google Sheets" button, and Business Profile does not publish one. Both routes hand you a file first: Business Profile downloads a spreadsheet of the locations you manage, and a lead tool exports a CSV of the listings you collected. From there the import is the same three steps.

  1. Open a blank Google Sheet and choose File, then Import, then Upload, and select the file you downloaded.
  2. Pick how it lands:"Replace spreadsheet" for a fresh file, or "Insert new sheet" to keep it alongside a tab you already have.
  3. Set "Convert text to numbers, dates and formulas" to No. This is the setting that matters. Left on, Sheets does the same damage Excel does: long phone numbers collapse into scientific notation and postcodes lose their leading zeros.

Sheets is also the quickest repair when Excel has already mangled a file. Import the original CSV with the convert option off, check that the phone and postcode columns look right, then use File, Download, Microsoft Excel (.xlsx) to get a clean workbook back. The export itself is identical either way, so the choice is only about which spreadsheet you prefer to work in.

What should a Google Maps listings export contain?

  • 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. If that means cold email, check the copy in the spam words checker before the first send. Plans and monthly limits are on the pricing page.

Start finding verified leads today

Search Google Maps by niche and city and export verified emails, phone numbers, and marketing gap audit signals to CSV or your CRM. 7-day Starter trial, then plans from $19/month.

No credit card required. Free plan of 100 leads a month stays available.

Related articles

FAQ

Frequently asked questions

Yes, if you manage them. Google My Business is now Google Business Profile, and its own help article explains the download: sign in, select the profiles you want, click Actions in the top right, click Businesses in the Download section, choose a file type and click Download. The file covers only the locations your account owns or manages. Single-location profiles are usually managed inside Google Search and may not show the list view where this menu lives.

Not from Google's tools. Google Business Profile only exports the listings you own or manage, and Google Maps has no export button. To get competitors or prospects into Excel you need to collect the public map listings with a tool such as LeadOutreach, which also finds and verifies each business email before you export the CSV.

The download sits in the Actions menu of the business list view, which you see when your account manages several locations. Accounts with a single verified location are typically managed through the Google Search interface, which does not show that list or its Actions menu. If you cannot find it, check whether your account has a list-of-businesses view at all.

Open Excel first, use the text import option rather than double-clicking the CSV, and set the phone column type to Text during import. Alternatively, open the CSV in Google Sheets, which preserves phone strings, and then download it as an Excel file.

The same way you get them into Excel, because both routes produce a file rather than a live connection. Download the spreadsheet from Google Business Profile for the locations you manage, or export a CSV from a lead tool for other businesses on the map. Then open a blank Google Sheet and choose File, Import, Upload. Set 'Convert text to numbers, dates and formulas' to No during the import, or Sheets will strip leading zeros from postcodes and turn long phone numbers into scientific notation.

Collecting publicly displayed business information such as a name, address, phone number and website is generally treated differently from collecting personal data, but the rules depend on where you are and how you use the list. Google's terms also restrict automated access to its services. Read the guide on whether Google Maps scraping is legal before building a list, and follow local email and privacy law when you contact anyone on it.