Known issue: You can't update hotel attributes through the spreadsheet upload. To update hotel attributes, use the API and dashboard. Learn more about My Business Lodging API.
Importing a spreadsheet file is an easy way to update and create multiple locations. To import your spreadsheet:
- 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.
- 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.
- Sign in to Google My Business.
- In the top right corner, click Add location.
- In the dropdown menu that appears, click Import locations. To import a spreadsheet, click Select file.
- Accepted formats: .xls, .xlsx, .ods, or .csv.
- 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.
- 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
