GoogleTranslate Function

GOOGLETRANSLATE() Description

The GOOGLETRANSLATE() function allows you to translate text directly in any sheet cell. It uses the online service "Google Translator" and can be used both independently and in conjunction with other standard spreadsheet functions.

Additionally, you can use the built-in tool "Google Translator", which also performs translation directly in the cell - quickly and conveniently.

If you want to translate text using artificial intelligence (AI), then the AITRANSLATE() function is available, which works based on the powerful language model Google "Gemini".

Key Features of the GOOGLETRANSLATE Function

Syntax:

=GOOGLETRANSLATE(TextToTranslate; SourceLanguage; TargetLanguage)

Parameters:

• TextToTranslate: Cell with the text you want to translate into another language.
• SourceLanguage: The language of the selected text as a two-letter code.
• TargetLanguage: The language into which you want to translate the text as a two-letter code.

How It Works?

Simply enter the GOOGLETRANSLATE function into the appropriate cell, specifying the text to translate, the source text language, and the target language. Excel (Calc) will automatically use "Google Translator" to provide an accurate and fast translation.

Example of Use

Suppose you have a cell with text you want to translate. You just need to enter the GOOGLETRANSLATE() formula, and Excel (Calc) will automatically translate the text:

=GOOGLETRANSLATE(TextToTranslate; SourceLanguage; TargetLanguage)

We will get the following result:

The following values are used in this example:

• TextToTranslate: A2 - cell with text for translation ("The quick brown fox jumps over the lazy dog").
• SourceLanguage: B2 - English (text language) ("EN").
• TargetLanguage: C2 - French (translation language) ("FR").

Where to Get the List of Languages and Their Codes?

A complete list of supported languages, as well as their codes, can be found on the official Google page: "Language support"

Download extension

You can use the GOOGLETRANSLATE() function by installing the YLC Utilities extension.

After that, this function will be available in all files opened in Excel (LibreOffice Calc).