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.
|Address line 1:||1599 Amphitheatre Parkway|
|Address line 1:||Avenida Paulista, 358|
|Address line 1:||Graha Bumi Surabaya Lt. V|
|Address line 2:||Jl. Basuki Rahmat no.106 - 128|
|Administrative area:||Jawa Timur|
To see additional examples of international addresses:
- Sign in to Google My Business and choose the account you would like to manage.
- Click the create icon in the bottom right corner of your screen.
- Click Import locations from a file.
- Click Download sample spreadsheet.
Refer to the guidelines below to determine what you should enter into each field of the spreadsheet:
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
- 1600 Amphitheatre Parkway
- 25 Massachusetts Avenue NW
2 Inner Ring Road
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)
|Tambon / Khwaeng||Thailand|
|Village / Township||Malaysia|
- Asa norte (Brazil)
- Bundang-gu (South Korea)
- Centro (Mexico)
The city or town where the business is located. (Maximum 80 characters)
|Amphoe / Khet||Thailand|
- Chicago (United States)
- Berlin (Germany)
- London (United Kingdom)
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.
|Emirate||United Arab Emirates|
- California (United States)
- Ontario (Canada)
- Uttar Pradesh (India)
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.
|Postal code||Various countries|
|ZIP code||United States|
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