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")
- 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
- Translate your entire sheet
How to install:
Click Add-ons
Select Get Add-Ons
Search "Translate My Sheet" to GSuite Marketplace
Click the "Translate My Sheet" add-on
Click Install
After installation, the add-on will be added under Add-ons
No comments: