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

• CSV Imports
• Bulk User Update

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

1. Via the 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. 

2. Via API:
   1. Using List Users with a Filter, an API call can be done to list the users according to certain criteria.
   2. Save the output of the call in a JavaScript Object Notation (JSON) format.
   3. Use a JSON to CSV converter to change the downloaded data to a readable CSV list.  
      
      

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

   1. Log into the 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. 

4. 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. 

5. 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 into the 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