This article describes how to import users from a CSV file.
- Import users from CSV file
- Log into the Admin Console.
- In the Admin Console, go to Directory > People.
- Click More Actions, and then choose Import Users From CSV.
- In the Import Users from CSV window, click on this template link to download a template CSV file.
-
The template includes headers for all of the attributes defined in the current Okta user profile.
-
Complete the attribute fields (login, firstName, lastName, and email), which are mandatory.
-
NOTE: Do not delete the first-row header. Subsequent rows must contain one user per row, and all mandatory information must be entered in the corresponding columns. There is no need to enclose entries in quotations. Do not leave columns empty unless the same column is left empty for all rows, and they are not mandatory attributes. The entries: and,"", are identical and are treated as empty strings.
-
-
Click Upload CSV.
-
A validation process is run to ensure that the file is formatted correctly.
-
Correct any errors or note the success message, and then click Next.
-
In the Import Users from CSV window, choose 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 are not sent activation emails or prompted to set up an Okta password. This is recommended only for users who will authenticate through an external Identity Provider.
-
NOTE: To edit the option, Do not create a password and only allow login via Identity Provider; make sure Automatically activate new users has been enabled.
-
-
-
Click Import Users.
-
NOTE: 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.
-
