The 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. Example: 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. 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 error out. "123 Oak Street" is OK.
- Do not include header records containing column (field) names in the file.

To Save Your Spreadsheet as a CSV:
1. Click FILE and Choose SAVE AS
2. In the FILE TYPE drop-down box, select CSV (may also say COMMA SEPERATED or COMMA DELIMITED)
3. Click the SAVE button

If you need further assistance with the online application, please contact our Elections Division at (785) 296-4561. If you need assistance completing the Campaign Finance forms, please contact the Governmental Ethics Commission at (785) 296-4219.

click here to close this window