Office 365 Set language and time zone for all users with PowerShell (Manual)
When you create a new Office 365 tenant, all user mailboxes will have the default timezone and language. In my case, I work in the Netherlands, the preference for most companies is to set the Time zone to Central European Time (GMT +1) and the language of the users default folders to Dutch.

You can either ask the users to logon to webmail using https://outlook.office.com and fill in the first time question to set the time zone and default language. But how cool would it be to do this for all your users using PowerShell?

PowerShell script
Step 1: First we will need to connect to Exchange Online, so run the following script and login with an account with Exchange permissions
$Credential = Get-Credential $Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ -Credential $Credential -Authentication Basic -AllowRedirection Import-PSSession $Session
Step 2: Get the language code from the list below
Language code | Display Name |
---|---|
af-ZA | Afrikaans – South Africa |
sq-AL | Albanian – Albania |
ar-DZ | Arabic – Algeria |
ar-BH | Arabic – Bahrain |
ar-EG | Arabic – Egypt |
ar-IQ | Arabic – Iraq |
ar-JO | Arabic – Jordan |
ar-KW | Arabic – Kuwait |
ar-LB | Arabic – Lebanon |
ar-LY | Arabic – Libya |
ar-MA | Arabic – Morocco |
ar-OM | Arabic – Oman |
ar-QA | Arabic – Qatar |
ar-SA | Arabic – Saudi Arabia |
ar-SY | Arabic – Syria |
ar-TN | Arabic – Tunisia |
ar-AE | Arabic – United Arab Emirates |
ar-YE | Arabic – Yemen |
hy-AM | Armenian – Armenia |
Cy-az-AZ | Azeri (Cyrillic) – Azerbaijan |
Lt-az-AZ | Azeri (Latin) – Azerbaijan |
eu-ES | Basque – Basque |
be-BY | Belarusian – Belarus |
bg-BG | Bulgarian – Bulgaria |
ca-ES | Catalan – Catalan |
zh-CN | Chinese – China |
zh-HK | Chinese – Hong Kong SAR |
zh-MO | Chinese – Macau SAR |
zh-SG | Chinese – Singapore |
zh-TW | Chinese – Taiwan |
zh-CHS | Chinese (Simplified) |
zh-CHT | Chinese (Traditional) |
hr-HR | Croatian – Croatia |
cs-CZ | Czech – Czech Republic |
da-DK | Danish – Denmark |
div-MV | Dhivehi – Maldives |
nl-BE | Dutch – Belgium |
nl-NL | Dutch – The Netherlands |
en-AU | English – Australia |
en-BZ | English – Belize |
en-CA | English – Canada |
en-CB | English – Caribbean |
en-IE | English – Ireland |
en-JM | English – Jamaica |
en-NZ | English – New Zealand |
en-PH | English – Philippines |
en-ZA | English – South Africa |
en-TT | English – Trinidad and Tobago |
en-GB | English – United Kingdom |
en-US | English – United States |
en-ZW | English – Zimbabwe |
et-EE | Estonian – Estonia |
fo-FO | Faroese – Faroe Islands |
fa-IR | Farsi – Iran |
fi-FI | Finnish – Finland |
fr-BE | French – Belgium |
fr-CA | French – Canada |
fr-FR | French – France |
fr-LU | French – Luxembourg |
fr-MC | French – Monaco |
fr-CH | French – Switzerland |
gl-ES | Galician – Galician |
ka-GE | Georgian – Georgia |
de-AT | German – Austria |
de-DE | German – Germany |
de-LI | German – Liechtenstein |
de-LU | German – Luxembourg |
de-CH | German – Switzerland |
el-GR | Greek – Greece |
gu-IN | Gujarati – India |
he-IL | Hebrew – Israel |
hi-IN | Hindi – India |
hu-HU | Hungarian – Hungary |
is-IS | Icelandic – Iceland |
id-ID | Indonesian – Indonesia |
it-IT | Italian – Italy |
it-CH | Italian – Switzerland |
ja-JP | Japanese – Japan |
kn-IN | Kannada – India |
kk-KZ | Kazakh – Kazakhstan |
kok-IN | Konkani – India |
ko-KR | Korean – Korea |
ky-KZ | Kyrgyz – Kazakhstan |
lv-LV | Latvian – Latvia |
lt-LT | Lithuanian – Lithuania |
mk-MK | Macedonian (FYROM) |
ms-BN | Malay – Brunei |
ms-MY | Malay – Malaysia |
mr-IN | Marathi – India |
mn-MN | Mongolian – Mongolia |
nb-NO | Norwegian (Bokmål) – Norway |
nn-NO | Norwegian (Nynorsk) – Norway |
pl-PL | Polish – Poland |
pt-BR | Portuguese – Brazil |
pt-PT | Portuguese – Portugal |
pa-IN | Punjabi – India |
ro-RO | Romanian – Romania |
ru-RU | Russian – Russia |
sa-IN | Sanskrit – India |
Cy-sr-SP | Serbian (Cyrillic) – Serbia |
Lt-sr-SP | Serbian (Latin) – Serbia |
sk-SK | Slovak – Slovakia |
sl-SI | Slovenian – Slovenia |
es-AR | Spanish – Argentina |
es-BO | Spanish – Bolivia |
es-CL | Spanish – Chile |
es-CO | Spanish – Colombia |
es-CR | Spanish – Costa Rica |
es-DO | Spanish – Dominican Republic |
es-EC | Spanish – Ecuador |
es-SV | Spanish – El Salvador |
es-GT | Spanish – Guatemala |
es-HN | Spanish – Honduras |
es-MX | Spanish – Mexico |
es-NI | Spanish – Nicaragua |
es-PA | Spanish – Panama |
es-PY | Spanish – Paraguay |
es-PE | Spanish – Peru |
es-PR | Spanish – Puerto Rico |
es-ES | Spanish – Spain |
es-UY | Spanish – Uruguay |
es-VE | Spanish – Venezuela |
sw-KE | Swahili – Kenya |
sv-FI | Swedish – Finland |
sv-SE | Swedish – Sweden |
syr-SY | Syriac – Syria |
ta-IN | Tamil – India |
tt-RU | Tatar – Russia |
te-IN | Telugu – India |
th-TH | Thai – Thailand |
tr-TR | Turkish – Turkey |
uk-UA | Ukrainian – Ukraine |
ur-PK | Urdu – Pakistan |
Cy-uz-UZ | Uzbek (Cyrillic) – Uzbekistan |
Lt-uz-UZ | Uzbek (Latin) – Uzbekistan |
vi-VN | Vietnamese – Vietnam |
Step 3: Now select your time zone from the list below:
Name of Time Zone | Time |
Dateline Standard Time | (GMT-12:00) International Date Line West |
Samoa Standard Time | (GMT-11:00) Midway Island, Samoa |
Hawaiian Standard Time | (GMT-10:00) Hawaii |
Alaskan Standard Time | (GMT-09:00) Alaska |
Pacific Standard Time | (GMT-08:00) Pacific Time (US and Canada); Tijuana |
Mountain Standard Time | (GMT-07:00) Mountain Time (US and Canada) |
Mexico Standard Time 2 | (GMT-07:00) Chihuahua, La Paz, Mazatlan |
U.S. Mountain Standard Time | (GMT-07:00) Arizona |
Central Standard Time | (GMT-06:00) Central Time (US and Canada |
Canada Central Standard Time | (GMT-06:00) Saskatchewan |
Mexico Standard Time | (GMT-06:00) Guadalajara, Mexico City, Monterrey |
Central America Standard Time | (GMT-06:00) Central America |
Eastern Standard Time | (GMT-05:00) Eastern Time (US and Canada) |
U.S. Eastern Standard Time | (GMT-05:00) Indiana (East) |
S.A. Pacific Standard Time | (GMT-05:00) Bogota, Lima, Quito |
Atlantic Standard Time | (GMT-04:00) Atlantic Time (Canada) |
S.A. Western Standard Time | (GMT-04:00) Caracas, La Paz |
Pacific S.A. Standard Time | (GMT-04:00) Santiago |
Newfoundland and Labrador Standard Time | (GMT-03:30) Newfoundland and Labrador |
E. South America Standard Time | (GMT-03:00) Brasilia |
S.A. Eastern Standard Time | (GMT-03:00) Buenos Aires, Georgetown |
Greenland Standard Time | (GMT-03:00) Greenland |
Mid-Atlantic Standard Time | (GMT-02:00) Mid-Atlantic |
Azores Standard Time | (GMT-01:00) Azores |
Cape Verde Standard Time | (GMT-01:00) Cape Verde Islands |
GMT Standard Time | (GMT) Greenwich Mean Time: Dublin, Edinburgh, Lisbon, London |
Greenwich Standard Time | (GMT) Casablanca, Monrovia |
Central Europe Standard Time | (GMT+01:00) Belgrade, Bratislava, Budapest, Ljubljana, Prague |
Central European Standard Time | (GMT+01:00) Sarajevo, Skopje, Warsaw, Zagreb |
Romance Standard Time | (GMT+01:00) Brussels, Copenhagen, Madrid, Paris |
W. Europe Standard Time | (GMT+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna |
W. Central Africa Standard Time | (GMT+01:00) West Central Africa |
E. Europe Standard Time | (GMT+02:00) Bucharest |
Egypt Standard Time | (GMT+02:00) Cairo |
FLE Standard Time | (GMT+02:00) Helsinki, Kiev, Riga, Sofia, Tallinn, Vilnius |
GTB Standard Time | (GMT+02:00) Athens, Istanbul, Minsk |
Israel Standard Time | (GMT+02:00) Jerusalem |
South Africa Standard Time | (GMT+02:00) Harare, Pretoria |
Russian Standard Time | (GMT+03:00) Moscow, St. Petersburg, Volgograd |
Arab Standard Time | (GMT+03:00) Kuwait, Riyadh |
E. Africa Standard Time | (GMT+03:00) Nairobi |
Arabic Standard Time | (GMT+03:00) Baghdad |
Iran Standard Time | (GMT+03:30) Tehran |
Arabian Standard Time | (GMT+04:00) Abu Dhabi, Muscat |
Caucasus Standard Time | (GMT+04:00) Baku, Tbilisi, Yerevan |
Transitional Islamic State of Afghanistan Standard Time | (GMT+04:30) Kabul |
Ekaterinburg Standard Time | (GMT+05:00) Ekaterinburg |
West Asia Standard Time | (GMT+05:00) Islamabad, Karachi, Tashkent |
India Standard Time | (GMT+05:30) Chennai, Kolkata, Mumbai, New Delhi |
Nepal Standard Time | (GMT+05:45) Kathmandu |
Central Asia Standard Time | (GMT+06:00) Astana, Dhaka |
Sri Lanka Standard Time | (GMT+06:00) Sri Jayawardenepura |
N. Central Asia Standard Time | (GMT+06:00) Almaty, Novosibirsk |
Myanmar Standard Time | (GMT+06:30) Yangon Rangoon |
S.E. Asia Standard Time | (GMT+07:00) Bangkok, Hanoi, Jakarta |
North Asia Standard Time | (GMT+07:00) Krasnoyarsk |
China Standard Time | (GMT+08:00) Beijing, Chongqing, Hong Kong SAR, Urumqi |
Singapore Standard Time | (GMT+08:00) Kuala Lumpur, Singapore |
Taipei Standard Time | (GMT+08:00) Taipei |
W. Australia Standard Time | (GMT+08:00) Perth |
North Asia East Standard Time | (GMT+08:00) Irkutsk, Ulaanbaatar |
Korea Standard Time | (GMT+09:00) Seoul |
Tokyo Standard Time | (GMT+09:00) Osaka, Sapporo, Tokyo |
Yakutsk Standard Time | (GMT+09:00) Yakutsk |
A.U.S. Central Standard Time | (GMT+09:30) Darwin |
Cen. Australia Standard Time | (GMT+09:30) Adelaide |
A.U.S. Eastern Standard Time | (GMT+10:00) Canberra, Melbourne, Sydney |
E. Australia Standard Time | (GMT+10:00) Brisbane |
Tasmania Standard Time | (GMT+10:00) Hobart |
Vladivostok Standard Time | (GMT+10:00) Vladivostok |
West Pacific Standard Time | (GMT+10:00) Guam, Port Moresby |
Central Pacific Standard Time | (GMT+11:00) Magadan, Solomon Islands, New Caledonia |
Fiji Islands Standard Time | (GMT+12:00) Fiji Islands, Kamchatka, Marshall Islands |
New Zealand Standard Time | (GMT+12:00) Auckland, Wellington |
Tonga Standard Time | (GMT+13:00) Nuku’alofa |
Step 4: Now its time to run the final script. Make sure you change the values. In the example below I am using the Dutch Language and the Western European Time Zone.
Get-mailbox -ResultSize unlimited | Set-MailboxRegionalConfiguration -Language nl-nl -TimeZone "W. Europe Standard Time" -LocalizeDefaultFolderName
BONUS:
If you want to run the script on certain mailboxes only, you could create a CSV with one collumn: PrimarySmtpAddress
$user = import-csv c:\userlist.csv foreach ($user in $user){ Set-MailboxRegionalConfiguration -Identity $user.PrimarySmtpAddress -LocalizeDefaultFolderName: $true -Language nl-NL -DateFormat dd-MM-yy }
More information on this command can be found on Microsoft docs: https://docs.microsoft.com/en-us/powershell/module/exchange/client-access/set-mailboxregionalconfiguration?view=exchange-ps
Common solution to this problem, but it would be even nicer to have a default setting for your organization, so you don’t have to set this every time you create a new user.