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.

ColumnWhat it holdsExample
search_business_typeThe category you searched that found this rowPlumber
search_business_locationsThe location you searched that found this rowDenver, Colorado, United States
Business NameThe name shown on Google MapsNorthside Plumbing Co.
WebsiteThe website on the listinghttps://northsideplumbing.example.com
AddressThe full address in one column1420 Elm St, Denver, CO 80202
Phone NumberThe phone number on the listing(303) 555-0142
CategoryThe main categoryPlumber
ServicesOther categories and services the business listsDrainage service, Water heater installation
RatingAverage star rating4.7
Rating CountHow many ratings that average is based on238
Opening HoursHours for each day, where shownMon: 8 AM to 6 PM; Sun: Closed
LatitudeMap position, north to south39.7392
LongitudeMap position, east to west-104.9903
bookingLinkAn online booking link, where the listing has onehttps://book.example.com/northside
Thumbnail Image UrlA link to the main photo on the listinghttps://images.example.com/northside.jpg
Google Maps URLA link that opens the listing on Google MapsA 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 Address column 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.

Start Your Export

Still stuck?

Our team usually replies the same day.

Contact support
Google Maps Export Fields Explained, Column by Column