How many columns are in the file?

14, in a fixed order that does not change between orders.

Which fields can be empty?

Address components and some listing metadata. Business name and verified email are never empty in a delivered row.

Can I get the file in another format?

CSV is what we deliver. It imports into every CRM and spreadsheet we know of without conversion.

Data dictionary

The exact shape of a delivered file — 14 columns, in this order, with the empty cases named rather than discovered during your import.

Columns

Column	What it contains	Empty?
`business_name`	The business name as it appears on its public listing.	Always present
`category`	The listing's own category label, not our normalisation of it.	Can be empty
`email`	The verified contact address. Confirmed deliverable by the receiving mail server.	Always present
`email_status`	The verification verdict that cleared the address for delivery.	Always present
`phone`	Public contact number as listed.	Can be empty
`website`	The business's own website — the page the email address was found on.	Can be empty
`address`	Full street address as listed.	Can be empty
`city`	City. Recovered from the full address when the listing omits it.	Can be empty
`state`	State, province or region. Recovered from the address where possible.	Can be empty
`zip`	Postal code. Recovered from the address where possible.	Can be empty
`rating`	Google star rating at build time. A snapshot, not a live figure.	Can be empty
`reviews`	Google review count at build time — the number your review filter was applied to.	Can be empty
`google_maps_url`	Link to the original listing, so any row can be checked against its source.	Can be empty
`place_id`	Google's identifier for the listing. Stable enough to deduplicate against a later order.	Can be empty

Why a cell can be empty

Listings are inconsistent, and we would rather hand you a blank than a guess. City, state and ZIP are the usual gaps: when a listing omits them we recover what we can from the full address string, and leave the rest empty.

Two fields are never empty in a delivered row: business_name and email. A row without a verified address is not a delivered row.

Notes on specific fields

email_status: The verification verdict that cleared the address for delivery. Present on every row, because every row cleared one.
place_id: Google's identifier for the listing. Stable enough to deduplicate against a later order, which is the reason it is included.
reviews and rating: As read at build time. Both move; treat them as a snapshot with the date of your order, not a live figure.
category: The listing's own category label, not our normalisation of it. Approximate matching means it will not always equal the term you searched.

Delivery format

One CSV, UTF-8, comma-separated, CRLF line endings, quoted where a value contains a comma or a quote. Column order is fixed and matches the table above, so an import mapping built once keeps working.

Questions

How many columns are in the file?: 14, in a fixed order that does not change between orders.
Which fields can be empty?: Address components and some listing metadata. Business name and verified email are never empty in a delivered row.
Can I get the file in another format?: CSV is what we deliver. It imports into every CRM and spreadsheet we know of without conversion.

Build a list

Choose your categories and cities, set the review bar, and the price updates as you go. Orders start at 100 leads for $9.

Build a list →

Last reviewed 2026-08-02. Observations on this page are dated; when one stops being true we change the page.