General Requirements:
 
• Must be a comma-separated values file (CSV)
• Must be encoded in UTF-8
• Actual file extension can be .csv or .txt (or compressed – see last bullet below)
• A maximum of 150 columns
• File name can be anything you like
• One student/contact per row: records should not appear more than once in the file
• The first row must contain column headers, as in the example given on the first page
[note: column order is not important, but your column headers need to remain consistent]
• If larger than 20mb, please compress file in .gzip format (do not pre-archive as .tar)

Multi-Value Fields

Your database may have certain field groups that account for double- or triple-values – for instance, you
might have separate fields for Major1, Major 2, Major 3, and so on. In these cases we recommend
merging these groups into a single column. To do this, simply set up your extract to concatenate
multiple values together into a single cell, delimited by a separator. Usually this separator is a pipe (|) but
you can also use a colon (:) or semicolon (;). Note: You must notify Support of the separator that you choose to use. 

Here is an example of how this comes out in the CSV:

UID, email, FirstName, LastName, Major, GPA
MT123,mt123@college.edu,Matthew,Thomas,Engineering|Biology,3.5

Date Fields
Our default date format is: MM/DD/YYY
However, if desired we can switch the default pattern to any of the following. You must notify Support if you
want to use one of these alternate patterns: MM/DD/YYYY, MM-DD-YYYY, DD/MM/YYYY, DDMM/
YYYY, YYYY/MM/DD, YYYY/DD/MM

Alternative Delimiters
By definition a CSV is a comma-separated value file. If this is a problem for any reason, you can specify
an alternative delimiter – your other options are a pipe ( | ), a colon ( : ), or a semicolon ( ; ). You must
notify us
if you intend to use an alternative delimiter.

Use Double Quotes to Avoid Common Errors with Quotes and Commas
Note: For complete details on formatting, we use this CSV spec for parsing your files.
  1. Cell value contains a comma:
Consider the value for this student's last name and suffix - this is a single value, but it will be parsed incorrectly because the comma is understood as a cell delimiter:

FirstName,LastName,Major,GPA,Street,City,State
Matthew,Thomas, Jr.,Mechanical Engineering,3.8

We can solve this by changing the file to a double-quotes CSV. The corrected version:

FirstName,LastName,Major,GPA,Street,City,State
"Matthew","Thomas, Jr.","Mechanical Engineering","3.8"
  1. Cell value contains double quotes
A different error can arise when your cell values themselves contain double quotes, like so:

FirstName,LastName,Street,City,State
"Matthew","Thomas Jr.","1609 Shoal Creek Apt. "D"","Austin","TX"

Normally a pair of quotes delimits a whole cell's value, but not here, thus the error. This gets fixed by either escaping the double quotes with more double quotes, or simply dis-allowing double quotes and converting them to apostrophes:

Escaping with another pair of double quotes:

"Matthew","Thomas, Jr.","1609 Shoal Creek Apt. ""D""","Austin","TX"

Or, converting to apostrophes:

"Matthew","Thomas, Jr.","1609 Shoal Creek Apt. 'D'","Austin","TX"

For additional assistance please call Support.