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.

To create an import file for your business, you'll need to format a spreadsheet on your computer and upload it to Google My Business Locations.

The spreadsheet can be downloaded in Google My Business Locations by clicking the Download the template link on the "Import locations from a file" screen. 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.

Use the example for reference while creating your spreadsheet. Once you’re finished, upload your finished spreadsheet in any of the following formats: .xls, .xlsx, .ods, .csv, .txt, or .tsv.

Be sure to follow the instructions below for each field. Not all fields need to be completed before uploading the spreadsheet. The interface will prompt you 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
Name
Address Line 1
City
State
Postal Code
Country Code
Main Phone
Primary Category (New!)
Store Code

 

Address Line 2
Alt Phone
Mobile Phone
Fax Phone
Home Page
Additional categories
Email
Hours
Payment Types
Description
Images
Ad phone

 

 

Required fields

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 Code
Enter the full name for your country. You can also use the ISO 3166-1 alpha-2 country code. Google My Business is only supported in the countries listed below. Supported countries and codes

 

ISO name Country   ISO name Country   ISO name Country   ISO name Country
AF Afghanistan   ET Ethiopia   MK Macedonia   RS Serbia
DZ Algeria   FJ Fiji   MG Madagascar   SC Seychelles
AS American Samoa   FI Finland   MW Malawi   SL Sierra Leone
AD Andorra   FR France   MV Maldives   SG Singapore
AO Angola   PF French Polynesia   MT Malta   SK Slovakia
AR Argentina   GA Gabon   MY Malaysia   SI Slovenia
AU Australia   GM Gambia   MU Mauritius   SB Soloman Islands
AT Austria   DE Germany   MX Mexico   ZA South Africa
BH Bahrain   GH Ghana   MN Mongolia   ES Spain
BD Bangladesh   GR Greece   MA Morocco   LK Sri Lanka
BE Belgium   GU Guam   MZ Mozambique   SE Sweden
BJ Benin   HK Hong Kong   NA Namibia   CH Switzerland
BT Bhutan   HU Hungary   NP Nepal   TW Taiwan
BW Botswana   IS Iceland   NL Netherlands   TJ Tajikistan
BR Brazil   IN India   NC New Caledonia   TZ Tanzania
BN Brunei Darussalam   ID Indonesia   NZ New Zealand   TH Thailand
BG Bulgaria   IQ Iraq   NG Nigeria   TG Togo
BI Burundi   IE Ireland   MP Northern Mariana Islands   TO Tonga
KH Cambodia   IL Israel   NO Norway   TN Tunisia
CA Canada   IT Italy   OM Oman   TR Turkey
CF Central African Republic   JP Japan   PK Pakistan   TM Turkmenistan
TD Chad   JO Jordan   PW Palau   UG Uganda
CL Chile   KZ Kazakhstan   PG Papua New Guinea   UA Ukraine
KE Kenya   PH Philippines   AE United Arab Emirates
CO Columbia   KR Korea   PL Poland      
CG Congo   KW Kuwait   PT Portugal   GB United Kingdom
CI Côte d'Ivoire   KG Kyrgyzstan   QA Qatar   US United States
HR Croatia   LA Laos   RO Romania   UZ Uzbekistan
CZ Czech Republic   LV Latvia   RU Russia   VU Vanuatu
CD Democratic Republic of the Congo   LB Lebanon   RW Rwanda   VN Vietnam
DK Denmark   LI Liechtenstein   WS Samoa   YE Yemen
DJ Djibouti   LT Lithuania   ST São Tomé and Príncipe   ZM Zambia
EG Egypt   LU Luxembourg   SA Saudi Arabia   ZW Zimbabwe
EE Estonia   MO Macao   SN Senegal      

Main Phone

This main phone number will appear on Google (area code and phone number).  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

All locations of a business must share the one category that best represents the business. 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.

You can also add additional categories. See below

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; 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 Smart map icon for your business.
    • If you're using an older version of the spreadsheet, add new columns for "Primary category" and "Additional category" in your spreadsheet. You can delete the old "Category" column.

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 "Send feedback" in the gear menu of 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.

Store Code

Store code is 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 appear on Google, including Search and Maps.

An easy way to generate acceptable store codes is to list your first location as “1”, you second as “2”, 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

Examples:
store1, store2
locationNY, locationFL, locationCA
101, 102, 103

In the event that your business moves to another location, please delete the old location from your dashboard, and add the new location 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.

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 non-essential address information. See valid address formats and best practices in our Google My Business quality guidelines. (Maximum 80 characters)

Alt Phone

An alternate phone number by which the business can be contacted.

Mobile Phone

A mobile phone number by which the business can be contacted.

Fax Phone

A fax number by which the business can be contacted.

Home Page

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

Additional categories

All locations of a business must share the one category that best represents the business. You can also add up to 9 additional categories.

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; select a supported country.
  4. Click into 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 "Additional categories" column of your spreadsheet. Separate each category with a comma. 
    • If you're using an older version of the spreadsheet, add new columns for "Primary category" and "Additional categories" in your spreadsheet. You can delete the old "Category" column.

Email

An email address by which the business can be contacted.

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.

 

Payment Types

You can indicate whether or not your business accepts payments in cash only by entering 'cash'. Otherwise, leave this field blank.

Description

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

Images

Photos on your local Google+ page come from images 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 one of two ways:

  1. Include the URL to a photo’s location in the "Images" 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.

Ad phone

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 main phone number already provided as the main phone. It can include toll free and call center numbers and can be repeated if needed.

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.

Custom fields from old data files

Custom fields are no longer supported in the new Locations tool. You should remove any custom fields columns from your file before importing it into the new interface.

You may also see several fields that no longer are updated when you upload your spreadsheet. Those fields include:

  • Ad name
  • Ad icon
  • Categories. Now replaced by "Primary category" and “Additional categories”
  • 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.