Format the CSV file
A My Business Provider must compile the business details of all merchants into a single CSV file that follows a specific format.
To create a CSV file in the correct format:
- Open the CSV sheet template.
- Fill in the columns with the required information as shown in the sample data file. Follow the directions below to identify the mandatory and optional fields.
Mandatory fields (required to generate the codes)
- Location name.
- Two-letter region code. Find your region code.
Optional fields (recommended if available)
Address lines 1-5 : Add an accurate address of the business location. PO box or mailbox addresses are not acceptable.
Locality: Add name of the city or town under locality. Add name of the neighborhood, boroughs, or district under sub-locality.
Administrative area: Add name of the state, province, an oblast, or a prefecture that represents the highest administrative subdivision used for addresses in your country or region.
Postal code: If your country uses postal codes, add a postal code or zip code of the address.
- Primary phone: Add a local phone number in this format:
+441234567890.This should be a local phone number instead of a central, call center helpline number whenever possible.
- Website URL: Add a business website link in this format:
- Primary category ID: Add the business category in this format:
gcid:grocery_store.To identify the category that best describes the business, refer the examples of typical category IDs below.
Examples of typical category IDs:
Note: If you don’t have any data for one of the optional fields, just leave it blank. Don’t delete the column.
Once you have filled in all required fields for your businesses, visit My Business Provider to upload and submit the CSV file.
CSV file FAQsExpand all Collapse all
A file with the verification codes is downloaded to your device automatically upon submitting your CSV in My Business Provider. Once the codes are received, you are responsible for distributing them to each business.
If a location in the CSV upload is already managed on Google, the "Already Claimed by" column in the output file displays an obscured email address for the current owner of the location. The email hint is formatted to protect user privacy.