If you have an Office 365 tenant which is not in your preferred language you can easily update the language settings by using Windows PowerShell. In this blogpost I will explain how you can localize your Office 365 Tenant.
When I give a session at a client and need to give a demo, I always use an Office 365 demo tenant. I use http://www.microsoftofficedemos.com/ to create a demo tenant, this will give you 25 Enterprise E5 licenses for 90 days. You can customize some things, except the language of the tenant. I wanted to localize my tenant, which by default gets provisioned in English. How do we do this easily and with least effort for future demo tenants? Ofcourse, with Windows PowerShell.
Step 0: Connect to your Office 365 Tenant
First of all you need to connect to your Office 365 tenant. You can use my scripts for that as I have described here.
If you are connected to Azure Active Directory and Exchange Online you are ready to localize your Office 365 Tenant.
Step 1: Office 365 General
Choose the script that is applicable to your situation.
If you are in a scenario like me, you can use the following script to update the preferred language of all your users:
Local Active Directory
If you are using Azure Active Directory Sync (AADSync) you need to update the PreferredLanguage attribute in your local Active Directory. The following script will update the preferred language attribute for all the users in a given Organizational Unit (OU):
Above scripts will update most of the general language stuff in Office 365 like:
- Default landing page
- General settings and menu
- Management portal
- OneDrive for Business
- Groups (OneDrive for Business part)
- Video portal
- Office Online (Word Online, Excel Online, PowerPoint Online)
It will not update the Outlook related apps, this will be done in the next step.
Step 2: Exchange Online
This line of PowerShell will set the preferred language of all mailboxes in your tenant:
The following related Outlook apps will be shown in your preferred language:
- E-mail (Outlook Online)
Step 3: SharePoint Online
Now you have almost everything in your preferred language, except SharePoint Online. This is where Office 365 PnP PowerShell Cmdlets comes into play.
First connect to the Site Collection you want to update:
After that, you can run the following script. This will recursively update every subsite (Web) by setting it to a multilingual site and adding the language code for your preferred language. SharePoint Online will now be shown in your preferred language.
Hopefully this will help you to localize your Office 365 Tenant.
All scripts and other PowerShell references on this blog are offered “as is” with no warranty. While these scripts are tested and working in my environment, it is recommended that you test these scripts in a test environment before using in your production environment.