Download your locations

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

To download locations to a spreadsheet:

  1. Sign in to Google My Business.
  2. Select the location or locations that you’d like to download. Then, in the top right-hand corner, click Actions.
  3. In the 'Download' section, click Locations.
  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 locations 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 locations has an error.  Learn how to fix errors.
  • Google updates: Shows the field groups that have Google updates, such as '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, then you’ll see the value “[BLANK]” 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.

Was this helpful?
How can we improve it?