In this article, we will show you how to translate a Google Form in just a few clicks. Simply follow the steps below.
Here’s how to translate Google Forms using Google Translate:
Open Google Chrome and go to https://chrome.google.com/webstore in the address bar. Press Enter to navigate to the Chrome Web Store.
Type "Google Translate" in the search bar.
Once found in the search results, click 'Add to Chrome' or a similar option to install the extension.
Navigate to Google Forms and open the form you wish to translate. For example, the form below is written in English.
Click on the Google Translate icon in your Chrome toolbar. A search bar will appear with a 'Translate' button. Below the search bar, click the link that says 'Translate this page'.
A navigation bar appears stating 'View this page in:' followed by a dropdown menu. Select your desired language from this dropdown. In the image below, we translated our form into spanish.
After selecting the desired language, click the 'Translate' button.
After the translation is complete, review the form to ensure all text including questions and options is translated accurately. In the example below we translated our form into Spanish.
When distributing a form to a diverse audience, you might receive responses in several different languages. This requires translation to a single language for uniform analysis and understanding.
To view the responses collected from your Google Form, navigate to the form and click on the "Responses" tab. Here, you will find a green spreadsheet icon accompanied by the text "View in Sheets." Click this icon to open the Google Sheet containing all the responses.
In Google Sheets, create a new column adjacent to the responses you want to translate. This column will hold the translated text.
In the new column, use the GOOGLETRANSLATE function to translate the responses. For example, input `=GOOGLETRANSLATE(E2, "auto", "en")` to translate the text in cell E2 to English.
Common language codes include:
English: "en"
Spanish: "es"
French: "fr"
German: "de"
Chinese (Simplified): "zh-CN"
For a comprehensive list of language codes, you can refer to the IANA Language Subtag Registry, ISO's list of country codes, or consult Google's own documentation and support pages.
To translate all the responses, click and hold the bottom right corner of the cell that contains the translation function. In the image below, you can see that the function has already been applied to column F, where the cell contains the date January 21, 1999. Drag it down the entire column to apply the function to all responses.
Examine the translated data for accuracy, correcting any errors or context issues to ensure that the translation is as accurate as possible.
We hope you now have a better understanding of how to translate a Google Form. If you enjoyed this article, you might also like our article on how to add a link in Google Forms or our article on how to publish a Google Form. If you want to know how to send a confirmation email in Google Forms, we also suggest checking out our detailed guide.
