This article details how to perform bulk Okta user profile updates via CSV Import.

• CSV Imports
• Bulk User Update
• Okta Classic Engine
• Okta Identity Engine (OIE)

Follow the steps below to perform a bulk Okta user profile update via CSV Import:

1. Retrieve an active list of users in the environment to perform the bulk updates against. Here are a few options to pull this information:

   • Via the Okta UI:

     1. Go to Okta Admin Console > Reports.
     2. Click the Okta Password Health link, as shown below, to download a CSV file.
     3. Open the CSV file and filter the Status column to show active users. 

1. • Via API:
     1. Using List Users with a Filter, an API call can be made to list users based on specific criteria.
     2. Save the output of the call in a JavaScript Object Notation (JSON) format.
     3. Use a JSON-to-CSV converter to convert the downloaded data into a readable CSV file.  
        
        

2. Download the template CSV file. NOTE: The template includes headers for all attributes defined in the current Okta user profile.

   1. Log in to the Okta Admin Console.
   2. In the Admin Console, go to Directory > People.
   3. Click More Actions, and then choose Import Users From CSV.
   4. In the Import Users from CSV window, click this template link to download a template CSV file.
   5. The template includes headers for all attributes defined in the current Okta user profile.
   6. Complete the Login attribute with all the users that need to be updated, then the attributes with the values that the user attributes should get updated with. 
      • NOTE: Do not delete the first-row header. Subsequent rows must contain one user in each row, and information must be entered in the correct columns. For the attributes that need to be updated, there is no need to enclose entries in quotations. 
        
        

3. Please fill in the user.login row and the rows that should be updated. The users added in the CSV file, and the values for the added attributes will be updated in Okta. The users or the attributes that are not added will not be updated. 

4. Once Admins validate that all user information has been updated and all active users are present in the CSV, please import the CSV file. 

   1. Log in to the Okta Admin Console.
   2. In the Admin Console, go to Directory > People.
   3. Click More Actions, and then choose Import Users From CSV.
   4. Browse the CSV created and click Upload CSV. If Okta is able to parse the CSV without issues, admins will receive the message "CSV file parsed successfully!" 
   5. If the intention is to update existing users, leave the following options unchecked: Automatically activate new users and Do not create a password and only allow login via Identity Provider.
   6. Once unchecked, select Import Users.
      

Related References

• Postman
• Test the Okta REST APIs using Postman
• List Users with a Filter 
• How to Export a List of Active Okta Users
• How to Import Users From a CSV File