Google Maps Export Fields Explained
Every column in a Google Maps Scraper file explained, what isn't included, why some cells are blank, and practical ways to use each field for sales and research.
4 min read
Every Google Maps Scraper file has the same 16 columns in the same order, so you can set up your spreadsheet or CRM once and reuse it. This guide explains the Google Maps export fields one by one, what isn't in the file, why some cells are empty, and how to put each column to work.
All Google Maps Export Fields at a Glance
The examples below are made up, but they show the kind of value you'll see.
| Column | What it holds | Example |
|---|---|---|
| search_business_type | The category you searched that found this row | Plumber |
| search_business_locations | The location you searched that found this row | Denver, Colorado, United States |
| Business Name | The name shown on Google Maps | Northside Plumbing Co. |
| Website | The website on the listing | https://northsideplumbing.example.com |
| Address | The full address in one column | 1420 Elm St, Denver, CO 80202 |
| Phone Number | The phone number on the listing | (303) 555-0142 |
| Category | The main category | Plumber |
| Services | Other categories and services the business lists | Drainage service, Water heater installation |
| Rating | Average star rating | 4.7 |
| Rating Count | How many ratings that average is based on | 238 |
| Opening Hours | Hours for each day, where shown | Mon: 8 AM to 6 PM; Sun: Closed |
| Latitude | Map position, north to south | 39.7392 |
| Longitude | Map position, east to west | -104.9903 |
| bookingLink | An online booking link, where the listing has one | https://book.example.com/northside |
| Thumbnail Image Url | A link to the main photo on the listing | https://images.example.com/northside.jpg |
| Google Maps URL | A link that opens the listing on Google Maps | A link to the listing |
What's Not in the File
To keep expectations clear, a Google Maps Scraper file does not include:
- Email addresses
- Social media links
- Place ID
- Whether the listing is claimed
- Photo count or price level
- Separate street, city, state and postcode columns
Emails, social links and the people behind a business come from Enrich Contacts, which you run on a delivered list in Lists & Exports. See local business decision makers for what it can add.
Why Some Cells Are Empty
A field is only filled when the business shows that detail on Google Maps. A busy restaurant usually has everything. A one-person contractor might only show a name and a phone number. A blank cell isn't an error. It means the detail isn't on the listing.
The fields most often empty are bookingLink (most businesses don't have one), Website (common for small local trades), Opening Hours, and Rating with Rating Count for businesses with no reviews yet. Businesses that visit their customers sometimes hide their street address too. The column headers always stay, even when a column is empty for every row, so your import mappings keep working.
How to Use Each Field
search_business_type and search_business_locations
When one order covers many categories or cities, filter these to split the file into one list per category or per city, ready for different reps or campaigns.
Category and Services
Search can return related businesses, so filter Category to keep only the type you want. Use a "contains" filter on Services to find niches, like plumbers who also install water heaters.
Website and Phone Number
These are your main ways to reach the business. A blank Website is a sales signal on its own if you sell web design or marketing. The Website column is also what Find Business Email and Find Company Social Media read when you enrich the list.
Rating and Rating Count
Use them together. A 3.4 rating may point to a business that needs reputation help. A 4.9 with only 7 ratings may need more reviews. A business with hundreds of ratings is busy and established. Sort by these to decide who to contact first.
Opening Hours
Call when someone is there to answer. You can also filter for businesses open on weekends or late evenings.
Latitude and Longitude
Drop the list onto a map, draw sales territories or measure distance from your office.
bookingLink and Thumbnail Image Url
If you sell booking software, rows without a bookingLink are worth a look. The thumbnail link is handy if you show the businesses in your own directory or tool.
Google Maps URL
One click opens the listing so you can check it by hand. Each listing has its own link, so it's the best column for removing duplicates when you combine several files.
Tip: If your CRM wants city, state and postcode in separate fields, split the
Addresscolumn on commas with Text to Columns in Excel or Split text to columns in Google Sheets. Check a few rows first, because some addresses have more parts than others.
How This Compares to a Database Export
Exports from the Local Business Database use a shorter set of columns: Business Name, Website, Address, Phone Number, Main Category, Categories, Rating, Rating Count, Opening Hours and Google Maps URL. If you combine both kinds of file, map Category to Main Category and Services to Categories.
Ready to download your file? Export Google Maps Places to CSV or Excel shows how.
Ready to try it?
Start your export with MapsDaddy. No browser extension, Google account or API key needed.
Related Guides
Still stuck?
Our team usually replies the same day.