The Comma Seperated Values (CSV) File Format

• Each record is one line
• Fields are seperated with commas.
  Example John,Smith,123 Oak St.,Topeka,KS,66604 (Do not use special characters such as % as this may keep your file from uploading)
• Spaces at the beginning or end of a field are ignored.
  So John , Smith , is equal to "John" and "Smith". Space characters can be spaces or tabs.
• Fields with embedded commas must be enclosed with double-quote characters.
  For example: Tom's Cars, Trucks and Vans would have to be "Tom's Cars, Trucks and Vans" because it has an embedded comma.
• Do not put double-quotes around numeric-only fields.
  Information enclosed in double-quotes is read as a text field instead of a numeric field, and will cause your file to err out. "123 Oak Street" is ok, "66604" is not.
• Do not include header records containing column (field) names in the file.

To Save Your Spreadsheet as a CSV:

• Click FILE
• Choose SAVE AS
• In the FILE TYPE drop-down box, select CSV (may also say COMMA SEPERATED or COMMA DELIMITED)
• Click the SAVE button

Back to the Upload information page.