Create your bulk upload spreadsheet

Please read this list of common issues to make sure that your upload can be verified as quickly as possible.

The bulk upload spreadsheet allows you to collect information for multiple locations in one place, and upload the data to verify multiple business locations at once. To create your spreadsheet:

  1. Go to the “Import locations” screen in Google My Business Locations.
  2. Click Download the template to download a blank spreadsheet. The .csv spreadsheet will download in the language you’re using to navigate the Locations tool. If you're having issues with the .csv file, copy header rows from this example.
  3. Follow the instructions below for each field. Not all fields need to be completed before uploading the spreadsheet. You will be asked to fill in any empty cells beneath required headers, but you may update them in bulk using Google My Business Locations. You will also see errors highlighted in your account that need action. Learn more about error messages
Required fields Additional fields
Store code
Business name
Address line 1
City
State
Postal code
Country
Primary phone
Primary category

Address line 2
Additional phones
Website
Additional categories
Hours
Photos
Description
Labels
AdWords location extensions phone

Required fields


Store code
A unique ID that you assign to each of your locations to ensure that changes are applied accurately in your account. This value will not be publicly visible anywhere on Google.

An easy way to generate acceptable store codes is to label your locations with a brand identifier and a number (e.g. "GOOG1" for your first location, "GOOG2" for your second, etc.) and use Google Sheets to continue the numbering for all of your locations.

Store codes must:

  • be unique to a specific location
  • be under 60 characters in length
  • not contain any leading or trailing spaces
  • not contain special characters (ie. <,>) or contain a URL

We recommend including your brand name in your store code to avoid confusion between spreadsheets (for separate business or personal accounts).

Examples:
G1, G2, G3
Goog101, Goog102, Goog103
GClaremont, GMainStreet, GDowntown

Don't keep an old store code when one of your locations moves to a new address. Instead, delete the old location and add a new one with a new store code.

If you have not included store codes for some locations or you have used the same store code for multiple locations in your account, you will need to address this before you can import a new spreadsheet. Learn more about missing and duplicate store codes


Business name
The name of your business that will appear on Google. Represent your business exactly as it appears in the offline world. Your business name must be under 60 characters. You may capitalize the first letter of each word or include up to a four-letter acronym. However, entire words should not be capitalized.

If your business is located within a mall or a container store (for example, a Starbucks inside a Safeway grocery store), do not include this information in the title. Only include the name of the core business in the location name (e.g. "Starbucks"). 


Address line 1
The precise address for the location. Add any additional useful address information in Address line 2. This includes shopping center names, cross streets, and other non-essential address information. See valid address formats and best practices in our quality guidelines and address guidelines. (Maximum 80 characters)

City
The city where your business is located. (Maximum 80 characters)

State
The state where your business is located. Using the common abbreviation for your state is generally preferred, such as CA for California or NSW for New South Wales. (Maximum 80 characters)

Postal code
A postal code that is valid in the country where your business is located. If the postal code begins with zero, make sure that your spreadsheet formatting does not remove the zero as the first digit.

Country
The full name for your country. You can also use the ISO 3166-1 alpha-2 country code. See the list of all countries that Google My Business supports

Primary phone

The best number for customers to use to reach your business. This phone number may be for a mobile device or landline (no fax numbers). Vanity numbers should be entered numerically. Provide a phone number that connects to your location as directly as possible. For example, you should provide an individual location phone number in place of a call center. Phone numbers must be valid in the country where your location is located.


Primary category

The category that best represents your business. This category should be consistent across all locations. If you have multiple types of locations (e.g. sub-brands, multiple departments, or various types of operations such as retail, distribution center, and office), this rule only applies within each of these sub-groups. Check our guidelines for more information on using categories, and see popular categories.

Select categories that complete the statement: "This business IS a" rather than "this business HAS a." Describe your business holistically, rather than a list of the services it offers, products it sells, or amenities it features. For example, if your location is a hotel that has an ATM, do not include the category "ATM." Instead, the provider of the ATM should create a separate location and add "ATM" as one of its categories.

You can also add additional categories.

To add a primary category:

  1. Visit Google My Business Locations.
  2. Select Add a location.
  3. Start typing the name of the country where your locations are located, and select a supported country.
  4. Click the Categories textbox. Start typing the category that best describes your business. Auto-complete will bring up supported categories.
  5. Copy your chosen category.
  6. Paste the name of the supported category into the "Primary category" column of your spreadsheet. The primary category you set determines the icon displayed for the location on Google Maps.

If you don't see your desired category appear, please select the next best option. If you think a category that primarily describes your business is missing, you can send a request by clicking Feedback in the three dash menu in the Locations tool. We will add such requests for consideration during our periodic revision of the category list.

The Locations tool previously used a different set of category standards. Free-form categories and numeric codes are no longer supported.


Additional fields

In addition to the required information above, you may add the following additional fields. Each country has a different set of additional field values, so make sure the values you use are appropriate for the country of your business.

Address line 2

A second line for the street address of the business. You can also include information like mail boxes, suite numbers,  cross streets, and other address information. See valid address formats and best practices in our Google My Business quality guidelines. (Maximum 80 characters)


Additional phones

Up to 2 phone numbers (mobile or landline, no fax) at which your business can be called, in addition to your primary phone number.


Website

URL of the website associated with the business. Enter the complete URL, including the http:// or https://. Up to 256 characters will be displayed.


