Search
Clear search
Close search
Google apps
Main menu

Address format for bulk upload

The bulk upload spreadsheet supports a general address format, so you can verify your locations in many countries.

Address formats can vary widely by country, so all fields may not be required for every location. Depending on the country, some fields will be required, optional, or not allowed. For example, administrative area is required in Australia, optional in Mexico, and not allowed in France. Address line 1 and country are always required.

Enter the address information for each location. You’ll be notified if you need to correct any fields that are missing required information, or contain information that is not allowed for that country.

Example addresses
Address line 1: 1599 Amphitheatre Parkway
Locality: Mountain View
Administrative area: CA
Country: US
Postal code: 94043

 

Address line 1: Avenida Paulista, 358
Sub-locality: Bela Vista
Locality: São Paulo
Administrative area: SP
Country: BR
Postal code: 01310-000

 

Address line 1: Graha Bumi Surabaya Lt. V
Address line 2: Jl. Basuki Rahmat no.106 - 128
Locality: Surabaya
Administrative area: Jawa Timur
Country: ID
Postal code: 61257
 

To see additional examples of international addresses:

  1. Sign in to Google My Business and choose the account you would like to manage.
  2. Click the create icon  in the bottom right corner of your screen.
  3. Click Import locations from a file. 
  4. Click Download sample spreadsheet.

Refer to the guidelines below to determine what you should enter into each field of the spreadsheet:

Address lines
You can have up to 5 address lines per location, but only the first line is required. 

All necessary address information that doesn't fit into the other fields listed below. For most countries, the first line will include a street number and street name. Suite numbers, floors, building numbers, etc. may also be included.

Information like cross-streets and nearby landmarks should only be included in regions where the official street address doesn’t accurately pinpoint the business's location.

You can have up to 5 address lines for each location (maximum 80 characters per line). Learn more about address entry guidelines

Examples:

  • 1600 Amphitheatre Parkway
  • 25 Massachusetts Avenue NW
    Suite 209
  • A-205
    Natasha Apartments
    2 Inner Ring Road
Sub-locality
Sub-localities are not required. They're not allowed for locations in certain countries, such as Japan.

The neighborhood where the business is located. A neighborhood is smaller than a locality (city) and was previously referred to in Google My Business as "district.” (Maximum 80 characters)

Country-specific name Country
District South Korea
Neighborhood Brazil
Mexico
Suburb New Zealand
Nigeria
Philippines
South Africa
Tambon / Khwaeng Thailand
Townland Ireland
Village / Township Malaysia

Examples:
  • Asa norte (Brazil)
  • Bundang-gu (South Korea)
  • Centro (Mexico)
Locality
Localities are required for locations in most countries, but for certain countries they're optional or not allowed at all. 

The city or town where the business is located. (Maximum 80 characters)

Country-specific name Country
Amphoe / Khet Thailand
City Various countries
District Hong Kong
Turkey
Post town Norway
Sweden
United Kingdom
Suburb Australia

Examples:
  • Chicago (United States)
  • Berlin (Germany)
  • London (United Kingdom)
Administrative area
Administrative areas may be required, optional, or not allowed for locations, depending on the country. 

The state or province where the business is located. Enter the full name (e.g. "California"), common postal abbreviation (e.g. "CA"), or country subdivision (ISO 3166-2) code (e.g. "US-CA"). (Maximum 80 characters)

Requirements for this field can vary by language and country, so you may need to try entering different variations of your administrative area before it’s accepted. If you encounter errors, try entering your administrative area using:

  • A different option listed above. For example, if the full name is not accepted, try using the common postal abbreviation or the ISO 3166-2 code. 
  • An alternative spelling of the full name. 
  • A different local language.
  • Latin script. For example, if your local language is written in a script like Cyrillic or Kanji, try entering the administrative area name using Latin script.
Country-specific name Country
Area Hong Kong
County Ireland
Taiwan
Department Colombia
Nicaragua
District Nauru
Do/Si South Korea
Emirate United Arab Emirates
Island Various countries
Oblast Russia
Ukraine
Parish Barbados
Jamaica
Prefecture Japan
Province Various countries
State Various countries

Examples:
  • California (United States)
  • Ontario (Canada)
  • Uttar Pradesh (India)
Postal code
Postal code requirements vary widely by country and may be required, optional, or not allowed. 

The postal code of the business. If the postal code begins with zero, make sure that your spreadsheet formatting doesn't automatically remove the zero as the first digit.

Country-specific name Country
Eircode Ireland
Pincode India
Postal code Various countries
ZIP code United States
Country
Countries are required for all locations. 

The country or region where the business is located. Enter the country’s full name, or use the two-letter code. See the list of all countries that Google My Business supports

Was this article helpful?
How can we improve it?
false
Shape the future of Google support

User research studies help us improve our support services by allowing us to get feedback directly from users like you. Learn more, or sign up now for invitations to participate in future studies.