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 and for those using our Custom Project, 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 contact our Support Department () to make arrangements for us to convert your file for you (fees apply).

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

Province
Max 20
Province code
BC

Postal Code
Max 15
Postal code
N5V 4J4

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.


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