Translate languages in Google Sheets with GOOGLETRANSLATE function

Posted on:  05/14/2020
Translate languages in Google Sheets with GOOGLETRANSLATE function

Google Sheets has a translate function called GoogleTranslate. The function translates text from one language into another. It is free to use, and you can set up mixed references so you can translate the original text into many languages at one time.

Arguments in GoogleTranslate

Google Translate has three arguments in the function. Two of the arguments are optional.

Syntax:
GOOGLETRANSLATE(text, [source_language, target_language])

  1. Text is the text to translate. The value for text must either be enclosed in quotation marks or be a reference to a cell containing the appropriate text.
  2. Source_language - [ OPTIONAL - "auto" by default ] - The two-letter language code of the source language, e.g., "en" for English or "ko" for Korean, or "auto" to auto-detect the language.
  3. Target_language - [ OPTIONAL - system language by default ] - The two-letter language code of the target language, e.g., "en" for English or "ja" for Japanese.

Chris Menard's YouTube Video on GOOGLETRANSLATE using Mixed Reference

Mixed Reference

  1. In the screenshot above, I'm using a mixed reference to freeze column A. The dollar sign in front of column A freezes column A.
  2. I'm using a mixed reference to freeze row 1. Notice the dollar sign before the number 1.

You can either manually type the dollar sign or press the F4 function key on your keyboard to cycle through cell reference, Keep pressing F4 until you get the reference you need.

Chris Menard

Chris Menard is a certified Microsoft Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. He runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Google Calendar, and Outlook. To date, the channel has helped over 20 million viewers. Menard also does 2 to 3 public speaking events every year, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the Support Staff Conference, the University of Georgia, and CPA conferences. You can connect with him on LinkedIn at https://chrismenardtraining.com/linkedin or watch his videos on YouTube at https://chrismenardtraining.com/youtube.

Categories