GoogleTranslate function for Excel

GOOGLETRANSLATE() Description

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

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

Main Features Functions GOOGLETRANSLATE

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 in which you want to translate the text in the form of a two-letter code.

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. Excel 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 GOOGLETRANSLATE() formula, and Excel will automatically translate the text:

=GOOGLETRANSLATE(TextToTranslate; SourceLanguage; TargetLanguage)

We will have the following result:

This example uses the following values:

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

Where can I get a 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 the extension

You can use the GOOGLETRANSLATE() function by installing a free extension YouLibreCalc.xlam .

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