Create a bulk upload spreadsheet for Business Profiles

You can manage your Business Profile on Google Search and Maps. To manage multiple profiles at the same time, you can use Business Profile Manager.

To add a new Business Profile, on Google Search, select More Add a new Business Profile.

You can collect info for Business Profiles and upload them at the same time. To verify multiple business locations, you can use the bulk upload spreadsheet.

Create a bulk upload spreadsheet

1. Sign in to Business Profile Manager.
2. At the top right, select Add profile.
3. From the dropdown menu, select Import profiles.
   • To download a blank spreadsheet: Select Download the template.
     • The file matches your business language.
   • To find a filled-out example: Select Download sample spreadsheet.
   • To check info to add on your profile: Select Download attributes reference spreadsheet.
4. Fill in the spreadsheet with the required info.
5. Before you upload it, add all the businesses you manage.

Tips:

• If you upload businesses from different countries or regions, make sure to use the correct address format.
• You don’t need to fill out all the fields. If required info is missing, you’ll be asked to fill in those cells.

Understand common upload issues

• If you only update a certain field for existing businesses in your spreadsheet, you can delete the columns you don’t need. The "Business code" column is always required.
• If you include columns with headings but no info under them in your spreadsheet, existing info for those columns will be deleted.
• If you add a new business by mistake, you’ll get an alert that shows what columns are missing. Errors that need action are highlighted in your account. Learn more about error messages.

To make sure your upload is verified, learn more about common issues that delay bulk verification.

Learn about spreadsheet fields

Business code

Important: A business code is required for each business in your spreadsheet.

Business codes are unique IDs for each of your businesses. They make sure that any changes you make to your account are correct. These codes aren’t shown on Google, but can be found by those who manage your location’s profile.

Business codes must:

• Be different for each business
• Be no longer than 64 characters
• Not have extra spaces before and after
• Not contain special characters like "<," ">," or URL

Create an easy-to-remember codes

To avoid confusion in your spreadsheets, you can add your brand name to your business codes. Learn how to add and manage Business Profile store codes for bulk uploads.

Examples:

• G1, G2, G3
• Goog101, Goog102, Goog103
• GClaremont, GMainStreet, GDowntown

Tips:

• Before you upload a new spreadsheet, make sure each business location has a unique code.
• If one of your businesses moves to a new location, replace the old code with a new one.

Business name

Important: A business name is required for each location.

Your business name is what shows on Google. It should match how your business is represented offline.

Your business name can:

• Be up to 100 characters
• Include an acronym of up to 4 letters
• Be in title case
  • Do not write in all capital letters.

Tip: If your business is inside a mall or another store, do not include that info in the name title. Only include your business name.

Address

To add a business address, follow the address formats for bulk uploads.

Latitude & longitude

Important: You don't have to include latitude and longitude, but you can add them when you create a new business. If the listed address can’t be verified, you need to provide latitude and longitude.

To help us place your new business on Maps, you can give us its latitude and longitude. This info is only used when a business is first added to your profile and meets other requirements. They aren’t considered if they’re included in subsequent spreadsheet uploads for existing business.

Provide coordinates for a new business

To get the correct latitude and longitude, use the center of your location.

Your coordinates must include:

• A latitude between -90 and 90.
• A longitude between -180 and 180.
• At least 6 digits after the decimal point. For example, a latitude value of 37.421998 and longitude value of -122.084059 would accurately place the Googleplex.

To provide latitude and longitude for new businesses:

1. Add latitude and longitude columns anywhere in your spreadsheet.
2. Use the correct column headers based on your language.
   • For English: Use “Latitude” and “Longitude” as column headers.
   • For other languages: Download the template spreadsheet for your language and use those column headers.
     • You can use “Latitude” and “Longitude” in English as your column headers for any dashboard language
3. Add the latitude and longitude in the row for each location.

Tip: In Japan, the only accepted latitude and longitude format is WGS84.

Primary phone

Important: You need to include a primary phone number or website for each business.

Your primary phone number is the best number for customers to contact your business. You can use a mobile or landline number.

This number should connect to your business as directly as possible. For example, a business phone number is more direct than a call center number. Phone numbers must be valid in the country or region where your business is located.

Tips:

