Who Google Business Profile bulk upload is for

Google Business Profile bulk upload is for businesses with 10 or more locations. Google says such businesses can add, verify and manage locations in bulk, and that locations must meet its quality guidelines to appear on Maps and Search.

Google's process

  1. Use a business-domain email if possible; Google says non-domain emails take longer to verify.
  2. Create a business group for your locations.
  3. Create a spreadsheet of all locations.
  4. Upload it.
  5. Review the locations in the dashboard and fix errors.
  6. Request bulk verification through Google's form.
  7. Add, remove or edit later in the dashboard or by uploading a revised spreadsheet.

Getting the template

In Business Profile Manager, select Add profile, then Import profiles, then Download the template. Google also offers a sample spreadsheet and an attributes reference spreadsheet.

Required fields

  • Business code: unique per business, up to 64 characters.
  • Business name.
  • Address, in Google's bulk address formats.
  • A primary phone or a website.
  • A primary category.

Field limits

  • Business name: up to 100 characters.
  • Website: up to 256 characters.
  • Description: up to 750 characters.
  • Additional phones: up to 2.
  • Additional categories: up to 9.
  • Labels: up to 10 per location, each up to 50 characters.

Editing existing stores safely

The business code column is always required. Delete the columns you are not changing. Google warns that if you keep a column heading but leave its cells empty, existing information in that column will be deleted. Google's store code page adds that adding or changing a code on an existing location through upload creates a duplicate.

Free review snapshot

Want this done for your own reviews?

No commitment. We use your details only to send your snapshot and follow up. Privacy policy

Use labels for structure

Labels let you tag locations, for example by region, format or franchisee. Up to 10 labels per location gives enough room for the groupings managers use, and makes filtering easier.

Special hours in bulk

Special hours can be set through the spreadsheet using Google's date formats. This is the practical way to load festive or public holiday hours across a chain.

Hours

Setting opening hours and holiday hours on Google.

Setting opening hours and holiday hours on google

Bulk verification

Google says locations will not be eligible to appear on Search and Maps until verified. After upload and error fixing, request bulk verification. Google links to a separate page on common causes of delay.

Source

Google on verifying profiles in bulk.

Verify Business Profiles in bulk (Google Business Profile Help)

Downloading for audit

You can download profiles to a spreadsheet, with options to include Google updates and photos. The download marks fields with errors and shows where Google has changed information you provided. It is a good monthly audit.

Source

Google on downloading profiles to a spreadsheet.

Download your Business Profiles to a spreadsheet (Google Business Profile Help)

Common mistakes

  • Keeping blank columns with headings in an edit upload.
  • Changing store codes on existing locations by upload.
  • Uploading without fixing dashboard errors.
  • Using a personal Gmail for a large chain.
  • Not downloading to see Google's updates.

Common questions

How many locations do I need?

Google's bulk tools are for businesses with 10 or more locations.

Is there a maximum number of rows?

Google's spreadsheet page does not state one.

Can I update just hours for all stores?

Yes: include the store code and the hours columns only.

Can I update hotel attributes by spreadsheet?

Google lists this as a known issue; use the API and dashboard.

Checklist

  • Business group created.
  • Template downloaded.
  • Required fields complete.
  • Only changed columns in edit uploads.
  • Errors fixed in dashboard.
  • Bulk verification requested.
  • Monthly download audit.

In short

Chains with 10 or more locations can upload and verify profiles in bulk. Use Google's template, fill the required fields, include only changed columns when editing, never change codes on existing stores by upload, and request bulk verification.

Doing this with Falcon

Falcon does not create, edit or manage Google Business Profiles, and it does not post replies to Google. It reads the Google Maps reviews of each of your locations and classifies them into themes, sub-themes and specific issues from your own taxonomy, with the sentiment of each mention and the exact quote behind every label. Once your profiles are in order, that shows what customers are saying store by store and month by month, with small samples flagged so a new or quiet location is not over-read.