Skip to content
Home » Google » Google Sheets: Translating Languages

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.

How to Update Student Spreadsheets

You make a copy of a spreadsheet per student, but what if you have a typo or want to add to the spreadsheet? sheetPusher by Alice Keeler and Heather Lyon helps you update student spreadsheets. Here is…

Google Docs Google Play App Store Install

If you use Google Docs you want to be sure to have the mobile version as well. Use google play app store install

Navigate Google Forms Sections

If you use Google Forms you want to be using SECTIONS in Google Forms and controlling how students navigate the Form.. Navigate Google Forms Sections

BETTER – Print Google Form Quiz

Have more control over how your Google Form™ Quiz prints. Sometimes you need your Google Form on paper and this solution will help you to do it better! Print Google Form Quiz to a Google Doc and custo…

Something Fun for the End of the Year

What is something fun for students to do at the end of the year? While there are many choices, a fun word search can give students something to do while other students are finishing a task. Try my tem…

3 thoughts on “Google Sheets: Translating Languages”

  1. Pingback: Google Sheets: Translating Languages – Teacher Tech – Dinezh.com

  2. Pingback: Sharing Diigo Links and Resources (weekly) | Another EducatorAl Blog

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.