How to export Google My Business data

Use this guide to export data from Google Search & Maps for any Google Business Profile.

âš¡ Updated

The Phantom extension for Google Chrome makes it possible to quickly export data from Google My Business, which will automatically download as a CSV file.

Follow these steps to export Google My Business data:

  1. Choose a business profile in Google Search or Maps
  2. Click the export button
  3. Import the data to Google Sheets or Excel

Note: Phantom must be installed in order to access the export feature for Google My Business. You can install for free on the Chrome Webstore .

Once Phantom has been installed, it will be enabled by default for Google Chrome.

1. Choose a business profile in Google Search or Maps

To start exporting data, perform a local or branded search in Google Search or Maps.

An example of a localized Google search

Then scroll down to Google’s Local 3-Pack results…

2. Click the export button

You’ll have the option to export data directly from Google Search.

Example of how to export Google My Business data

Just click the Export button on the profile to start the CSV download.

3. Import the data to Google Sheets or Excel

Once you have the exported CSV file, you can import that data to Google Sheets (or Excel) for further analysis.

Importing Google Business Profile data to Google Sheets

Types of Google My Business data that can be exported

Export itemDescription
Business nameThe name that appears on the Google Business Profile
Primary categoryThe primary Google Business Profile category on the profile
Additional categoriesAll additional business categories associated with the profile
Website URLThe “website link” or local landing page linked from the profile
Maps URLThe Google Maps link to the profile
Place CIDThe Place CID link associated with the profile
Review countThe total number of Google reviews (at time of export)
Star ratingThe aggregate star rating of Google reviews (at time of export)
Recent review dateThe date of the most recent Google review on the profile
Photo uploadsThe total number of photos that have been uploaded
Address localityThe city contained in the business’s mailing address

Frequently asked questions

What other data can I export?

Currently, Phantom supports only the export items contained in the table above. To request additional items, please reach out and let us know what you would like to see (we’ll likely get it added ASAP!).

Can I download data from Google Maps?

Yes, Google Business profile data can be downloaded from Google Search and Google Maps using the Phantom – GMB Audit Toll extension for Google Chrome.

How do I download a CSV file?

By default, the Export button will download the data as a CSV file.

How should I analyze the exported data?

You can access the Google Business Profile optimization checklist & template to automate most of the analysis.

Install Phantom for Google Chrome

Audit any Google Business Profile & get better competitor insights.


Install for free on the Chrome Web Store