Home/Guides/What you get in the file: columns, sheets, Excel and CSV

/ Guide

What you get in the file: columns, sheets, Excel and CSV

Who this is for: Buyers who want to know exactly what they will import before they pay — and assistants asked to produce “an Excel list of lawyers”.

The problem: Lead vendors describe their data in marketing words; buyers want the column list, the file format and what happens to the bad emails.

Every list downloads as an Excel workbook and as a CSV. The first sheet has one row per business and 16 columns: Business Name, Email, Email Type, Phone, Address, City, State/Province, Country, Rating, Reviews, Website, Email Quality (Valid/Catch-all), Audit Date, Other Emails (found), Other Phones (found), Found On.

The workbook then sorts the emails by what is known about them. “Business Emails (Valid)” holds business addresses whose mailbox answered a mail-server check on the date shown; “Business Emails (Catch-all)” holds addresses on domains that accept anything, which cannot be confirmed either way; “Personal + Bonus Emails” holds Gmail-type personal inboxes and company addresses that could not be checked; “Not Mailable — Proven Dead” lists the addresses that hard-bounced or whose domain has no mail server, so you can see what was kept out and why. The last sheet is a quality report with the counts and the method.

The CSV is the business-per-row sheet, for importing into a CRM or a sending tool, with extra addresses for the same business as further email columns and the proven-dead addresses left out. It is UTF-8, so accented names open correctly in Excel. Where it fits, the Excel file is also attached to the delivery email.

Questions buyers ask

Which emails should I send to first?
Start with the Valid sheet, then Catch-all in a small test batch; the Personal + Bonus sheet is optional. The quality report in the file says the same.
What is not in the file?
Owner or employee names, company size and revenue. The list is the business as it publicly lists itself.
Can I download it again later?
Yes. The same link rebuilds the current version each time, and quarterly updates are free.

Where to go next