Import users from a CSV file

You can add or update Okta users by uploading a CSV file of user information. This includes validation and error reporting of the imported data.

Here are some tips for working with the CSV template:

• Don't delete the first row of the template. This contains the headers for the attributes defined for the current Okta user profile.
• Subsequent rows must contain one user in each row with all mandatory information entered in the correct columns.
• You don't need to enclose entries in quotations.
• Don't leave columns empty unless the same column is left empty for all rows and they're not mandatory attributes.
• The characters ,, and ,"", are identical and are treated as empty strings.

1. In the Admin Console, go to DirectoryPeople.
2. Click More actions, and then select Import users from CSV.
3. Click Upload CSV. A validation process runs to make sure that the file is properly formatted.
4. Correct any errors or note the success message, and then click Next.
5. In the Import Users from CSV window, select one of the following:
   • Automatically activate new users: Newly imported users are automatically activated.
   • Do not create a password and only allow login via Identity Provider: Newly imported users aren't sent activation emails or prompted to set up an Okta password. This is only recommended for users who authenticate using an external Identity Provider.

   You must enable Automatically activate new users to edit the Do not create a password and only allow login via Identity Provider setting.

6. Click Import Users.

Okta validates that the CSV file is formatted correctly and that all attribute requirements are met. A summary lists the number of new users, uploaded users, unchanged users, and the number of users that incurred errors. If errors are found, click the Download link to view the error report.