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, not CSV - UTF 8 (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 Kansas Public Disclosure Commission Home at (785) 296-4219.
click here to close this window