Update Country Code for Active Directory Users
In this article, I’ll show you how to bulk update the Country Code attribute for users in Active Directory.
When you change the Country/region settings for a user account in Active Directory it will actually update three attributes.
-
c = (Country/Region Name – ISO 3166 Alpha-2 Code)
- Two-letter country code
- Example: US
-
co = (Country/Region Display Name)
- Full country name (human-readable)
- Example: United States
-
countryCode = (Numeric Country Code – ISO 3166 Numeric)
- Integer based on ISO 3166-1 numeric codes
- Example: 804 = United States
To bulk update the countryCode requires setting these three attributes for each user.
How to Bulk Update CountryCode for AD Users
Section titled “How to Bulk Update CountryCode for AD Users”Step 1. Get your country code values from the table below.
Step 2. Open the “Update Users” tool and download the provided CSV template. These attributes are already included in the template, you will need to add the users and values to be updated.
In the csv example below, you can see I’m updating the country code for over 20 users at once. You must provide the c, co and countryCode value for each user.
Step 3. From the Update Users tool select your CSV file and click “Run”.
All done. That is how you bulk update the Country value in Active Directory.
To verify the country code attributes have updated run the all users report and include the c, co, and countrycode columns.
Country Codes List
Section titled “Country Codes List”If you don’t see your country in the list below then refer to the iso website.
| c | co | countryCode |
|---|---|---|
| US | United States | 840 |
| CA | Canada | 124 |
| GB | United Kingdom | 826 |
| AU | Australia | 036 |
| NZ | New Zealand | 554 |
| DE | Germany | 276 |
| FR | France | 250 |
| IT | Italy | 380 |
| ES | Spain | 724 |
| NL | Netherlands | 528 |
| BE | Belgium | 056 |
| SE | Sweden | 752 |
| NO | Norway | 578 |
| DK | Denmark | 208 |
| FI | Finland | 246 |
| IE | Ireland | 372 |
| CH | Switzerland | 756 |
| AT | Austria | 040 |
| PT | Portugal | 620 |
| PL | Poland | 616 |
| CZ | Czech Republic | 203 |
| SK | Slovakia | 703 |
| HU | Hungary | 348 |
| RO | Romania | 642 |
| BG | Bulgaria | 100 |
| GR | Greece | 300 |
| TR | Türkiye | 792 |
| IL | Israel | 376 |
| AE | United Arab Emirates | 784 |
| SA | Saudi Arabia | 682 |
| QA | Qatar | 634 |
| KW | Kuwait | 414 |
| BH | Bahrain | 048 |
| IN | India | 356 |
| CN | China | 156 |
| JP | Japan | 392 |
| KR | South Korea | 410 |
| SG | Singapore | 702 |
| HK | Hong Kong | 344 |
| TW | Taiwan | 158 |
| BR | Brazil | 076 |
| MX | Mexico | 484 |
| AR | Argentina | 032 |
| CL | Chile | 152 |
| CO | Colombia | 170 |
| ZA | South Africa | 710 |
| NG | Nigeria | 566 |
| KE | Kenya | 404 |
| EG | Egypt | 818 |