File Format Specifications

In order to ensure that the best-possible output is achieved, it is critical that the input file be received in the proper format.

Please note that following our file format specifications is required only for our Self-Service clients. For those using our Full-Service, Automated and Enterprise services, please know that proper formatting will be confirmed and/or implemented by our expert Data Specialists.

Input File Format

Cleanlist's automated list processing systems require you to submit data in the following format. If you are unable to submit your data in this format, please consider upgrading to our Custom Projects delivery option and our data specialists will convert your file for you before processing.

Submitted files must be compressed in ZIP format. Please include only one file per order.

File Types

  • Fixed Length ASCII Text
  • Tab, Pipe or Comma Delimited ASCII Text
  • If commas are used, field values must be enclosed in quotes.

Encoding

  • WIN-1252 (Windows)
  • CP-437 (DOS)
  • Lines are terminated with either CRLF or LF

Input Fields

All of the fields below must be allocated in the input file, although naturally some values may be blank. In the case of fixed-length files, the field lengths should all correspond to the maximums below.

Field Type
Length
Description
Examples
Your ID#
Max 20
Your unique customer ID (optional)
0001023

Full Name
Max 60
Contact first and last name, optionally including title or initials
Mr. Ben Smith
Barbara S. James

Company Name
Max 60
Company name (optional)
Ben's Auto Body

Address 1
Max 60
First address line
246 Queen St

Address 2
Max 60
Second address line (optional)
Suite 401

City
Max 45
City
Southfield

State
Max 20
State or province code
MI

Zip
Max 15
Zip or postal code
48034

Phone Number
Max 15
Phone number (optional)
313-555-1234

Output File Format

Your output file and service reports will be bundled together and delivered in ZIP format.

Your updated contact list will contain your input data (unchanged) with replacement data appended into new columns to the right. The fields appended vary depending on the services you order and are described in the File Layout portion of your report, which is provided with each completed order. Refer to individual service descriptions in the Solutions section of this web site for a detailed description of the fields provided.

Output files are delivered in the same format as they were submitted to Cleanlist.

Questions?
Need a quote?
Call: 1-800-454-0223
Quick Contact Form:




The following trademarks are owned by the United States Postal Service®: CASS, CASS Certified, DMM, DPV, DSF2, eLOT, First-Class Mail, LACSLink, NCOALink, PAVE, Post Office, Postal Service, Standard Mail, U.S. Postal Service, United States Post Office, United States Postal Service, USPS, ZIP, ZIP Code, and ZIP + 4.

DSF2 processing is provided by a nonexclusive licensee of the United States Postal Service. The prices for NCOALink and DPV services are not established, controlled, or approved by the United States Postal Service.


Don't just listen to us. Here's what the Pros are saying about Cleanlist.
I especially appreciate when you are able to accommodate our last minute requests as I know you will always come through for us.
University of Toronto
Time and again, your team demonstrated great flexibility under rigid turnaround schedules without compromising the integrity of the data.
Experian Information Solutions
I have complete confidence in knowing that you will go the extra mile to solve the many technological problems that we stumble across during a project.
TD Bank Financial Group
Cleanlist is trusted by these companies