GUIDE FOR CREATING THE SCHEDULE D .CSV FILE 

 STEP 1: Add data to fields following max field lengths and format. DO NOT include header records containing column (field) names in the file.

STEP 2: Save as .csv file (file name should be ScheduleD.csv without any spaces)

STEP 3: Follow steps to upload and import file

Excel Template | Example

Field Name Example Length Description
Unique Number 1 - first column must contain the line number
First_Name John 50 required
Last_Name Doe 50 required
Address_Number 3334 6 required
Sub_Number 1/2 or A 3  
Prefix_Direction E 3 must be E, S, SE, SW, N, NE, NW, W
Street_Name CEDAR 30 required
Suffix_Direction W 10 must be E,S,N,W,SE,SW,NE,NW,
Street_Type AVE 4 examples AVE, BLVD, CIR, CT, DR, HWY, LN, PK, PKY, PL, PLZ, RD, SQ, ST, TER, TFW, TRL, WAY
Unit_Number 300 4  
City Topeka 20 required
Zip1 66633 5 required
Zip2 1114 4  
Nature_of_account loan 100 required
Amount 44.99 - required, must have two digits to the right of the decimal
Date 2/9/2008 - required
PAC_Name John's PAC 100 required if no first name, last name, or Business Name entered
Other PO Box 332 100 required if no Address No. or Street Name entered
State KS 2 required, must be two-letter state abbreviation
Unit_Type STE 10 must be APT, BSMT, BLDG, CONDO, DEPT, FLOOR, FRNT, HNGR, KEY, LBBY, LOT, LOWR, OFC, PH, PIER, REAR, RM, SIDE, SLIP, SPC, STOP, STE, TRLR, UNIT, UPPR
Business_Name Signs R Us 50 required if no first name, last name, or PAC Name entered

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