GoogleTranslate Function for Excel (Calc)

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 combination 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 function AITRANSLATE() is available, which operates based on a powerful language model Google "Gemini".

Key Features of the GOOGLETRANSLATE Function

Syntax:

=GOOGLETRANSLATE(TextToTranslate; SourceLanguage; TargetLanguage)

Parameters:

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

How It Works?

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

Example Usage

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:

In this example, the following values are used:

• TextToTranslate: A2 - cell with the 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 a List of Languages and Their Codes?

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

Download extension

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

Or its free version YouLibreCalc.

Or its free version YouLibreCalc.

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