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’re done.

To download locations to a spreadsheet:

  1. Sign in to Google My Business.
  2. Select the location or locations you’d like to download. Then, in the top right corner, click Actions.
  3. In the “Download” section, click Locations.
  4. You’ll have the option to choose whether or not to include Google Update information and photos in your download.
    • To include Google updates, check the box next to “Include Google updates.”
      Note: Learn more about Google updates.
    • To include photos, check the box next to “Include photos.”
  5. Choose the type of file 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, 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 you provided. For example, if you have Google updates to your Sunday business hours, you’ll see a column labeled “[UPDATED] Sunday hours” containing the Google-updated hours next to a column labeled “Sunday hours” containing the hours you provided. An empty cell means there are no updates for the field. You’ll only see this column if you selected “Include Google updates” when you downloaded your spreadsheet.
  • [DELETED]: Indicates that there was a Google update removing the info you provided. For example, if you entered that your business is open from 9:00AM - 2:00PM on Tuesdays and Google finds data that you’re closed on Tuesdays, you’ll see the value “[DELETED]” in a cell of the column labeled “[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 article helpful?
How can we improve it?