Header

  Close Menu

Excel saved as a .CSV (Comma Delimited)

The Department of Workforce Development will provide an Excel template that matches the following requirements. To upload an Excel file in the new system, please follow the below requirements and save the file as a .CSV. To do so, click File > Save as > then select File Type "CSV" (comma delimited).

CellsField NameCharacter LengthFormatDescription
A1-Q1Column Headings TextLabeled headings for each column, provided in DWD template.
A2-Q2Sample Row Text and NumbersSample display of formatted data for each column, provided in DWD template on this page.
A3-End of ARow Type1TextH=header, N=nothing to report, S=wage
B3-End of BReporting Period Quarter1NumberThe quarter to be filed. Ex: 1, 2, 3, or 4.
C3-End of CReporting Period Year4NumberThe four (4) digit year to be filed.
D3-End of DState Unemployment Tax Account Number6NumberSix (6) digit SUTA number. With or without dashes.
E3-End of EFederal Employer Identification Number9NumberNine (9) digit FEIN. With or without dashes.
F3-End of FSocial Security Number or Individual Taxpayer Identification Number9NumberEmployee's SSN. With or without dashes.
G3-End of GLast Name20Text and Special CharactersEmployees full last name. Dashes (-) and apostrophes (') allowed.
H3-End of HFirst Name20Text and Special CharactersEmployee's full first name. Dashes (-) and apostrophes (') allowed.
I3-End of IMiddle Initial1TextEmployee's middle initial.
J3-End of JStart Date10Number and Special CharactersEmployee's start date. Should be formatted with forward slashes. Ex: MM/DD/YYYY
K3-End of KStandard Occupational Classification Code6NumberEmployee's Standard Occupation Classification (SOC) code.
L3-End of LZip Code of Primary Work Location5NumberZip code of the primary location where the employee performed work.
M3-End of MFull Time/Part Time/Seasonal2Text and NumberEmployee's status as full time, part time, or seasonal. Full time and part time designated as FT and PT, respectively. Seasonal status designated with two (2) digit seasonal code.
N3-End of NGross Wages1Text and Special CharacterEmployee's gross wages. Denote cents with a period (.). No dollar sign or commas.
O3-End of OEmployed 12th day of Month One1TextIf employee worked during the pay period including the 12th day of the month, enter "Y." If not, enter "N."
P3-End of PEmployed 12th day of Month Two1TextIf employee worked during the pay period including the 12th day of the month, enter "Y." If not, enter "N."
Q3-End of QEmployed 12th day of Month Three1TextIf employee worked during the pay period including the 12th day of the month, enter "Y." If not, enter "N."

Updated ICESA .TXT File

The Department of Workforce Development will accept an updated ICESA space delimited .txt file. The new requirements are reflected below. In the new system, you will only be required to submit E and S records on the ICESA file.

E Record Format

 Field NameLocationLengthComments
E1Record Identifier1-11Value = E
E2Payment Year2-54Numeric CCYY
E3FEIN6-149Numeric
E4Fill15-239Spaces
E5Employer Name24-7350The Employer matching the FEIN and Indiana SUTA number in this E record
E6Employer Street Address74-11340
E7Employer City114-13825
E8Employer State139-1402
E9Fill141-1488
E10Zip Code Extension149-1535
E11Zip Code154-1585
E12-E17Fill159-17214Spaces
E18Indiana SUTA Number173-187156 Numeric + 1 Alpha or Space + 8 Spaces
E19Reporting Period188-1892Numeric 1Q=03, 2Q=06, 3Q=09, 4Q=12
E20Fill190-27586Spaces

S Record Format

 Field NameLocationCharacter LengthComments
S1Record Identifier1-11Value = S
S2Social Security Number OR Individual Taxpayer Identification Number2-109Numeric
S3Employee Last Name11-3020

Full Last Name
Accepts the following special characters: Dash (-), Apostrophe (')

S4Employee First Name31-4212

Full First Name
Accepts the following special characters: Dash (-), Apostrophe (')

S5Employee Middle Initial43-431Middle Initial or Space
S6State Code44-452Value = 18
S7Employee Start Date46-538Numeric MMDDYYYY
S8Zip Code of Primary Work Location54-585Numeric
S9Fill59-635Spaces
S10Gross Wages64-7714

Numeric
Can be zero
Leading zeros filled
Two (2) decimal positions implied

S11-S12Fill78-105280 filled. Other digits or spaces in the 28 characters will be ignored.
S13Standard Occupation Classification Code106-1116Numeric
S14-S18Fill112-14635Spaces
S19Indiana SUTA Number147-1526Six (6) digit numeric account number (can begin with 0)
S20-S22Fill153-20452Spaces. Other digits or spaces in the 52 characters will be ignored.
S23Full Time/Part Time/Seasonal205-2062

Full time designated FT
Part time designated PT
Seasonal must be two (2) digits and numeric

S24-S28Fill207-2115Spaces
S29Month 1 Employment2121If employee worked during period of 12th day of the month = Y. If not = N.
S30Month 2 Employment2131If employee worked during period of 12th day of the month = Y. If not = N.
S31Month 3 Employment2141If employee worked during period of 12th day of the month = Y. If not = N.
S32Reporting Quarter and Year215-2206Numeric 1Q=03, 2Q=06, 3Q=09, 4Q=12 + 4 digit year (YYYY)
S33Fill221-27555Spaces

Equal Opportunity is the Law. (La Igualdad De Oportunidad Es La Ley.)
Equal Opportunity Employer/Program Auxiliary aids and services are available upon request to individuals with disabilities.

DWD News

DWD News

View More News

Top FAQs