Additional categories

Up to 9 additional categories that represent your business. As with Primary category, select categories that complete the statement: "This business IS a" rather than "this business HAS a." To add an additional category:

  1. Visit Google My Business Locations.
  2. Select Add a location.
  3. Start typing the name of the country where your locations are located, and select a supported country.
  4. Click into the "Categories" textbox. Start typing a category that describes your business; auto-complete will bring up supported categories.
  5. Copy your chosen category.
  6. Paste the name of the supported category into the "Additional categories" column of your spreadsheet. Separate each category with a comma.

Hours

The operating hours of the business. You may use the formatting below, or add your hours in bulk once you’ve uploaded your spreadsheet.

2 formats to choose from:

  • 24 hour format: dayOfWeek:hh:mm:hh:mm
  • AM/PM format: dayOfWeek:hh:mm:AMorPM:hh:mm:AMorPM
dayOfWeek: The numeric representation of the day of week
1 - Sunday
2 - Monday
3 - Tuesday
4 - Wednesday
5 - Thursday
6 - Friday
7 - Saturday

hh: Stands for the hour in the following formats
In 24 hour format: ranges from 0 to 23
In 12 hour format: ranges from 1 to 12

mm: Stands for the minutes that range from 0 to 59.

AMorPM: Stands for one of the two values "AM" or "PM" (Use only in 12 hour AM/PM format)

 
IMPORTANT: Be sure to include a comma (,) between each entry

Examples:
Multiple terms are used to display multiple sets of hours.
To specify that a business is open Mondays through Fridays 10:00 am to 6:00 pm and Saturday 12:00 pm to 8:00 pm:

 
  1. Option 1 - In 24 hour format:
    2:10:00:18:00,3:10:00:18:00,4:10:00:18:00,5:10:00:18:00,6:10:00:18:00,7:12:00:20:00
    Explanation:
    The first entry is for Monday (day 2).
    The opening hour is 10:00 (10 am).
    The closing hour is 18:00 (6 pm).

    The subsequent time sets follow the same format for the days of Tuesday through Saturday.

     
  2. Option 2 - In AM/PM format:
    2:10:00:AM:6:00:PM,3:10:00:AM:6:00:PM,4:10:00:AM:6:00:PM,5:10:00:AM:6:00:PM,6:10:00:AM:6:00:PM,7:12:00:PM:8:00:PM
    Explanation:
    The first entry is for Monday (day 2).
    The opening hour is 10:00 AM.
    The closing hour is 6:00 PM.

    The subsequent time sets follow the same format for the days of Tuesday through Saturday.

Photos

Photos that depict your business. Photos that appear for your business on Google come from photos you add as well as from various other sources. All photos you add should conform to our guidelines. Once a location is verified, you can add photos in two ways:

  1. Include the URL to a photo’s location in the "Photos" column of your spreadsheet. Note that photo URLs for unverified locations will be ignored.
  2. Add photos directly to a verified local Google+ page for your location.

Click on the photo thumbnail to view it on the local Google+ page for that location.

Note: If you previously added photos to an account that was not verified, the URLs for those photos will no longer appear in your spreadsheet. To add those photos, request bulk verification, then follow the steps above.


Description

A description of the business. Do not include tabs, extra lines, or newlines for text. (Maximum 200 characters)


Labels

Labels allow you to organize your locations into groups. Assign up to 10 unique labels to each location. Labels can be up to 50 characters long and should not include invalid characters (i.e. < or >).

To include commas in the label name, use the string "%2c" in your spreadsheet. For example, “1%2c000+ Daily Visitors” would create the label “1,000+ Daily Visitors”.

When you search for a label in the search box, the results will include all locations that contain that label as well as locations which contain your search text in a different field. For example:

  • Location 1 has label “West coast”. Location 2 has label “East coast” and has address line 1 “123 West Ave”. Typing “west” in the search box will return both locations.


AdWords location extensions phone

The number used in your location extension ads through AdWords. Your location extension ads can show different phone numbers from those you have given us to show in Google Maps. (For example, you might want to give a toll-free phone number for reservations in your AdWords ads, but need to provide a local phone number to show in local search results).

This can be the same or different from the phone number already provided as the primary phone. It can be a toll-free or call center number. One number can be used for multiple locations.

This input should comply with AdWords phone extension specifications. Note that AdWords does not allow inclusion of premium numbers (such as 1-900 numbers in the U.S., and 871 numbers in the U.K.) for which a user must pay additional charges.


Obsolete fields

Fields supported in Google My Business Locations sometimes change to match the information displayed to users on Search and Maps. See below for a list of fields that are no longer supported in the Locations tool. You should remove any such field's columns from your file before importing it into Google My Business Locations.

  • Ad Icon URL
  • Ad Landing Page URL
  • Alt Phone. Alt phone is now "Additional phones."
  • Categories. This field has been replaced by "Primary category" and “Additional categories.”
  • Email
  • Fax
  • Latitude/longitude. Locations are now mapped using their street address. You can also confirm a location’s address by moving your pin on the map in the Locations tool.
  • Main phone. Main phone is now "Primary phone."
  • Mobile phone. If a mobile phone number is the best number for your business, add it as the "Primary phone." Otherwise, add it to the new "Additional phones" field. Any numbers previously specified as mobile have been automatically relisted in the "Additional phones" field.
  • Payment Types
Was this article helpful?