You can manage an individual profile directly on Search and Maps. To manage multiple profiles in bulk, you can use Business Profile Manager.
- Add business information to your bulk upload spreadsheet.
- If you're importing for the first time, download the spreadsheet in your Business Profile 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 businesses.
- If you’re only updating particular fields for existing businesses, 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 business 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 businesses in your account. Learn more about store codes.
- Sign in to Business Profile Manager.
- In the top right corner, click Add business.
- In the dropdown menu that appears, click Import businesses. 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 businesses.
- To accept the updates, click Apply. Then, click Review changes to see all changes made.
- To reject the updates, click Cancel.
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.
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