Properly formatted files are essential for accurate data processing and verification. This page provides detailed instructions on formatting your CSV or TXT files, including examples, recognized header values, and general guidelines.

Guidelines

Following the guidelines below ensures the efficient handling of your data:

Delimiter: The file should use a comma (",") or pipe ("|") delimiter for .csv files. For .txt files, use a tab delimiter.
Column Specification: If your file includes more than one email column, specify the column to be processed using the email_column parameter.
File Compression: To speed up the transfer of large files, compress the file using zip. Ensure the .zip file contains only a single input file.
Header Line: Include a header line in the first row. This helps in denoting the field data. Make sure your header values match one of the recognized values below for proper processing:

Field	Recognized Header Values
First Name	`First name`, `first`, `fname`
Last Name	`Last name`, `last`, `lname`, `surname`
Full Name	`Full name`
Street	`Street`, `address`, `address 1`
Street 2	`Street 2`, `address 2`
City	`City`, `town`
State	`State`, `region`, `province`
Zip	`Zip`, `postal code`, `plus4`
Country	`Country`
Email	`Email`
MD5	Hash of a lower-case email address
SHA1	Hash of a lower-case email address

📘
Uploaded lists should use either UTF-8 or ISO 8859-1 character sets.

Example File

The following code block exemplifies well-formatted CSV and TXT files:

Email,First,Last,Address,City,State,Zip
emaila@example.com,John,Doe,100 Main St Apt 12B,Springfield,MA,01020
emailb@example.com,Mary,Smith,22 Clark Ave,Denton,TX,75065
emailc@example.com,Greg,Flynn,16 Park Ave,New York,NY,10016

Email    First    Last    Address                  City         State    Zip
emaila@example.com    John    Doe    100 Main St Apt 12B    Springfield    MA    01020
emailb@example.com    Mary    Smith    22 Clark Ave    Denton    TX    75065
emailc@example.com    Greg    Flynn    16 Park Ave    New York    NY    10016