Import your bulk upload spreadsheet

Known issue: You can't update hotel attributes through the spreadsheet upload. To update hotel attributes, use the API and dashboard. Learn more about Business Profile API.

You can manage an individual profile on Search and Maps. To manage multiple profiles in bulk at once, you can use Business Profile Manager. If you want to add another profile, on Google Search, select the three-dot menu and then Add a new Business Profile

Importing a spreadsheet file is an easy way to update and create multiple locations. To import your spreadsheet:
  1. 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 only want to update particular fields for current businesses, include only the columns for store code and the fields you want to change. If you accidentally add a new business as well, you’ll be alerted that required column headers are absent.
    • 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 businesses in your account. Learn more about store codes.
  3. Sign in to Business Profile Manager.
  4. In the top right corner, click Add business.
  5. In the dropdown menu that appears, click Import businesses. To import a spreadsheet, click Select file.
    • Accepted formats: .xls, .xlsx, .ods, or .csv.
  6. Fix column headers if needed. You’ll get a warning if the headers are duplicated or don’t match any header that Google recognizes. Those headers are ignored when you upload your spreadsheet.
    • Your file may include column headers that aren’t recognized. For a full list of errors and what to do, refer to this chart.
  7. 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.
Tip: If there are more new businesses than expected, make sure that the correct store codes are included.

Import summary

When you import a file, you'll find a preview of the changes.

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.

After you review the changes, you can submit them or click Cancel to double-check your file.

Download change details

When you choose to download details, you'll get a spreadsheet that shows the changes that’ll be made 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 businesses that weren't found in previous uploads and will be added to your account.

If these businesses 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" businesses, so please double check your store codes to ensure that they're accurate.
Updates These businesses 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 businesses 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 businesses. Please double check that all values in a row correspond to the same business and store code. We recommend that you first download the business information from your account, then make changes and import the modified file.
No updates These businesses appear exactly the same in both your account and your data file. No changes are needed.
Errors There was an error processing the business and more info is available in this column. 

Related resources

true
Get help from Small Business Advisors

Want to receive one-on-one guidance and tailored recommendations on how to make the most out of your Business Profile? Try booking an appointment with Small Business Advisors.


Important: This service cannot troubleshoot issues, including Business Profile verification or suspension, or Google Ads billing.

Search
Clear search
Close search
Google apps
Main menu
3740665358516271840
true
Search Help Center
true
true
true
true
true
99729
false
false
false