What is in an export file

The columns in the CSV, how multiple emails and phones appear, and the safety measures in the file.

ReferenceChecked 2026-10-10

An export is a plain CSV file you can open in Excel, Numbers or Google Sheets. The first row names the columns.

The columns

Column	Group	What it holds
name	Business	The business name
category	Business	The sector
trading_postcode	Business	Its trading postcode
full_address	Business	Its full address
phone	Contact	The main number
other_phones	Contact	Every other number we hold, separated by a semicolon
email	Contact	The main email
other_emails	Contact	Every other email we hold, separated by a semicolon
website	Contact	The website
company_number	Company	The registration number
company_status	Company	For example active
sic_codes	Company	The industry codes
facebook, instagram, linkedin	Socials	The profile links
revealed_at	Always	When you revealed the record
export_id	Always	A reference for this export, such as exp_20261010101500
exported_by	Always	A reference for your account

Only the groups you chose appear, in that order, with the last three always at the end.

A business with several emails or numbers is still one row. The extras are in the other_emails and other_phones columns.

The rows come newest reveal first, or in the order of the list you chose.

Whether an email is Verified or Catch-all. Labels are on screen, not in the file.
Where a fact came from.
Anyone on your own suppression list is not removed. See Suppression and do-not-contact on lists and searches.
A business that is not revealed.

A value that starts with =, +, - or @ has a quote put in front of it, so a spreadsheet cannot run it as a formula.
export_id and exported_by trace a copy of the file to its source. They cannot be switched off.

adaptleads-exp_ followed by the date and time, ending .csv.