• 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)
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
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
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.
- Cell value contains a comma:
Matthew,Thomas, Jr.,Mechanical Engineering,3.8
We can solve this by changing the file to a double-quotes CSV. The corrected version:
"Matthew","Thomas, Jr.","Mechanical Engineering","3.8"
- Cell value contains double quotes
"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.