During a bulk user import into Okta using a Comma-Separated Values (CSV) file, the import fails if the file uses semicolons instead of commas as delimiters. To resolve this issue, format the CSV file with comma-separated values and ensure all required attributes are present. The following errors occur during the import process:

Please review the CSV file and correct the following error(s):
Invalid attribute in CSV header: login;firstName;lastName;middleName;honorificPrefix;honorificSuffix;email;title;displayName;nickName;profileUrl;secondEmail;mobilePhone;primaryPhone;streetAddress;city;state;zipCode;countryCode;postalAddress;preferredLanguage;locale;timezone;userType;employeeNumber;costCenter;organization;division;department;managerId;manager
Missing required attribute from CSV header: lastName
Missing required attribute from CSV header: login
Missing required attribute from CSV header: email
Missing required attribute from CSV header: firstName

• Okta Identity Engine (OIE)
• Okta Classic Engine
• Comma-Separated Values (CSV) Import

The CSV file uses semicolons (;) as delimiters instead of commas (,) and Okta requires commas to parse the header attributes correctly.

Because Okta reads the entire semicolon-separated string as a single invalid attribute, it fails to detect the required individual attributes.

How is the CSV import error resolved?

To resolve CSV import errors, correct the delimiter format in the file, verify the required headers, and upload the file again using the following steps:

1. Open the CSV file in a text editor or spreadsheet application.
2. Replace all semicolons (;) with commas (,) to ensure the file is properly comma-delimited.
3. Verify that the four required headers are present and populated for all users: login, firstName, lastName, and email.
4. Save the changes to the CSV file.
5. Upload the corrected file to Okta.