How to make a bulk upload spreadsheet for Business Profiles

Known issue: You lot tin can't update hotel attributes through the spreadsheet upload. To update hotel attributes, use the API and dashboard. Larn more virtually Business Profile API.

You can manage an individual contour directly on Search and Maps. To manage multiple profiles in bulk, you lot tin use Business organisation Profile Director.

The bulk upload spreadsheet lets you collect information for multiple Business organization Profiles, and upload the data to verify multiple business organization locations at in one case. To create your spreadsheet:​

  1. On your computer, sign in to Business organization Profile Manager.
  2. In the top correct corner, click Add together profile.
  3. In the dropdown carte du jour that appears, click Import profiles.
    • To download a blank spreadsheet, clickDownload the template. The spreadsheet will download in the language yous apply for your business concern.
    • To find an example of a completed spreadsheet, click Download sample spreadsheet.
    • To learn what details you can use to describe your contour, click Download attributes reference spreadsheet.
  4. Follow the instructions beneath for each field. Follow these address guidelines for uploading businesses in multiple countries or regions.
  5. Add together all businesses that y'all manage before uploading your spreadsheet. Not all fields need to be completed before uploading the spreadsheet, but you'll be asked to fill up in cells that are missing required data.


If you're only updating detail fields for existing businesses in your spreadsheet, you may include but the columns for store code and the fields you want to modify, and not include other columns on the spreadsheet at all. If you include empty columns (columns with headings just no data beneath them) in your spreadsheet, existing information for those columns will be erased. If you accidentally add a new business as well, you'll be alerted that you're missing required column headings.You will also see errors highlighted in your business relationship that demand action. Larn more about error letters.

Delight read this list of mutual bug to make sure that your upload can be verified equally quickly as possible.

Business organization code

A business lawmaking is required for each business you desire to include in your spreadsheet.

A unique ID that you lot assign to each of your businesses to ensure that changes are practical accurately in your account. This value will not be publicly visible anywhere on Google, just it is visible to all profile users of your location.

An piece of cake way to generate acceptable concern codes is to characterization your businesses with a brand identifier and a number (e.k. "GOOG1" for your offset location, "GOOG2" for your second, etc.) and use Google Sheets to keep the numbering for all of your locations.

Business codes must:

  • Exist unique to a specific concern
  • Be no longer than 64 characters
  • Non comprise any leading or trailing spaces
  • Not contain special characters (ie. <, >) or contain a URL

We recommend including your brand proper noun in your concern code to avoid confusion between spreadsheets (for dissever business or personal accounts).

Examples:

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

Don't go on an old business code when one of your businesses moves to a new accost. Instead, replace the old code with a new 1.

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

Concern name

A business proper noun is required for each location.

The name of your business that will announced on Google. Represent your concern exactly as information technology appears in the offline world. Your business name must be no longer than 100 characters. You may capitalize the first alphabetic character of each word or include upward to a iv-letter acronym. However, unabridged words should non be capitalized.

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

Accost

Follow these instructions for entering the addresses of your businesses.

Breadth and longitude

Breadth and longitude aren't required, simply yous tin include them when creating a new business.

Note: If nosotros're not able to validate the listed accost, you lot'll need to provide a latitude and longitude.

You may provide breadth and longitude for new businesses to help us place them on the map. Breadth and longitude are simply used when a business is outset created in your profile and meets other criteria, and will not exist considered if they're included in subsequent spreadsheet uploads for existing businesses.

Base your latitude and longitude on the center of your location. Enter valid coordinates, including a breadth between -ninety and ninety and a longitude between -180 and 180.  Make sure that your values for latitude and longitude each include at to the lowest degree 6 digits afterwards the decimal point, then your business is placed accurately on the map. For example, a latitude value of 37.421998 and longitude value of -122.084059 would accurately identify the Googleplex.

Latitude and longitude will only exist used when there's trouble locating your address on the map. Even if you practise provide them, they might not be used.

To provide breadth and longitude for new businesses:

  1. Add together breadth and longitude columns to your spreadsheet. (They can exist placed anywhere on your spreadsheet.) The column headers depend on your language:
    • In English language, use "Latitude" and "Longitude" every bit column headers.
    • If your dashboard uses a language other than English, download the template spreadsheet and utilize the same cavalcade headers as the template. Regardless of your dashboard language, you tin as well use "Breadth" and "Longitude" in English as your column headers.
  2. Add breadth and longitude for each location in the respective row.

Note: In Japan, the just accepted latitude and longitude format is WGS84.

Primary phone

A primary phone number or website is required for each concern.

