Import Applicants Data

The second way of adding Applicants is by importing them via CSV or Excel. Down below are two downloadable files. Please click on them to download the respective file.

• Download CSV Template
• Download XLSX Template

Once you open the file, you will see 2 rows. Row 1 contains all the headers necessary for the importation to work correctly.
On the second row you will see an example applicant. Please use this as a guide for all your other applicants.

You may delete any column if you do not wish to import that specific information.

If you wish to add a field, please view the table below for all acceptable column names.

Field	Acceptable Column Names
First/Middle Name	givenname firstname
Last Name	familyname lastname
Title	title
Rank	rank
Address Line 1	agencystreet1 address1
Address Line 2	agencystreet2 address2
City	agencycity city
State	agencystate state province
Zipcode	agencyzipcode zipcode postalcode
Country	agencycountry country
Issue Date	issuedate issueddate
Expiration Date	expirationdate
Hire Date	employmentdate
Date of Birth	dob birthdate
Height	height
Weight	weight
Eye Color	eye eyecolor eyescolor
Hair Color	hair haircolor
Sex	gender sex
Badge No.	id idnumber badgenumber badgeid
Helpline	helpline helplinenumber
Department	jurisdiction division jurisdictiondivision
Supervisor Name	supervisor supervisorname
Supervisor Title	supervisortitle
Additional Date Field 1	datefield1
Additional Date Field 2	datefield2
Additional Date Field 3	datefield3
Additional Text Field 1	textfield1
Additional Text Field 2	textfield2
Additional Text Field 3	textfield3

Certain Fields require specific information or it will not be imported. Down below is another table with all the fields and there specific information.

Field	Values Allowed
Country	United States USA United States United States of America Canada Can Canada
State	United States AL AK AR AZ CA CO CT DC DE FL GA HI IA ID IL IN KS KY LA MA MD ME MI MN MO MS MT NC ND NE NH NJ NM NV NY OK OH OR PA RI SC SD TN TX UT VA VT WA WI WV WY
Province	Canada AB BC MB NB NL NS ON PE QC SK YT NU NT
Eye	Black Blue Brown Gray Green Hazel Maroon Pink Dichromatic Unknown
Hair	Bald Black Blonde Brown Gray RedAuburn Sandy White Unknown
Sex	Unknown Male Female NotSpecified

As you finish inputting all your applicant's information, please save the file and go back to the GETIDPaaS Website.

Please click on Enter Data from the main page. Then on the left Navigation, click on the Tab "Import Applicant Data"

Another drop-down list like on the Enter Applicant Data will appear. All your current IDs will be there. Please select one of your ID's. A button/upload link will then appear. There you can either select the file from your file explorer or drag and drop it there. Your applicants will then begin to be imported.

After your applicants are imported, a summary sheet will be displayed on your screen. If the importer ran into any issues, it would display them here along with the row that had the issue. You may also download the summary sheet by clicking the "Export Summary to Excel" button to reference at any time.