Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Google Sheets: Translating Languages

Translate quickly in google sheets
Google Sheets: Translating Languages
Translate quickly in google sheets

I was honored this week to speak with educators in Barcelona. While I know some Spanish, I am not fluent. Wanting to use a Google Form to collect responses from audience members I knew that my Spanish was not sufficient to quickly translate and understand. Google Sheets however makes it easy to translate.

=GOOGLETRANSLATE()

The formula =GOOGLETRANSLATE() will convert text in one language in Google Sheets to another language.

CopyDown Add-on

The copyDown add-on for Google Sheets will automatically copy a formula in a spreadsheet upon Form submission.

Install the copyDown add-on

Create a Google Form. On the Responses tab, select the spreadsheet icon. In a blank column for the first response to the Google Form write the formula =GOOGLETRANSLATE(). Use the Add-on menu in the spreadsheet to select “copyDown.” The add-on will automatically detect the formulas you have written in the spreadsheet and allow you to copy that formula to each row dynamically as entries are made to the Google Form.

© 2024 All Rights Reserved.

💥 FREE OTIS WORKSHOP

Join Alice Keeler, Thursday Mar 28th or register to gain access to the recording.
Create a free OTIS account.

Join Alice Keeler for this session for a way to create dynamic and interactive digital lessons. The Desmos platform is completely free and allows for any topic to be created or customized.

Exit this pop up by pressing escape or clicking anywhere off the pop up.