Change the language of a form

%3CLINGO-SUB%20id%3D%22lingo-sub-78093%22%20slang%3D%22en-US%22%3EChange%20the%20language%20of%20a%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-78093%22%20slang%3D%22en-US%22%3E%3CP%3EAnyone%20know%20how%20to%20change%20the%20language%20of%20a%20form%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20it%20is%20not%20changing%20profile%20or%20local%20computer%20settings.%3C%2FP%3E%3CP%3EJust%20I%20have%20an%20international%20organisation%20who%20want%20to%20be%20able%20to%20send%20forms%20in%20different%20languages.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-78093%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-332445%22%20slang%3D%22en-US%22%3ERe%3A%20Change%20the%20language%20of%20a%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-332445%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Martin%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20actual%20question%20is%20how%20to%20combine%20forms%20results%20(especially%20with%20Quiz).%20Assume%20you%20have%20few%20hundred%20people%20answering%20the%20forms%2C%20let%20say%20few%20forms%20on%20different%20languages%20with%20exactly%20the%20same%20content%20and%20you%20need%20stats%20for%20all%20people%2C%20not%20for%20each%20language%20group%20separately.%20Plus%20data%20is%20constantly%20updated%2C%20like%20repeating%20test%20for%20employees%20and%20entry%20one%20for%20newcomers.%20Could%20be%20done%20through%20Excel%20files%2C%20but%20without%20Excel%20connector%20to%20results%20for%20Quiz%20it%20looks%20bit%20hard.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-321506%22%20slang%3D%22en-US%22%3ERe%3A%20Change%20the%20language%20of%20a%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-321506%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Philip%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20language%20of%20the%20questions%20written%20in%20your%20form%20are%20in%20the%20language%20you%20wrote%20them.%3C%2FP%3E%3CP%3ESo%20if%20you%20want%20a%20form%20to%20be%20available%20in%20multiple%20languages%2C%20you%20need%20to%20create%20multiple%20forms.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegarding%20the%20language%20of%20the%20form%20application%20(words%20like%20Mandatory%2C%20Send%2C%20...)%2C%20the%20words%20used%20are%20displayed%20in%20the%20language%20of%20the%20browser.%20See%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Flanguage-settings-for-microsoft-forms-b282f9aa-0fe4-4290-b1e1-827a8a35ac27%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Flanguage-settings-for-microsoft-forms-b282f9aa-0fe4-4290-b1e1-827a8a35ac27%3C%2FA%3E%20for%20additional%20details%20on%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20helps.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-135432%22%20slang%3D%22en-US%22%3ERe%3A%20Change%20the%20language%20of%20a%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-135432%22%20slang%3D%22en-US%22%3E%3CP%3ENo%20answer%206%20months%20later%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20am%20also%20interested%20in%20knowing%20how%20Forms%20handle%20multiple%20languages.%20Can%20we%20create%20a%20single%20form%20where%20text%20will%20be%20localized%20or%20we%20need%20to%20create%20multiple%20ones%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-982221%22%20slang%3D%22en-US%22%3ERe%3A%20Change%20the%20language%20of%20a%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-982221%22%20slang%3D%22en-US%22%3E%3CP%3EHi.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20sure%20if%20you%20still%20need%20a%20solution%20to%20this%2C%20but%20I've%20just%20done%20it%20myself.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20First%20of%20all%2C%20I%20created%20my%20form%20in%20English.%3C%2FP%3E%3CP%3E2.%20I%20then%20translated%20it%20into%20the%20other%20languages%20I%20required%20(I%20used%20Google%20Translate%20and%20then%20had%20humans%20quality%20check%20the%20translations).%3C%2FP%3E%3CP%3E3.%20I%20copied%20the%20form%20I'd%20created%20in%20English%20and%20replaced%20each%20piece%20of%20text%20with%20the%20translated%20text%20in%20the%20first%20language.%3C%2FP%3E%3CP%3E4.%20I%20clicked%20on%20the%20menu%20icon%20(the%20three%20dots%20in%20the%20top%20right%20hand%20corner)%20then%20'Multilingual'.%20I%20changed%20the%20primary%20language%20to%20the%20new%20language%20(e.g.%20from%20English%20to%20French).%3C%2FP%3E%3CP%3E5.%20I%20copied%20the%20URL%20for%20the%20translated%20form%20and%20added%20the%20language%20tag%20to%20the%20end%20of%20the%20URL%2C%20e.g.%20%26amp%3Blang%3Dfr%20for%20French%20or%20%26amp%3Blang%3Des%20for%20Spanish%2C%20etc.%20(You%20can%20find%20a%20list%20of%20language%20tags%20online).%3C%2FP%3E%3CP%3E6.%20I%20repeated%20these%20steps%20for%20each%20language%3C%2FP%3E%3CP%3E7.%20I%20created%20a%20SharePoint%20list%20with%20a%20column%20for%20each%20question%20in%20the%20form%3C%2FP%3E%3CP%3E8.%20I%20used%20Microsoft%20Flow%20to%20build%20an%20automated%20process%20that%20does%20the%20following%3A%20any%20time%20a%20form%20is%20submitted%2C%20add%20the%20content%20into%20the%20relevant%20column%20in%20the%20SharePoint%20list%3C%2FP%3E%3CP%3E9.%20I%20created%20one%20Flow%20per%20language%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFrom%20there%20I%20have%20options%3A%3C%2FP%3E%3CP%3E1.%20I%20can%20go%20to%20the%20SharePoint%20list%20and%20download%20the%20data%20into%20an%20Excel%20file%20at%20any%20time%3C%2FP%3E%3CP%3E2.%20I%20can%20build%20a%20flow%20that%20automates%20the%20process%20so%20that%20I%20have%20an%20Excel%20file%20that's%20always%20up%20to%20date%2C%20i.e.%20as%20soon%20as%20an%20entry%20is%20submitted%2C%20it%20gets%20added%20to%20the%20Excel%20file.%20Within%20that%20Excel%20file%20I%20can%20already%20have%20tabs%20containing%20pivot%20tables%20that%20allow%20quick%20analysis%20of%20large%20scale%20data.%3C%2FP%3E%3CP%3E3.%20I%20can%20use%20Power%20BI%20to%20build%20a%20dashboard%20that%20will%20make%20the%20info%20easier%20to%20view%20for%20people%20who're%20not%20Excel%20experts.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20some%20of%20that%20is%20helpful!%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-988274%22%20slang%3D%22en-US%22%3ERe%3A%20Change%20the%20language%20of%20a%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-988274%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F443515%22%20target%3D%22_blank%22%3E%40mscherismith%3C%2FA%3EThanks%20for%20your%20solution.%20Seems%20to%20be%20a%20adequate%20solution%20indeed.%3C%2FP%3E%3CP%3EIt's%20too%20bad%20not%20to%20have%20a%20real%20multilingual%20solution%20native%20...%20this%20should%20be%20designed...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-990260%22%20slang%3D%22en-US%22%3ERe%3A%20Change%20the%20language%20of%20a%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-990260%22%20slang%3D%22en-US%22%3E%3CP%3EI%20believe%20Forms%20Pro%20allows%20you%20to%20change%20languages%20as%20well.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Frequent Contributor

