Google Sheets Function: GOOGLETRANSLATE

The GOOGLETRANSLATE function allows translating text automatically or based on specified languages.

Usage:

=GOOGLETRANSLATE(text)

or

=GOOGLETRANSLATE(text, source_language, target_language)

Example of use

By default, source_language is set to "auto" (language detected automatically) and target_language based on the spreadsheet settings.

For automatic translation into one's own language, simply enter the "text" as the only argument of the GOOGLETRANSLATE function:

=GOOGLETRANSLATE(A2)

To translate text by specifying languages, enter the language source code followed by the target language code.

For example, to translate from French to English, enter:

=GOOGLETRANSLATE(A2,"fr","en")