The Comma Seperated Values (CSV) File Format
- Each record is one line.
- Fields are separated 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.