TOP

GoogleTranslate function for LibreOffice Calc

YLC Utilities logo

GOOGLETRANSLATE() Description

The GOOGLETRANSLATE() function is designed to translate text directly in a cell on any worksheet.

For text translation, this function uses the "Google Translate" site and can be used in any formulas both independently and together with other standard functions.

You can also use a ready-made tool "Google Translate" , which translates text directly into a cell on any worksheet.


Main Features Functions GOOGLETRANSLATE

Syntax:

=GOOGLETRANSLATE(TextToTranslate; SourceLanguage; TargetLanguage)

Parameters:

How Does It Work?

Just enter the function GOOGLETRANSLATE in the appropriate cell, specifying the text to be translated, the language of the source text and the language you want to translate into. LibreOffice Calc automatically uses "Google Translate" to provide accurate and fast translation.

Example Usage

Have a cell with the text you want to translate. All you have to do is enter the formula GOOGLETRANSLATE(), and LibreOffice Calc will automatically translate the text:

=GOOGLETRANSLATE(TextToTranslate; SourceLanguage; TargetLanguage)

We will have the following result:

GoogleTranslate formula usage

This example uses the following values:

Where can I get a list of languages and their codes?

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

Download the extension

You can use the GOOGLETRANSLATE() function by installing a free extension YouLibreCalc.oxt or its full-featured version YLC_Utilities.oxt .

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