Export Google Business Profile (Google My Business) to Excel (2026)

Which export you need

Google renamed Google My Business to Google Business Profile, and the dashboard most people remember is now called Business Profile Manager. The data splits four ways, and each part comes out of a different place:

The first three only work for profiles your Google account owns or manages. If the profile belongs to a client, ask to be added as a manager first. If it belongs to a competitor or a prospect, skip to the fourth.

Export your own profile details

This is the file to use for auditing addresses and hours across locations, handing a listing inventory to a new agency, or keeping a dated backup before a bulk edit.

What's in the file

The download uses the same layout as Google's bulk upload template, so the columns are the fields an owner can edit:

• Identity: Business code (the store code), business name, primary category and up to nine additional categories.
• Location: Address lines, locality, administrative area, postal code, and latitude and longitude.
• Contact: Primary phone, up to two additional phones, and the website URL.
• Hours: One column per day of the week, written as 09:00-17:00, with closed days blank or marked X.
• Description and dates: The From the business description (up to 750 characters) and the opening date.
• Housekeeping: Labels, the Google Ads phone number, photo URLs, and one column for each attribute that applies to your category.

Two things are missing that people expect to find. The template has no rating or review count column, because an owner can't edit those. And there are no performance numbers; those are a separate download.

The Google updates option

Google changes listings on its own, using user suggestions and other sources. With Include Google updates ticked, the file gains a Google updates column naming the field groups that were changed, plus an [UPDATED] column beside each of your originals showing Google's value. A cell marked [DELETED] means Google removed something you entered. An Errors column appears if any profile has incomplete or inconsistent data.

For a business with more than a handful of locations, this is the fastest way to find the branch whose hours or phone number were changed without anyone noticing: filter the Google updates column for non-blank cells.

Export your performance data

Performance is what the old dashboard called Insights: how many people found the profile and what they did next. It's a separate file from the profile details and comes out of the same menu.

The metrics Google reports are interactions, searches, views, directions, calls, website clicks, messages and bookings, plus products, menus and offers where the category has them. A metric that doesn't apply to your business is left out. The searches figure is refreshed at the start of each month and can take up to five days to appear, so a report pulled on the 2nd may show last month as empty.

Because the history is limited, the practical habit is a calendar reminder: download the report on the same day each month, keep every file, and stack them in one workbook. After a year you have a trend Google itself can no longer show you.

If the columns come back filled with ***, the profile isn't enabled for downloads. Google ties that to the profile's verification status, so check that first.

Reviews: no spreadsheet, but there is a file

Neither download includes review text. The route Google does provide is Google Takeout: deselect everything, select Google Business Profile, and create the export. It covers the profiles your account manages and arrives as a zip of JSON files, not a spreadsheet.

Excel can read JSON without any other tool. Go to Data > Get Data > From File > From JSON, pick the reviews file, and Power Query opens. Convert the list to a table, expand the record column, and load it. Each review becomes a row with the reviewer, the star rating, the date, the comment and your reply if you wrote one. Nested fields need a second expand, which is the one step that trips people up.

Takeout runs on request, so this is a snapshot. Run it again when you want newer reviews.

Export other businesses' profiles

Everything above stops at profiles you manage. For a list of every dentist in Leeds or every HVAC company in Phoenix, there is no Google download. The public listing on Google Maps is the only source, and collecting it row by row is what a Google Maps scraper does.

In Maps Harvest that means picking a category and a city, optionally setting filters (minimum rating, review count, has a website, has a phone number), and exporting the result. The filters run during the scrape, so rows that fail them never reach the file. Each row can carry up to 18 fields: business name, category, phone number, website URL and domain, address, rating, review count, Google Maps URL, plus code, hours, price level, temporarily closed status and description, along with the query, city, state and scrape time.

The file format depends on the plan:

• Free (50 credits): 9 core fields as CSV. Excel opens CSV, so this is enough to see what the data looks like for your category.
• Starter ($19/mo, 1,000 credits): 13 fields, and a native XLSX download alongside CSV.
• Growth ($49/mo, 5,000 credits): All 18 fields, with JSON and API access added.

What a scrape can't give you is anything private to the owner: store codes, labels, performance numbers or the Google updates history. It also returns the rating and review count, not the text of the reviews.

The two kinds of file are more useful together than apart. Your own export has no rating column; a scrape of your category in your city does, for you and for everyone ranking beside you. Put your locations and the scraped rows in one workbook and you can see, branch by branch, how your rating and review count compare with the businesses a customer sees in the same search. The guide to Google Maps competitor analysis goes through that comparison, and the step-by-step for the scrape itself is in exporting Google Maps to Excel.

Open the file in Excel without breaking it

Business listing data is mostly identifiers that look like numbers, and Excel converts anything that looks like a number. These five habits apply to Google's downloads and to scraped files alike:

If the destination is a lead list, the next steps (duplicates, chains, dead numbers) are in the guide to cleaning a Google Maps lead list. If you'd rather work in a browser, Google Maps to Google Sheets covers the same export without Excel.

FAQ