Mass Update User Language with Data Loader

To successfully update user language in bulk, use the correct LanguageLocaleKey values and follow the steps below.

Step 1: Export User Records

1. Use Data Loader or a report to export User records
2. Include:
   • Id
   • Optional identifying fields (e.g., Name, Username)

Step 2: Prepare the CSV File

1. Open the exported file
2. Add a new column:
   • Column Name: LanguageLocaleKey
3. Populate the column using API values (not UI labels)

Example:

Step 3: Use Correct Language API Values

Fully Supported Languages

• Chinese (Simplified): zh_CN
• Chinese (Traditional): zh_TW
• Danish: da
• Dutch: nl_NL
• English: en_US
• Finnish: fi
• French: fr
• German: de
• Italian: it
• Japanese: ja
• Korean: ko
• Norwegian: no
• Portuguese (Brazil): pt_BR
• Russian: ru
• Spanish: es
• Spanish (Mexico): es_MX
• Swedish: sv
• Thai: th

End-User Languages

• Arabic: ar
• Bulgarian: bg
• Croatian: hr
• Czech: cs
• English (UK): en_GB
• Greek: el
• Hebrew: iw
• Hungarian: hu
• Indonesian: in
• Polish: pl
• Portuguese (European): pt_PT
• Romanian: ro
• Slovak: sk
• Slovenian: sl
• Turkish: tr
• Ukrainian: uk
• Vietnamese: vi

Step 4: Update Users via Data Loader

1. Open Data Loader
2. Select Update
3. Choose the User object
4. Upload the prepared CSV file
5. Map fields:
   • Id → Id
   • LanguageLocaleKey → LanguageLocaleKey
6. Run the update

Best Practices

• Map only required fields (Id and LanguageLocaleKey) for faster processing
• Test with a small dataset before full update