Create your bulk upload spreadsheet
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:
- Sign in to Google My Business and choose the account you would like to manage.
- Click the plus sign menu in the bottom right corner of your screen.
- Click Import locations from a file .
- Click Download the template to download a blank spreadsheet. The spreadsheet will download in the language you’re using to navigate Google My Business. Click Download sample spreadsheet to see an example of a completed spreadsheet.
- Follow the instructions below for each field. Follow these address guidelines for uploading locations in multiple countries.
- Add all of the locations that you manage before uploading your spreadsheet. Not all fields need to be completed before uploading the spreadsheet, but you'll be asked to fill in cells that are missing required information.
If you’re only updating particular fields for existing locations in your spreadsheet, you may include only the columns for store code and the fields you want to change, and not include other columns on the spreadsheet at all. If you include empty columns (columns with headings but no information beneath them) in your spreadsheet, existing information for those columns will be erased. If you accidentally add a new location as well, you’ll be alerted that you’re missing required column headings.You will also see errors highlighted in your account that need action. Learn more about error messages
Latitude and longitude
AdWords location extensions phone
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).
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
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").
Follow these instructions for entering the addresses of your locations.
Latitude and longitude
You may provide latitude and longitude for new locations to help us place them on the map. Latitude and longitude are only used when a location is first created in Google My Business and meets other criteria, and will not be considered if they’re included in subsequent spreadsheet uploads for existing locations.
Base your latitude and longitude on the center of your location. We’ll only use latitude and longitude when we have trouble locating your address on the map. Even if you do provide them, they might not be used by Google My Business.
To provide latitude and longitude for new locations:
- Add latitude and longitude columns to your spreadsheet. (They can be placed anywhere on your spreadsheet.) The column headers depend on your language:
- In English, use “Latitude” and “Longitude” as column headers.
- If your dashboard uses a language other than English, download the template spreadsheet and use the same column headers as the template. Regardless of your dashboard language, you can also use “Latitude” and “Longitude” in English as your column headers.
- Add latitude and longitude for each location in the corresponding row.
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.
Note: If you enter a website for a location, the Primary phone field is not required.
Up to 2 phone numbers (mobile or landline, no fax) at which your business can be called, in addition to your primary phone number.
URL of the website associated with the business. Enter the complete URL, including the http:// or https://. Up to 256 characters will be displayed.
Choose the category that best represents your business using the list of common categories. 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.
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:
- Visit the Add your business page in Google My Business.
- Select your country from the dropdown menu.
- Under the “Category” section, start typing the category that best describes your business. Auto-complete will suggest supported categories.
- Click your chosen category, then copy it.
- 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, select the next best option. If you think a category that primarily describes your business is missing, you can request that it be added by clicking Feedback in the three dash menu . We will consider such requests during our periodic revision of the category list.
Google My Business previously used a different set of category standards. Free-form categories and numeric codes are no longer supported.
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:
- Visit Google My Business
- Select Add a location.
- Start typing the name of the country where your locations are located, and select a supported country.
- Click into the "Categories" textbox. Start typing a category that describes your business; auto-complete will bring up supported categories.
- Copy your chosen category.
- Paste the name of the supported category into the "Additional categories" column of your spreadsheet. Separate each category with a comma.
The opening hours of the business. Enter hours for each day of the week in their respective column. You can enter hours in 24-hour format:
or AM/PM format:
See examples for different kinds of opening hours:
Closes at midnight
Open 24 hours
Closed all day
- (or leave the spreadsheet cell empty)
Open past midnight. Include these hours in the column for the day when the set begins.
Open for two sets of hours in one day. No more than two sets per day are allowed.
- 11:30AM-02:00PM, 05:00PM-10:00PM
- 11:30-14:00, 17:00-22:00
You can also add special hours.
Once a location is verified, add photos by including the URL to a photo’s location in the relevant photo column of your spreadsheet: "Logo", "Profile", "Cover", or "Other Photos". For the "Other Photos" column, use commas to separate the URLs for your photos. Note that photo URLs for locations with the "Not published" status will be ignored. Learn more about photo types
Note: If you previously added photos to an account that wasn't verified, the URLs for those photos will no longer appear in your spreadsheet if you download it from Google My Business Locations. To add those photos, request bulk verification, then follow the instructions earlier in this section.
Labels let you organize your locations into groups. You can search for locations by label from the dashboard, and use labels to filter location extensions in AdWords.
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 that 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.
Fields supported in Google My Business 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 bulk upload tool. You should remove any such field's columns from your file before importing it into Google My Business.
- 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.”
- City. City is now "Locality."
- District. District is now "Sub-locality"
- Hours. Each day of the week now has its own column for opening hours.
- 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
- State. State is now "Administrative area."