Penggunaan Google Translate "langsung" di dalam Google Sheets dengan Fungsi Bawaan/Built-in (Source: ChatGPT)
Use Google Translate directly inside Google Sheets with the Built-in Function
Syntax
=GOOGLETRANSLATE(text, [source_language], [target_language])
-
text → The cell or string you want to translate.
-
source_language → The language code of the text (like
"id","en","ja"). Use"auto"to detect automatically. -
target_language → The language code you want to translate into.
Examples
-
Translate Indonesian → English
=GOOGLETRANSLATE(A2, "id", "en")
If cell A2 contains Selamat pagi, it will return:
👉 Good morning
-
Automatic detection (any language → English)
=GOOGLETRANSLATE(A2, "auto", "en")Translate ⚠️ Notes:
-
The function works only in Google Sheets (not in Excel)
-
You need internet access for translations
-
Some languages might not be perfectly supported
Comments