41 fields per row, documented one by one.

The business name exactly as it appears on the Google Maps listing, kept verbatim so it still matches when you reconcile against your CRM.

The single category Google treats as the listing's main classification — the one that decides which searches it competes in.

Every category the listing declares, primary plus secondary, pipe-separated in one cell.

Google's stable unique identifier for the listing — the only field in the export you should deduplicate on.

The numeric customer ID behind a Google Maps listing, useful for building direct links and for joining against older datasets.

The phone number as the business published it, in the local formatting its own customers would recognise.

The same phone number normalised to the international E.164 standard, ready for a dialler, a CRM import or a WhatsApp API call.

The primary email address for the business, crawled from its own website — not from the Maps listing, which does not carry one.

Every distinct address found on the business website, pipe-separated, so you can pick the right inbox instead of taking the first one.

The exact URL the primary email address was found on, so every address in the export is traceable back to its origin.

The full website URL published on the listing — the field that gates email extraction and drives the digital weakness score.

The bare hostname pulled out of the website URL, which is the form you need for grouping, matching and enrichment lookups.

The business's Instagram URL, found on its website, which for many local categories is a livelier signal than the website itself.

The Facebook page URL linked from the business website — often the only web presence a small local business maintains.

The LinkedIn company URL from the business website — the strongest indicator in the export that a listing is a B2B operation.

The X profile URL linked from the business website, when one is published.

The complete formatted address in one cell, exactly as the listing renders it, with the individual parts also available as their own columns.

The street line on its own — street name and building number, without the city or postal code.

The sub-city area — district, borough or neighbourhood — which is the level most local campaigns are actually planned at.

The city component of the address — the column most lead lists get grouped, split and assigned by.

The first-level administrative division — state, province or region, depending on the country.

The country the listing sits in — the field that drives phone normalisation and every compliance decision downstream.

The postal or ZIP code, which is the tightest geographic unit in the export and the one direct mail is planned around.

The listing's latitude in decimal degrees — half of the coordinate pair that makes a lead list mappable without geocoding.

The listing's longitude in decimal degrees, the companion to latitude for mapping, radius filters and route planning.

Google's open location code for the listing — a short grid reference that identifies a place where street addresses are unreliable.

The average star rating on the listing, best read next to review count — a five-star average from two reviews is noise.

How many reviews the listing carries — the column that tells you whether the rating beside it means anything.

When the most recent review landed — the single best indicator in the export of whether a business is still trading.

The text of the most recent reviews in one cell, which is where the specific complaint you can open a conversation with lives.

The weekly opening pattern in one cell, so a call lands when someone is actually there to answer it.

Whether an owner has claimed the listing — the highest-intent filter in the catalog for anyone selling local marketing.

Google's coarse price band for the listing, which is a rough proxy for what a business can afford to spend with you.

How many photos the listing carries — the fastest numeric read on whether anyone is maintaining the profile.

Direct links to the listing's photos, pipe-separated, for building a visual audit without opening every profile by hand.

A straight boolean for whether the listing publishes a website — the single most-used filter for web design and local marketing outreach.

A composite score ranking how poorly a business is represented online, so the most winnable prospects sort to the top of your list.

The plain-language list of what pulled the digital weakness score up, so the number is never a black box.

A direct link back to the listing, so any row can be verified against the source in one click.

Which map the row came from — Google Maps or Bing Maps — so a merged export stays auditable.

The timestamp the row was extracted, which is what turns a static list into something you can measure change against.