Please read this list of common issues to make sure that your upload can be verified as quickly as possible.
To create a bulk upload file for your business, you'll need to format a spreadsheet locally and upload it to your dashboard. The spreadsheet can be in any of the following formats: .csv, .txt, .xls, .tsv, .xlsx, and .ods. You will need to create a header row for your document, which you can copy from this template.
Be sure to follow the instructions below for each field. Not all fields need to be completed before uploading the spreadsheet. The interface will prompt you to fill in any empty cells beneath required headers, but you may update them in bulk using the management interface.
| Required attributes | Optional attributes |
|
Name Address Line 1 City State Postal Code Country Code Main Phone Category Latitude and Longitude |
Store Code Address Line 2 Alt Phone Mobile Phone Fax Phone Home Page Hours Payment Types Description |
Required attributes
NameThe name of your business that will appear on Google. Represent your business exactly as it appears in the offline world. Please don’t attempt to add things like location, directions or other qualifiers to the title. Your business name must be under 60 characters. You may capitalize the first letter of each word or include up to a four-letter acronym. However, entire words should not be capitalized.
Address Line 1
Some businesses may be located within a mall or a container store. If your business is one of these, and you'd like to include this information in your listing, specify the container store in parentheses in the business name field. For example, Starbucks (inside Safeway).
The precise address for the business. Add any additional useful address information in Address Line 2. This includes shopping center names, cross streets, and other non-essential address information. (Maximum 80 characters)
City
The city where your business is located. (Maximum 80 characters)
State
The state where your business is located. Using the common abbreviation for your state is generally preferred, such as CA for California or NSW for New South Wales. (Maximum 80 characters)
Postal Code
A postal code that is valid in the country where your business is located. If the postal code begins with zero, make sure that your spreadsheet formatting does not remove the zero as the first digit.
Country Code
Enter the full name for your country. You can also use the ISO 3166-1-alpha-2 short country name where your business is located. Google Places for Business is only supported in the countries listed below. Supported countries and codes
Category
Latitude and Longitude
1 - Sunday
2 - Monday
3 - Tuesday
4 - Wednesday
5 - Thursday
6 - Friday
7 - Saturday
hh: Stands for the hour in the following formats
In 24 hour format: ranges from 0 to 23
In 12 hour format: ranges from 1 to 12
mm: Stands for the minutes that range from 0 to 59.
AMorPM: Stands for one of the two values "AM" or "PM" (Use only in 12 hour AM/PM format)
Examples:
Multiple terms are used to display multiple sets of hours.
To specify that a business is open Mondays through Fridays 10:00 am to 6:00 pm and Saturday 12:00 pm to 8:00 pm:
| ISO name | Country | ISO name | Country | ISO name | Country | ISO name | Country | |||
| AF | Afghanistan | FJ | Fiji | MG | Madagascar | RS | Serbia | |||
| DZ | Algeria | FI | Finland | MW | Malawi | SC | Seychelles | |||
| AS | American Samoa | FR | France | MV | Maldives | SL | Sierra Leone | |||
| AD | Andorra | PF | French Polynesia | MT | Malta | SG | Singapore | |||
| AO | Angola | GA | Gabon | MY | Malaysia | SK | Slovakia | |||
| AR | Argentina | GM | Gambia | MU | Mauritius | SI | Slovenia | |||
| AU | Australia | DE | Germany | MX | Mexico | SB | Soloman Islands | |||
| AT | Austria | GH | Ghana | MN | Mongolia | ZA | South Africa | |||
| BH | Bahrain | GR | Greece | MA | Morocco | ES | Spain | |||
| BD | Bangladesh | GU | Guam | MZ | Mozambique | LK | Sri Lanka | |||
| BE | Belgium | HK | Hong Kong | NA | Namibia | SE | Sweden | |||
| BJ | Benin | HU | Hungary | NP | Nepal | CH | Switzerland | |||
| BT | Bhutan | IS | Iceland | NL | Netherlands | TW | Taiwan | |||
| BW | Botswana | IN | India | NC | New Caledonia | TJ | Tajikistan | |||
| BR | Brazil | ID | Indonesia | NZ | New Zealand | TZ | Tanzania | |||
| BN | Brunei Darussalam | IQ | Iraq | NG | Nigeria | TH | Thailand | |||
| BG | Bulgaria | IE | Ireland | MP | Northern Mariana Islands | TG | Togo | |||
| BI | Burundi | IL | Israel | NO | Norway | TO | Tonga | |||
| KH | Cambodia | IT | Italy | OM | Oman | TN | Tunisia | |||
| CA | Canada | JP | Japan | PK | Pakistan | TR | Turkey | |||
| CF | Central African Republic | JO | Jordan | PW | Palau | TM | Turkmenistan | |||
| TD | Chad | KZ | Kazakhstan | PG | Papua New Guinea | UG | Uganda | |||
| CL | Chile | KE | Kenya | PH | Philippines | UA | Ukraine | |||
| CN | China | KR | Korea | PL | Poland | AE | United Arab Emirates | |||
| CG | Congo | KW | Kuwait | PT | Portugal | GB | United Kingdom | |||
| CI | Côte d'Ivoire | KG | Kyrgyzstan | QA | Qatar | US | United States | |||
| HR | Croatia | LA | Laos | RO | Romania | UZ | Uzbekistan | |||
| CZ | Czech Republic | LV | Latvia | RU | Russia | VU | Vanuatu | |||
| CD | Democratic Republic of the Congo | LB | Lebanon | RW | Rwanda | VN | Vietnam | |||
| DK | Denmark | LI | Liechtenstein | WS | Samoa | YE | Yemen | |||
| DJ | Djibouti | LT | Lithuania | ST | São Tomé and Príncipe | ZM | Zambia | |||
| EG | Egypt | LU | Luxembourg | SA | Saudi Arabia | ZW | Zimbabwe | |||
| EE | Estonia | MO | Macao | SN | Senegal | |||||
| ET | Ethiopia | MK | Macedonia |
This main phone number will appear on Google (area code and phone number). Provide a phone number that connects to your individual business location as directly as possible. For example, you should provide an individual location phone number in place of a call center. Phone numbers must be valid in the country where your listing is located.
You may choose up to five categories from each listing from the list below. These can be added in advance using the numeric mapping below, or in-product using the editing interface, which will auto-complete based on the available categories.
- Click on an area to see its specific categories: Business
Education
Category ID Category name 1 Business to Business 2 Business to Business - Machine Shops 3 Business to Business - Manufacturers 4 Business to Business - Wholesalers EntertainmentCategory ID Category name 5 Education 6 Education - Beauty Schools 7 Education - Charter Schools 8 Education - Colleges & Universities 479 Education - Computer Training 9 Education - Driving Schools 10 Education - Elementary Schools 11 Education - High Schools 12 Education - Junior High Schools 13 Education - Kindergartens 14 Education - Middle Schools 15 Education - Music Schools 16 Education - Night Schools 17 Education - Preschools 18 Education - Private Schools 19 Education - Real Estate Schools 20 Education - Religious Schools 21 Education - Tutoring 22 Education - Vocational & Technical Schools Government OfficesCategory ID Category name 23 Entertainment 24 Entertainment - Adult 25 Entertainment - Archery Ranges 26 Entertainment - Arenas & Stadiums 27 Entertainment - Art Galleries 28 Entertainment - Athletic, Fitness & Health Clubs & Gymnasiums 29 Entertainment - Auto Racing & Speedways 30 Entertainment - Ballrooms 31 Entertainment - Batting Cages 32 Entertainment - Beaches 33 Entertainment - Billiards & Pool 34 Entertainment - Bingo 35 Entertainment - Bowling 36 Entertainment - Bridge & Card Clubs 519 Entertainment - Climbing 37 Entertainment - Comedy Clubs 38 Entertainment - Country Clubs 39 Entertainment - Dance Classes 40 Entertainment - Dance Clubs 41 Entertainment - Dinner Theaters 488 Entertainment - Disc Jockeys 42 Entertainment - Driving Ranges 517 Entertainment - Football 43 Entertainment - Golf Courses 44 Entertainment - Gymnastics 518 Entertainment - Hiking 497 Entertainment - Karaoke 512 Entertainment - Live Music 45 Entertainment - Miniature Golf Courses 46 Entertainment - Movie Theaters 47 Entertainment - Museums 48 Entertainment - Night Clubs 49 Entertainment - Opera Houses 50 Entertainment - Orchestras & Symphonies 51 Entertainment - Paintball 52 Entertainment - Parks 53 Entertainment - Performing Arts Theaters & Playhouses 54 Entertainment - Planetariums 55 Entertainment - Racquetball Courts 56 Entertainment - Self Defense & Martial Arts Classes 57 Entertainment - Shooting Ranges 58 Entertainment - Skating Rinks 59 Entertainment - Ski Slopes 60 Entertainment - Soccer Clubs 61 Entertainment - Spas 62 Entertainment - Squash Courts 63 Entertainment - Swimming Pools 64 Entertainment - Tennis Courts 65 Entertainment - Tourist Attractions 66 Entertainment - Wineries 67 Entertainment - Yoga Classes Health & MedicalCategory ID Category name 68 Government Offices 69 Government Offices - County 70 Government Offices - Courts 71 Government Offices - Education & School 72 Government Offices - Federal 73 Government Offices - Fire Departments 74 Government Offices - Local 75 Government Offices - Police 76 Government Offices - Post Offices 77 Government Offices - Sheriffs 78 Government Offices - State OrganizationsCategory ID Category name 79 Health & Medical 80 Health & Medical - Abortion Services 478 Health & Medical - Acupuncture 81 Health & Medical - Alcoholism Counseling & Treatment 82 Health & Medical - Allergists 513 Health & Medical - Alternative Medicine 83 Health & Medical - Animal Hospitals 84 Health & Medical - Assisted Living 85 Health & Medical - Cardiologists 86 Health & Medical - Chiropractors 87 Health & Medical - Clinics & Medical Centers 88 Health & Medical - Counseling 89 Health & Medical - Dentists 90 Health & Medical - Dermatologists 91 Health & Medical - Endocrinologists 92 Health & Medical - Family & General Practice Physicians 93 Health & Medical - Gastroenterologists 94 Health & Medical - Geriatrics 95 Health & Medical - Gynecologists 96 Health & Medical - Hematologists 97 Health & Medical - Hospices 98 Health & Medical - Hospitals 99 Health & Medical - Immunologists 100 Health & Medical - Infectious Diseases 101 Health & Medical - Infertility 102 Health & Medical - Internal Medicine 103 Health & Medical - Nephrology 104 Health & Medical - Neurologists 105 Health & Medical - Neurosurgeons 106 Health & Medical - Nursing Homes 107 Health & Medical - Obstetricians 108 Health & Medical - Oncologists 109 Health & Medical - Ophthalmologists 110 Health & Medical - Optometrists 111 Health & Medical - Orthodontists 112 Health & Medical - Orthopedics 113 Health & Medical - Otolaryngologists 114 Health & Medical - Pain Management 115 Health & Medical - Pediatricians 116 Health & Medical - Physical Therapists 117 Health & Medical - Plastic Surgeons 118 Health & Medical - Podiatrists 119 Health & Medical - Psychiatrists 120 Health & Medical - Psychologists 121 Health & Medical - Pulmonologists 122 Health & Medical - Radiologists 123 Health & Medical - Rheumatologists 124 Health & Medical - Sports Medicine 125 Health & Medical - Surgeons 126 Health & Medical - Travel Medicine 127 Health & Medical - Urologists 128 Health & Medical - Veterinarians Real EstateCategory ID Category name 129 Organizations 130 Organizations - Chambers of Commerce 131 Organizations - Charities 132 Organizations - Churches 133 Organizations - Fraternal 134 Organizations - Historical Societies 135 Organizations - Mosques 136 Organizations - Non-profit 137 Organizations - Professional 138 Organizations - Religious 139 Organizations - Sports Clubs 140 Organizations - Stock Exchanges 141 Organizations - Synagogues & Temples 142 Organizations - Volunteer 143 Organizations - Welfare 144 Organizations - Youth RestaurantsCategory ID Category name 145 Real Estate 146 Real Estate - Agents & Realtors 147 Real Estate - Apartment Buildings & Complexes 148 Real Estate - Appraisers 507 Real Estate - Commercial 487 Real Estate - Home Inspection 486 Real Estate - Property Management 149 Real Estate - Surveyors Retail StoresCategory ID Category name 150 Restaurants 151 Restaurants - Afghan 152 Restaurants - African 153 Restaurants - All You Can Eat 154 Restaurants - American 155 Restaurants - Argentinean 156 Restaurants - Australian 157 Restaurants - Austrian 158 Restaurants - Banquet Halls 159 Restaurants - Barbecue 160 Restaurants - Bars, Pubs & Taverns 161 Restaurants - Belgian 162 Restaurants - Brazilian 163 Restaurants - Breakfast & Brunch 164 Restaurants - Breweries & Brewpubs 165 Restaurants - British 166 Restaurants - Buffets 167 Restaurants - Cafes 168 Restaurants - Cajun 169 Restaurants - Caribbean 170 Restaurants - Caterers 171 Restaurants - Chilean 172 Restaurants - Chinese 173 Restaurants - Coffee Shops 174 Restaurants - Colombian 175 Restaurants - Creole 176 Restaurants - Cuban 177 Restaurants - Czech 178 Restaurants - Delicatessens 179 Restaurants - Delivery 180 Restaurants - Dessert 181 Restaurants - Dim Sum 182 Restaurants - Diners 183 Restaurants - Ethiopian 184 Restaurants - Family Style 185 Restaurants - Fast Food 186 Restaurants - Fine Dining 187 Restaurants - French 188 Restaurants - German 189 Restaurants - Greek 190 Restaurants - Halal 191 Restaurants - Hungarian 192 Restaurants - Ice Cream 193 Restaurants - Indian 194 Restaurants - Indonesian 195 Restaurants - Irish 196 Restaurants - Italian 197 Restaurants - Jamaican 198 Restaurants - Japanese 199 Restaurants - Korean 200 Restaurants - Kosher 201 Restaurants - Lebanese 202 Restaurants - Malaysian 203 Restaurants - Mexican 204 Restaurants - Middle Eastern 205 Restaurants - Moroccan 206 Restaurants - Nepali 207 Restaurants - Pakistani 208 Restaurants - Pizza 209 Restaurants - Polish 210 Restaurants - Polynesian 211 Restaurants - Portuguese 212 Restaurants - Russian 213 Restaurants - Sandwiches 214 Restaurants - Seafood 215 Restaurants - Southern 216 Restaurants - Southwestern 217 Restaurants - Spanish 218 Restaurants - Sports Bars 219 Restaurants - Steakhouses 220 Restaurants - Sushi 221 Restaurants - Swedish 222 Restaurants - Takeout 223 Restaurants - Tapas 224 Restaurants - Thai 225 Restaurants - Tibetan 226 Restaurants - Turkish 227 Restaurants - Vegan 228 Restaurants - Vegetarian 229 Restaurants - Vietnamese ServicesCategory ID Category name 230 Retail Stores 231 Retail Stores - Animals & Pets 232 Retail Stores - Antiques & Collectibles 233 Retail Stores - Appliances 234 Retail Stores - Art Supplies 235 Retail Stores - Automobile Alarms 236 Retail Stores - Automobile Audio 237 Retail Stores - Automobile Parts & Supplies 238 Retail Stores - Automobiles 239 Retail Stores - Automobiles - New 240 Retail Stores - Automobiles - Used 241 Retail Stores - Awards & Trophies 242 Retail Stores - Baby Clothing & Supplies 243 Retail Stores - Bakeries 244 Retail Stores - Banks 245 Retail Stores - Beds & Mattresses 246 Retail Stores - Beer 247 Retail Stores - Bicycle 248 Retail Stores - Boating 249 Retail Stores - Books & Magazines 250 Retail Stores - Bridal 251 Retail Stores - Building Supplies 252 Retail Stores - Butchers 257 Retail Stores - CDs, Records & Tapes 253 Retail Stores - Camera & Photography 254 Retail Stores - Candles 255 Retail Stores - Candy 256 Retail Stores - Carpet & Flooring 258 Retail Stores - Charity & Thrift 259 Retail Stores - Cheese 260 Retail Stores - China & Glassware 261 Retail Stores - Cigars, Cigarettes, Tobacco & Smoking 262 Retail Stores - Clothing 263 Retail Stores - Comic Books 264 Retail Stores - Computers 265 Retail Stores - Consignment 266 Retail Stores - Convenience 267 Retail Stores - Cosmetics 268 Retail Stores - Costumes 269 Retail Stores - Craft Supplies 270 Retail Stores - Credit Unions 273 Retail Stores - DVDs, Videotapes & Movies 271 Retail Stores - Department 272 Retail Stores - Discount 274 Retail Stores - Electrical Equipment 275 Retail Stores - Electronics 276 Retail Stores - Equipment Rental 277 Retail Stores - Fabric, Sewing Supplies & Notions 278 Retail Stores - Fireplace Equipment 279 Retail Stores - Fireworks 280 Retail Stores - Fish & Seafood 281 Retail Stores - Fishing Supplies 282 Retail Stores - Flea Markets 283 Retail Stores - Florists 284 Retail Stores - Furniture 285 Retail Stores - Games & Hobbies 286 Retail Stores - Garden & Gardening 287 Retail Stores - Gas Stations 288 Retail Stores - Gift 499 Retail Stores - Gift Baskets 289 Retail Stores - Green Grocers 290 Retail Stores - Grocery & Supermarkets 291 Retail Stores - Guns 292 Retail Stores - Hardware 293 Retail Stores - Health Food 294 Retail Stores - Hot Tubs, Saunas, Spas & Swimming Pools 295 Retail Stores - Hunting 296 Retail Stores - Jewelry 297 Retail Stores - Kitchen 298 Retail Stores - Laundromats 299 Retail Stores - Lighting 300 Retail Stores - Lingerie 301 Retail Stores - Liquor 302 Retail Stores - Lumber 303 Retail Stores - Maps 304 Retail Stores - Medical Supplies 305 Retail Stores - Mobile Homes 306 Retail Stores - Motorcycles 307 Retail Stores - Music & Musical Instruments 308 Retail Stores - Newspapers 309 Retail Stores - Office Equipment & Supplies 310 Retail Stores - Opticians 493 Retail Stores - Outdoor Furniture 311 Retail Stores - Outlets 312 Retail Stores - Paint, Wallpaper & Wall Coverings 313 Retail Stores - Paper 314 Retail Stores - Party Supplies 315 Retail Stores - Pawn Shops 316 Retail Stores - Pharmacies 317 Retail Stores - Plants 318 Retail Stores - Plumbing Equipment & Supplies 319 Retail Stores - Recreational Vehicles 320 Retail Stores - Restaurant Supplies 321 Retail Stores - Shoes 322 Retail Stores - Shopping Centers & Malls 323 Retail Stores - Skiing 324 Retail Stores - Sporting Goods 325 Retail Stores - State Stores 326 Retail Stores - Surplus 327 Retail Stores - Telephones 328 Retail Stores - Theater Supplies 329 Retail Stores - Tires 330 Retail Stores - Toupees & Wigs 331 Retail Stores - Toys 332 Retail Stores - Tuxedo Rental 333 Retail Stores - Video Games 334 Retail Stores - Watches 335 Retail Stores - Wine 336 Retail Stores - Wool & Yarn TransportationCategory ID Category name 337 Services 338 Services - Accounting 339 Services - Advertising Agencies 340 Services - Alteration & Tailoring 341 Services - Animal Control 342 Services - Animal Shelters 343 Services - Animal Training 344 Services - Appliance Repair 345 Services - Appraisal 346 Services - Arborists & Tree Services 347 Services - Architects 348 Services - Astrologers, Palm Readers & Psychics 349 Services - Attorneys 350 Services - Auctions 351 Services - Auto Detailing & Washing 352 Services - Automobile Repair 514 Services - Bail Bonds 353 Services - Barbers 354 Services - Beauty Salons 355 Services - Body Piercing 356 Services - Burglar Alarm 357 Services - Cable & Satellite Television 358 Services - Car Washes 359 Services - Carpet Cleaning 360 Services - Cemeteries 361 Services - Check Cashing 362 Services - Cleaning & Maid 492 Services - Computer Consulting 482 Services - Computer Networking 363 Services - Computer Repair 508 Services - Computer Security 364 Services - Conference Facilities & Halls 365 Services - Construction 366 Services - Consulting 367 Services - Convention Facilities 368 Services - Copying 369 Services - Courier & Delivery 370 Services - Court Reports & Stenographers 371 Services - Currency Exchange 506 Services - Data Recovery 372 Services - Dating 373 Services - Day Care Centers & Nurseries 374 Services - Dry Cleaning 375 Services - Dumps & Landfills 509 Services - E-commerce 481 Services - Electrical 376 Services - Electronics Repair 485 Services - Embroidery 377 Services - Employment & Temporary Agencies 378 Services - Engineering 379 Services - Engraving 380 Services - Event Planning 381 Services - Facsimile sending & receiving 382 Services - Family Planning 383 Services - Fencing & Fence Repair 384 Services - Financial Planning 385 Services - Food Banks 386 Services - Funeral Homes & Mortuaries 387 Services - Garage Door Installation 388 Services - Gardening & Landscaping 389 Services - General Contractors 390 Services - Glass & Window Repair 391 Services - Graphic Design 392 Services - Hair Removal 393 Services - Handyman 394 Services - Heating, Ventilation & Air Conditioning 395 Services - Home Remodeling & Repair 396 Services - Human & Social Services 397 Services - Importing & Exporting 398 Services - Insurance 399 Services - Interior Design 490 Services - Internet Marketing 400 Services - Internet Service Providers 505 Services - Investments 401 Services - Janitorial Services 402 Services - Junkyards 403 Services - Kennels 404 Services - Landscape Design 405 Services - Laundry 406 Services - Legal Aid 407 Services - Libraries 408 Services - Locksmiths 409 Services - Marinas 480 Services - Marketing 410 Services - Massage 411 Services - Modeling Agencies 412 Services - Mortgage Services 413 Services - Moving 511 Services - Music 414 Services - Nail Salons 415 Services - Notary Public 494 Services - Painting 416 Services - Passport 417 Services - Personal Trainers 418 Services - Pest Control 419 Services - Pet Boarding 420 Services - Pet Grooming 483 Services - Pet Sitting 421 Services - Photographers 422 Services - Piano Repair & Tuning 501 Services - Picture Framing 423 Services - Plumbing 510 Services - Pressure Washing 424 Services - Printing 515 Services - Process Servers 489 Services - Public Relations 425 Services - Publishing 426 Services - Record Management & Storage 427 Services - Recording Studios 428 Services - Recycling 495 Services - Roofing 502 Services - Secretarial 429 Services - Security 1241 Services - Self Storage 430 Services - Shipping & Receiving 431 Services - Shoe Repair 500 Services - Siding 491 Services - Signs 496 Services - Skin Care 432 Services - Snow Plowing & Removal 475 Services - Software Development 433 Services - Stables 434 Services - Storage 435 Services - Swimming Pool & Hot Tub 436 Services - Talent Agencies 437 Services - Tanning Salons 438 Services - Tattooing 439 Services - Tax Preparation 440 Services - Telephone 441 Services - Ticket Sales 442 Services - Title Companies 443 Services - Towing 444 Services - Trash & Waste Removal 498 Services - Trucking 445 Services - Upholstery 446 Services - Utilities 447 Services - Video Production 448 Services - Watch Repair 449 Services - Web Design 476 Services - Web Development 474 Services - Web Hosting 503 Services - Wedding Photographers 450 Services - Wedding Planning 451 Services - Welding 504 Services - Window Treatments TravelCategory ID Category name 452 Transportation 453 Transportation - Airlines 454 Transportation - Airport Shuttles 455 Transportation - Airports 456 Transportation - Automobile Rental 522 Transportation - Bicycling 457 Transportation - Boats & Ferries 458 Transportation - Bus 459 Transportation - Limousines 460 Transportation - Parking Facilities 461 Transportation - Subways 462 Transportation - Taxicabs 463 Transportation - Trains Category ID Category name 464 Travel 465 Travel - Bed & Breakfasts 466 Travel - Camps & Campgrounds 467 Travel - Casinos 477 Travel - Cruises 468 Travel - Hostels 469 Travel - Hotels 470 Travel - Motels 471 Travel - Recreational Vehicle Parks 472 Travel - Tour Operators 473 Travel - Travel Agents 484 Travel - Vacation Rentals
IMPORTANT: Be sure to include a comma (,) between each category.
Example:
5,54,136
- You may also add up to 5 of your own categories.
IMPORTANT: Be sure to include a comma (,) between each category.
Example:
Education, Entertainment - Planetariums, Organizations - Non-profit
What are latitude and longitude?
Latitude and longitude are the geographic coordinates that describe a place’s exact location. Using the earth's equator line as a reference, latitude is measured north and south. Longitude is measured east and west of the Greenwich meridian line.
Latitude values are represented by a decimal value between -90 and 90, while longitude values are between -180 and 180. For example, your latitude and longitude may be 41.879435, -87.635751.
We’ll automatically find your business’s latitude and longitude based on its address, so you don’t need to include it in your sheet before you upload it.
What if my latitude and longitude aren’t automatically detected?
If your latitude and longitude aren’t found automatically, first make sure that the address you provided for your business is correct. You can also confirm the location of your placemarker by manually moving it to the right spot on the map in your Places account.
Optional attributes
In addition to the required information above, you may add the following optional attributes. Each country has a different set of optional attribute values, so make sure the values you use are appropriate for the country of your business.
The store code is a unique ID that you assign to each of your businesses. A given listing’s store code must not change after it is initially set. These codes can help you identify your businesses at a glance.
Examples:
store1, store2
locationNY, locationFL, locationCA
101, 102, 103
The store code must be under 60 characters in length and not contain any leading or trailing white space. Please make sure that one specific store code is only linked to one specific location. In the event where your business moves to another location, please delete the old location from your dashboard, and add the new location with a new store code.
If you're having problems with duplicate listings in the interface, it could be because you've uploaded the same listing with multiple store codes. Deleting the store codes from your listings should cause the duplicates in the interface to disappear, and then you can reapply store codes to the unique location if you wish.
A second line for the street address of the business. You can also include information like mail boxes, suite numbers, cross streets, and other non-essential address information. (Maximum 80 characters)
An alternate phone number by which the business can be contacted.
A mobile phone number by which the business can be contacted.
A fax number by which the business can be contacted.
URL of the web page associated with the business. Enter the complete URL, including the http://
An email address by which the business can be contacted.
The operating hours of the business. Up to 255 characters will be displayed. You may use the formatting below, or add your hours in bulk once you’ve uploaded your spreadsheet.
2 formats to choose from:
- 24 hour format: dayOfWeek:hh:mm:hh:mm
- AM/PM format: dayOfWeek:hh:mm:AMorPM:hh:mm:AMorPM
1 - Sunday
2 - Monday
3 - Tuesday
4 - Wednesday
5 - Thursday
6 - Friday
7 - Saturday
hh: Stands for the hour in the following formats
In 24 hour format: ranges from 0 to 23
In 12 hour format: ranges from 1 to 12
mm: Stands for the minutes that range from 0 to 59.
AMorPM: Stands for one of the two values "AM" or "PM" (Use only in 12 hour AM/PM format)
IMPORTANT: Be sure to include a comma (,) between each entry
Examples:
Multiple terms are used to display multiple sets of hours.
To specify that a business is open Mondays through Fridays 10:00 am to 6:00 pm and Saturday 12:00 pm to 8:00 pm:
- Option 1 - In 24 hour format:
2:10:00:18:00,3:10:00:18:00,4:10:00:18:00,5:10:00:18:00,6:10:00:18:00,7:12:00:20:00
Explanation:
The first entry is for Monday (day 2).
The opening hour is 10:00 (10 am).
The closing hour is 18:00 (6 pm).
The subsequent time sets follow the same format for the days of Tuesday through Saturday.
- Option 2 - In AM/PM format:
2:10:00:AM:6:00:PM,3:10:00:AM:6:00:PM,4:10:00:AM:6:00:PM,5:10:00:AM:6:00:PM,6:10:00:AM:6:00:PM,7:12:00:PM:8:00:PM
Explanation:
The first entry is for Monday (day 2).
The opening hour is 10:00 AM.
The closing hour is 6:00 PM.
The subsequent time sets follow the same format for the days of Tuesday through Saturday.
You can indicate whether or not your business accepts payments in cash only. If your business accepts payment by any other means, ensure that "This location only accepts cash payments" is not checked.
A description of the business. Do not include tabs, extra lines or new lines for text. (Maximum 200 characters)
Custom attributes from old data files
Custom attributes are no longer supported in the new bulk listing interface. You should remove any custom attribute columns from your file before importing it into the new interface.