The best number for customers to use to accomplish your business organization. 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 business equally direct as possible. For case, you lot should provide an individual business phone number in identify of a call middle. Telephone numbers must exist valid in the land or region where your business is located.

Notation: If you enter a website for a business, the Primary phone field is not required.

Additional phones

Boosted phone numbers are optional.

Up to ii telephone numbers (mobile or landline, no fax) at which your business can exist called, in add-on to your primary phone number.

Website

A website or chief phone number is required for each business.

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

Brand sure that:

  • Googlebot isn't blocked on your site.
  • You've checked Search Console for any possible penalties to your site.

Primary category

A primary category is required for each business.

Choose the category that all-time represents your business using the listing of mutual categories. This category should be consistent across all businesses. If you accept multiple types of businesses (e.g. sub-brands, multiple departments, or various types of operations such as retail, distribution center, and office), this dominion but applies within each of these sub-groups. Check our guidelines for more information on using categories.

Select categories that consummate the statement: "this business IS a" rather than "this business HAS a." Describe your business organization holistically, rather than a list of the services it offers, products it sells, or amenities it features. For example, if your business organisation 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" equally ane of its categories.

You can also add additional categories.

To add together a main category:

  1. Visit the Add your business page in your Business Contour Manager.
  2. Select your country or region from the dropdown menu.
  3. Under the "Category" section, start typing the category that best describes your business. Automobile-complete will suggest supported categories.
  4. Click your chosen category, and so re-create it.
  5. Paste the name of the supported category into the "Chief category" column of your spreadsheet. The primary category y'all set determines the icon displayed for the business on Google Maps.

If you don't meet your desired category appear, select the next all-time option. If you call up a category that primarily describes your business concern is missing, you tin asking that it be added past clicking Carte du jour Menu and then Support and then Transport feedback. We volition consider such requests during our periodic revision of the category list.

Your profile previously used a different set of category standards. Costless-grade categories and numeric codes are no longer supported.

Additional categories

Additional categories are optional and tin can exist added to help depict your business.

Upwards to ix boosted categories that represent your business. As with Primary category, select categories that consummate the statement: "This businessIS a" rather than "this businessHAS a." To add together an additional category:

  1. Visit Concern Profile Manager
  2. Select Add together a concern.
  3. Offset typing the proper noun of the country or region where your businesses are located, and select a supported country or region.
  4. Click into the "Categories" textbox. Beginning typing a category that describes your business; auto-complete will bring upward supported categories.
  5. Re-create your chosen category.
  6. Paste the name of the supported category into the "Additional categories" cavalcade of your spreadsheet. Split each category with a comma.

Hours

Business hours aren't required but they're strongly encouraged to let customers know when to visit your business.

The opening hours of the business. Enter hours for each day of the week in their respective cavalcade. You tin enter hours in 24-60 minutes format:

HH:MM-HH:MM

Or AM/PM format:

HH:MMAM-HH:MMPM

00:00 and 24:00 are equivalent and both acceptable end times for an hours range.

Meet examples for different kinds of opening hours:

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)

Airtight all day

  • X
  • (Or leave the spreadsheet jail 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 up for two sets of hours in one day.

  • 11:30AM-02:00PM, 05:00PM-10:00PM
  • xi:30-14:00, 17:00-22:00

From the business

Enter a brief description of your business concern—what you offer, what sets you autonomously, your history, or annihilation else that'southward helpful for customers to know. Focus primarily on details about your business instead of details about promotions, prices, or sales. Do non include URLs or HTML lawmaking, or exceed 750 characters in the description field. For the full listing of guidelines, read Business description guidelines.

Example: We are an contained ice cream shop located steps from the middle of town, and are proud to be the favorite for locals to run across friends for a cone or call for a fresh pizza, delivered straight to their home. We serve 35 flavors of homemade, manus-churned ice creams and sorbets year-round, and the pizza oven turns out New York-fashion pies every day from midday until shut. Come see us today!

Opening date

Enter the engagement your concern first opened, or volition open, at its electric current location. If your business organisation has multiple locations, each location tin accept its own opening date.

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

Utilise i of the following formats:

     YYYY-MM-DD
YYYY-MM

Photos

Photos are optional. Your profile may testify photos of your business organisation on Maps and Search, even if you lot don't add them yourself.

Photos that depict your business. Photos that appear for your business on Google come up from yous andvarious other sources. All photos you add should conform to our guidelines.

Once a location is verified, add together photos by including the URL to a photo'southward location in the relevant photo column of your spreadsheet: "Logo", "Cover", or "Other Photos". For the "Other Photos" cavalcade, utilise commas to split up the URLs for your photos. Note that photo URLs for locations with the "Not published" status volition be ignored. Learn more than about photo types.

Tip: If you previously added photos to an account that wasn't verified, the URLs for those photos volition no longer appear in your spreadsheet if y'all download information technology from your Business Profile. To add those photos, request bulk verification, so follow the instructions earlier in this section.

Labels

Labels are optional.

Labels permit you lot organize your businesses into groups. Yous can search for businesses by label from the dashboard, and use labels to filter location extensions in Google Ads.

Assign up to 10 unique labels to each location. Labels tin can be up to l 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 lot search for a label in the search box, the results volition include all businesses that contain that label as well as business that incorporate your search text in a unlike field. For instance:

Business 1 has the characterization "Westward declension." Business 2 has the label "East Coast" and has the address line "123 W Ave." Typing "w" in the search box will return both locations.

Google Ads Business concern extensions telephone

This field is optional.

The number used in your business organisation extension ads through Google Ads. Your business organization extension ads can show unlike phone numbers from those y'all have given us to evidence in Google Maps. (For example, y'all might desire to give a cost-gratuitous phone number for reservations in your ads, but demand to provide a local phone number to show in local search results).

