2. Search and Install the Google Translate Extension
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.
3. Access your Google Form
Navigate to Google Forms and open the form you wish to translate. For example, the form below is written in English.
4. Initiate Translation
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'.
5. Select Language
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.
6. Translate the Page
After selecting the desired language, click the 'Translate' button.
7. Review the Translated Form
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.
Translate Responses from Multiple Languages into One Language
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.
1. Access Collected Responses
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.
2. Prepare a New Column for Translation
In Google Sheets, create a new column adjacent to the responses you want to translate. This column will hold the translated text.
3. Use Spreadsheet Functions for Translation
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:
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.
4. Apply the Translation Function to All Responses
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.
5. Review and Edit Translated Data
Examine the translated data for accuracy, correcting any errors or context issues to ensure that the translation is as accurate as possible.