Import your bulk upload spreadsheet

Importing a spreadsheet file is an easy way to update and create multiple locations. To import your spreadsheet:
  1. Add location information to your bulk upload spreadsheet.
    • If you're importing for the first time, download the spreadsheet in Google My Business by clicking the Download the template link on the "Import locations from a file" screen.
    • Add all locations that you manage before uploading your spreadsheet.
    • If you’re making changes to existing location information, download the latest location information from your account and make any changes directly to the spreadsheet. Use the same store codes and location information as you have in the past so that we don't create duplicate locations.
    • If you’re only updating particular fields for existing locations, you may include only the columns for store code and the fields you want to change, and not include other columns. If you accidentally add a new location as well, you’ll be alerted that you’re missing required column headings.
    • It's not possible to update your store code via spreadsheet.
  2. Fix duplicate or missing store codes before you upload a spreadsheet. These unique values help to ensure that every change in your file is accurately applied to the locations in your account. Learn more about store codes.
  3. Sign in to Google My Business.
  4. In the top right corner, click Add location.
  5. In the dropdown menu that appears, click Import locations. To import a spreadsheet, click Select file.
    • Accepted formats: .xls, .xlsx, .ods, or .csv.
  6. Fix column headers, if needed. You’ll see a warning if the headers are duplicated in your spreadsheet, don’t match any header that Google recognizes, or will be ignored when you upload your spreadsheet.
    • Your file may include column headers that aren’t recognized. For a full list of errors that you may see and what you can do to fix them, please refer to this chart.
  7. To see proposed changes, click Preview changes. You can view the updates to your locations. 
    • ​​To accept the updates, click Apply. Then, click Review changes to see all changes made.
    • To reject the updates, click Cancel.
      Note: If there are more new locations than you expected, make sure that the correct store codes are included for each location in the spreadsheet.

Import summary

When you import a file, you'll see a preview of the changes that will be made to your account when the import is completed.

The import preview contains the following information:

  • Warnings for possible mistakes in the uploaded spreadsheet (you may not see any warnings).
  • A summary of how many locations will be affected by your upload.
  • A Download details button, which you can use to download a spreadsheet containing details of the changes.

Once you have reviewed and confirmed changes in the preview, you can either Submit the changes or click Cancel to double-check your file if the import preview wasn't what you expected to see.

Download change details

When you choose to Download details, you'll receive a spreadsheet that contains details of all the changes your spreadsheet upload will make to your account. On the change details spreadsheet, you might see the following terms:

  • Import status: Shows the type of change to the location
  • Updated fields: Shows the names of the fields that will be changed by the uploaded spreadsheet if the location's status is "Updates"
  • Errors: If the import status is “Errors”, this column contains an error message

Types of changes to your locations

Change type What it means
New These are new locations that weren't found in previous uploads and will be added to your account.

If these locations aren't actually new, there may be a problem with your store codes. For instance, your spreadsheet software may have to cut off zeros from your store codes (e.g. "4" instead of "0004"). This can result in unintentionally creating "new" locations, so please double check your store codes to ensure that they're accurate.
Updates These locations will be updated with the values provided in the spreadsheet if changes are applied. If it’s been a while since your last upload, you may notice that many changes appear in this section. You may see large numbers of unintended changes to locations if:
  • The information in your account was formatted to comply to standard Maps formatting guidelines.
  • An improperly deleted cell has shifted the values in your spreadsheet, causing unintended changes to many locations. Please double check that all values in a row correspond to the same location and store code. We recommend that you first download the location information from your account, then make changes and import the modified file.
No updates These locations appear exactly the same in both your account and your data file. No changes are needed.
Errors There was an error processing the location and more info is available in this column. 
Was this article helpful?
How can we improve it?