Anyone know how to change the language of a form?

 

I hope it is not changing profile or local computer settings.

Just I have an international organisation who want to be able to send forms in different languages.

 

Thanks

6 Replies
Highlighted

No answer 6 months later?

 

I am also interested in knowing how Forms handle multiple languages. Can we create a single form where text will be localized or we need to create multiple ones?

Highlighted

Hi Philip,

 

The language of the questions written in your form are in the language you wrote them.

So if you want a form to be available in multiple languages, you need to create multiple forms.

 

Regarding the language of the form application (words like Mandatory, Send, ...), the words used are displayed in the language of the browser. See https://support.office.com/en-us/article/language-settings-for-microsoft-forms-b282f9aa-0fe4-4290-b1... for additional details on this.

 

Hope this helps.

Highlighted

Hi Martin,

 

The actual question is how to combine forms results (especially with Quiz). Assume you have few hundred people answering the forms, let say few forms on different languages with exactly the same content and you need stats for all people, not for each language group separately. Plus data is constantly updated, like repeating test for employees and entry one for newcomers. Could be done through Excel files, but without Excel connector to results for Quiz it looks bit hard.

Highlighted

Hi.

 

Not sure if you still need a solution to this, but I've just done it myself.

 

1. First of all, I created my form in English.

2. I then translated it into the other languages I required (I used Google Translate and then had humans quality check the translations).

3. I copied the form I'd created in English and replaced each piece of text with the translated text in the first language.

4. I clicked on the menu icon (the three dots in the top right hand corner) then 'Multilingual'. I changed the primary language to the new language (e.g. from English to French).

5. I copied the URL for the translated form and added the language tag to the end of the URL, e.g. &lang=fr for French or &lang=es for Spanish, etc. (You can find a list of language tags online).

6. I repeated these steps for each language

7. I created a SharePoint list with a column for each question in the form

8. I used Microsoft Flow to build an automated process that does the following: any time a form is submitted, add the content into the relevant column in the SharePoint list

9. I created one Flow per language

 

From there I have options:

1. I can go to the SharePoint list and download the data into an Excel file at any time

2. I can build a flow that automates the process so that I have an Excel file that's always up to date, i.e. as soon as an entry is submitted, it gets added to the Excel file. Within that Excel file I can already have tabs containing pivot tables that allow quick analysis of large scale data.

3. I can use Power BI to build a dashboard that will make the info easier to view for people who're not Excel experts.

 

I hope some of that is helpful! :)

 

Highlighted

@mscherismithThanks for your solution. Seems to be a adequate solution indeed.

It's too bad not to have a real multilingual solution native ... this should be designed...

Highlighted

I believe Forms Pro allows you to change languages as well.

 

Cheers

Damien