• If you add a website for a business, the “Primary phone” field isn’t required.
• If you use a vanity number, enter it as numbers.

Additional phones

Important: Additional phone numbers are optional.

You can add up to 2 mobile or landline numbers for your business in addition to your primary phone number.

Website

Important: A website or primary number is required for each business.

You can provide customers with your business’s website.

To share your website, enter the full URL, which includes “http://” or “https://.”

• The field shows up to 256 characters.

Tips:

• Make sure Googlebot isn’t blocked on your website.
• To check if there are any problems with your website, go to Search Console.

Primary category

Important: You need to include a primary category for each business.

You can choose a category that best represents your business. The category you choose should be the same for all your businesses. If you have different types of businesses like retail, distribution centers, and offices, this rule still applies within those groups. For more info, learn more about guidelines for representing your business.

To select a category:

• Choose a category that describes what your business is, not what it has.
• Describe your business as a whole, not just its services, products, or amenities it offers. For example, if your business is a hotel that has an ATM, do not include the category "ATM."

Tip: If more than one category describes your business, you can add additional categories.

To add a primary category:

1. On your Business Profile, go to Add your business page.
2. From the dropdown menu, select your country or region.
3. In the “Category” section, add the category that best describes your business.
   • Auto-complete suggests supported categories.
4. Copy your chosen category.
5. In the "Primary category” column, paste the category name.
   • The Google Maps icon shown for your business depends on the category you set.

To request a new category, select More Support Send feedback.

Tip: If your preferred category doesn’t show as an option, select the next best one.

Additional categories

Important: Additional categories are optional. To help describe your business, you can add them.

You can add up to 9 additional categories that represent your business. Choose categories that describe what your business is, not what it has.

To add an additional category:

1. On your Business Profile, select Add a business.
2. Enter the country or region where your businesses are located.
3. On the list, select the supported country or region.
4. In the “Category” section, add the category that best describes your business.
   • Auto-complete suggests supported categories.
5. Copy your chosen category.
6. In the “Additional categories” column, paste the supported category name.
   • Separate each category with a comma.

Hours

Important: You don't have to include business hours, but you can add them to let customers know when they can visit your business.

To add your business hours:

1. In the “Each day’s” column, add the hours for that day.
2. Choose the format for your hours:
   • 24-hour format: HH:MM:-HH:MM
   • AM or PM format: HH:MMAM-HH:MM-PM

Examples:

• Standard hours:
  • 09:00AM-05:00PM
  • 09:00-17:00
• Closes at midnight:
  • 09:00AM-12:00AM
  • 09:00-00:00
• Open 24 hours:
  • 12:00AM-12:00AM
  • 00:00-00:00 or 00:00-24:00
• Closed all day:
  • X
  • Leave the spreadsheet cell empty
• Open past midnight: Include these hours in the column for the day when the set begins.
  • 06:00PM-02:00AM
  • 18:00-02:00
• Open for two sets of hours in one day:
  • 11:30AM-02:00PM, 05:00PM-10:00PM
  • 11:30-14:00, 17:00-22:00

Tips:

• If your business hours change temporarily, you can add special hours.
• If your business hours end at midnight, you can use 00:00 and 24:00. Both are acceptable end times for the hours range.

Business description

Important: A business description is optional.

You can add a short description of your business that shows in the “From the business” section of your Business Profile. You can include details of what you can offer, what sets you apart, your business history, or other useful info.

Your business description must:

• Include details about your business
• Exclude info about deals promotions, prices, or sales
• Exclude web addresses like URLs or HTML code
• Be limited to 750 characters

To learn how to represent your business online, refer to our business description guidelines.

Opening date

Important: You don’t have to include an opening date.

You can add the date of your business opened or will open at its current location. If your business has multiple locations, each location can have its own opening date.

You can enter a date up to one year in the future, but it won’t show on Google until 90 days before the date. Only the year and month of your opening date are required.

Use one of these formats:

• YYYY-MM-DD
• YYYY-MM

Photos

Important: Photos are optional. Your profile might show photos of your business on Maps and Search, even if you don’t add them.

You can add photos that represent your business. Your business photos on Google may come from you or other sources. Learn how Google sources info in Business Profiles. All your photos should meet our guidelines.

