Google Sheets Function: GOOGLETRANSLATE

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




=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:

google sheets googletranslate auto

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:

google sheets googletranslate
The main language codes are: English = en / French = fr / German = de / Italian = it / Portuguese = pt / Spanish = es.