If y'all don't enter a business organisation extensions phone, Google Ads will utilise your master telephone. You can use a price-free or telephone call center number. One number can be used for multiple businesses.

This input should comply with Google Ads phone extension specifications. Notation that Google Ads does not allow inclusion of premium numbers (such every bit 1-900 numbers in the U.South., and 871 numbers in the U.K.) for which a user must pay additional charges.

Attributes

Attributes are optional, but they're strongly encouraged to let customers see what your business has to offer.

Attributes of your business. For case, your business concern might offer Wi-Fi to customers, or have outdoor seating. Certain factual attributes (like outdoor seating) are straight editable by you, while subjective attributes (like whether your business organization is pop with locals) rely on the opinions of Google users who've visited your business organization.

When y'all download your spreadsheet, you'll see one column for each attribute that's applicative to at least 1 of the locations in your account. Many attributes won't use to your business, based on its category or country / region. If an attribute has a column in your spreadsheet just doesn't apply to a particular location, you lot'll encounter "[Not Applicative]" in the corresponding cell. At that place'south no need to remove this value before you re-upload your spreadsheet.

If you don't see attribute columns in your spreadsheet, download your profile from your account. Your new spreadsheet will include aspect columns.

Attributes are either yes/no attributes, URL attributes, or choice attributes:

  • Yes/no attributes: "Outdoor seating" requires either a "Yes" or a "No" in your spreadsheet: your business either offers outdoor seating ("Aye") or doesn't ("No"). To edit an attribute for a location, enter either "Yes" or "No" in the corresponding attribute column. Even if you lot enter "No" for some attributes for some locations, the data you provide will help Google show customers the most accurate information near your business, and avert showing attributes that you don't offering.
  • URL attributes: URL attributes require a URL in your spreadsheet: your business's online menu, for instance, appears at a item spider web address. To edit a URL for a location, enter the URL in the corresponding attribute column.
  • Option attributes: These attributes require selection of exactly one of several predefined choices. For example, "Kosher food" is a selection attribute with choices "No Kosher food," "Some kosher food," or "Strictly kosher food." To view all possible choices for each selection aspect, download the attributes reference spreadsheet (instructions below).

To see the list of all possible attributes and their types:

  1. Sign in to Business Contour Managing director.
  2. If you have a single location, in the carte du jour on the left, click Manage locations.
  3. Click Add profile.
  4. Click Import profile.
  5. Click Download attributes reference spreadsheet.

Obsolete fields

Fields supported in Business Profile sometimes change to match the data 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 lot should remove any such field'due south columns from your file before importing it into your Business Contour.

  • Advertising Icon URL
  • Advert Landing Page URL
  • Alt Telephone. Alt phone is at present "Additional phones."
  • Categories. This field has been replaced by "Primary category" and "Additional categories."
  • City. Metropolis is now "Locality."
  • Description. Employ "From the business concern" to describe your business concern to customers.
  • District. District is now "Sub-locality."
  • E-mail
  • Fax
  • Hours. Each day of the week at present has its own column for opening hours.
  • Chief phone. Primary phone is at present "Primary telephone."
  • Mobile phone. If a mobile phone number is the best number for your business, add it equally the "Chief telephone." Otherwise, add it to the new "Additional phones" field. Any numbers previously specified every bit mobile take been automatically re-listed in the "Additional phones" field.
  • Payment Types. Payment types is now "Payments."
  • Preferred photo
  • Profile photograph
  • State.State is now "Administrative area."

Was this helpful?

How can we amend it?