To add photos to a verified location:

1. Choose a photo for the “Logo,” “Cover,” or “Other Photos” category.
2. In that category’s column, add the photo URL.
3. If you add multiple photos in the "Other Photos" column, separate the URLs with commas.

   • If a location’s status is “Not published,” photo URLs for that location are ignored. Learn more about photo types.

Tip: If you previously added photos to an unverified account, your photo URLs won’t show if you download it from your Business Profile. To include them, request bulk verification. Then, follow the instructions above.

Labels

To organize your businesses into groups, you can use labels. On your dashboard, you can search for businesses by label. You can use labels to filter location assets in Google Ads. Learn about location assets.

If you search for label results may include:

• All businesses that use that label.
• Businesses that match your search term in a different field. For example, if business one uses the label "West Coast," and business two uses the label "East Coast" and has the address line "123 West Ave.," the search term “west” shows both locations as results.

To use labels:

• Add up to 10 different labels for each location.
• Limit each label to 50 characters. Do not include invalid characters like “<” or “>."

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

Google Ads phone number

Important: A Google Ads phone number is optional. Numbers that charge users extra fees like 1-900 in the US or 871 in the UK, aren’t allowed.

You can add the phone number used in your location asset ads through Google Ads. This number differs from the one shown on Maps, like a toll-free phone or call-center number.

If you don’t add a Google Ads phone number, Google Ads uses your primary phone number. This number also shows in local search results. One number can be used for multiple businesses.

The number you add must meet the requirements. Learn more about call ad requirements.

Attributes

Important: Attributes are optional but strongly encouraged. They let customers know what your business offers. 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.

Your business's attributes can include its amenities like Wi-Fi access or outdoor seating. You can edit certain factual attributes, while others, like popularity with locals, depend on feedback from customers who visited your business.

To add business attributes:

• On your downloaded spreadsheet, there’s one column for each attribute that applies to at least one of your locations.
• Some attributes may not apply based on your business category or location. If an attribute has a column but doesn’t apply to a location, the cell shows “[NOT APPLICABLE].” You don’t need to remove this value before you re-upload your spreadsheet.

Tip: If you don’t find the attribute column in your spreadsheet, download your profile from your account.

• Your new spreadsheet includes attribute columns.

Types of attributes

There are 3 types of business attributes:

• Yes or no attributes:
  • Some attributes require either “yes” or “no” in your spreadsheet.
  • To edit a yes or no attribute for a location, in the attribute column, enter “yes” or “no.”
  • If you enter “no” for certain location attributes, the data helps Google show the most accurate info about your business.
• URL attributes:
  • URL attributes require a URL in your spreadsheet. For example, your business’s online menu web address is a URL attribute. Learn how to show your business menu on Google.
  • To edit a URL for a location, in the “Attribute” column, enter “yes” or “no.”
• Selection attributes:
  • Some attributes, like "Outdoor seating," require you to select one of several options. For example, the attribute "Kosher food" offers choices like "No kosher food," "Some kosher food," or "Strictly kosher food."
  • To find all possible choices for each selection attribute, download the attributes reference spreadsheet.

To find the full list of supported attributes and types:

1. Go to your Business Profile.
2. On the left, select Manage locations.
3. Select Add profile Import profile Download attributes reference spreadsheet.

Unsupported fields

Before you import your spreadsheet to your Business Profile, remove any columns that contain unsupported fields.

The bulk upload tool no longer supports these fields:

• Ad icon URL
• Ad landing page URL
  • Now listed as "Additional phones."
• Categories
  • Now split into "Primary category" and “Additional categories.”
• City
  • Now called "Locality."
• Description
  • Now called "From the business."
• District
  • Now called "Sub-locality."
• Email
• Fax
• Hours
  • Each day of the week now has its own column for opening hours.
• Main phone
  • Now called "Primary phone."
• Mobile phone
  • Use this as your "Primary phone" if it’s your main number.
  • Otherwise, add it to the new "Additional phones" column.
  • Any existing mobile numbers were automatically moved to the "Additional phones" column.
• Payment types
  • Now called "Payments."
• Preferred photo
• Profile photo
• State
  • Now called "Administrative area."

Social media links

To add your social media links, follow the format for social media links.