Download your businesses in bulk

You can download your profiles as a spreadsheet, update your data in a spreadsheet tool of your choice, then upload it to Business Profile when you’ve finished.

To download profiles to a spreadsheet:

  1. Sign in to Business Profile.
  2. Select the profile or profiles you’d like to download. Then, in the top right-hand corner, click Actions.
  3. In the 'Download' section, click Businesses.
  4. You’ll have the option to choose whether to include Google Update information and photos in your download.
    • To include Google updates, tick the box next to 'Include Google updates'.
      Note: Learn more about Google updates.
    • To include photos, tick the box next to 'Include photos'.
  5. Choose the type of file that you’d like to download.
  6. Click Download.

Spreadsheet values

When you download your spreadsheet, you’ll see data for all of your downloaded profiles as well as:

  • Errors: Shows fields that have incorrect, incomplete or inconsistent data. You’ll only see this column if at least one of your downloaded profiles has an error.  Learn how to fix errors.
  • Google updates: Shows the field groups that have Google updates, like 'Address' or 'Phone numbers'. You’ll only see this column if at least one of your downloaded locations has a Google update. Learn more about Google updates
  • [UPDATED]: Shows Google-updated info next to the info that you provided. For example, if you have Google updates to your Sunday working hours, then you’ll see a column labelled '[UPDATED] Sunday hours' containing the Google-updated hours next to a column labelled 'Sunday hours' containing the hours you provided. An empty cell means that there are no updates for the field. You’ll only see this column if you selected 'Include Google updates' when you downloaded your spreadsheet.
  • [BLANK]: Indicates that there was a Google update removing the info you provided. For example, if you entered that your business is open from 9:00 a.m. - 2:00 p.m. on Tuesdays and Google finds data that you’re closed on Tuesdays, you’ll see the value '[DELETED]' in a cell of the column labelled '[UPDATED] Tuesday hours'. You’ll only see this value if you selected 'Include Google updates' when you downloaded your spreadsheet.

Note: The download button may not work with some web browsers. Learn more about browser compatibility.

true
Shape the future of Google support

User research studies help us to improve our support services by allowing us to get feedback directly from users like you. Find out more, or sign up now for invitations to participate in future studies.

Search
Clear search
Close search
Google apps
Main menu
9485296519078222870
true
Search Help Centre
true
true
true
true
true
99729
false
false
false