How to Translate Text in Google Sheets

 Updated post here: https://werkify.blogspot.com/2023/02/translate-text-in-google-sheets-using-the-googletranslate-formula.html

Having a hard time to translate text in Google Sheets? Here is a tip on how you can do it.

GOOGLETRANSLATE Function

Syntax

GOOGLETRANSLATE(text, [source_language, target_language])

  - text ~ the cell (text) you want to translate
    - source language ~ the original language of the text; if you don't know you can use "auto"
    - target language ~ the language you want the text to be translated (language code usually start with the first two letters e.g. English ~ "en", Korean ~ "ko")

Is your language supported? Browse the list of Google Translate Supported Language.

Translate My Sheet Add-on

Translate My Sheet

This simple Google Add-on allows you to translate your spreadsheet in more of 100 languages! Two options are available:

    - Translate your selected range 
    - Translate your entire sheet

How to install:

1. Click Add-ons

2. Select Get Add-Ons

3. Search "Translate My Sheet" to GSuite Marketplace

4. Click the "Translate My Sheet" add-on

5. Click Install

6. After installation, the add-on will be added under Add-ons

How to use the Add-on:

Please click the .gif file to enlarge the video.