This will return the translated text 'Bonjour' in the cell.Įxample 3: Automatic source language detection If you have a cell (A1) containing the text 'Good morning' and you want to translate it to French, you can use the following formula: This will return the translated text '�Hola, mundo!' in the cell. =GOOGLETRANSLATE('Hello, world!', 'en', 'es') Suppose you want to translate the text 'Hello, world!' from English to Spanish.

Let's look at some examples of how to use the GOOGLETRANSLATE formula in Google Sheets. If omitted, the default target language is English ('en'). target_language (optional): The language code of the target language you want to translate the text into.Language codes are typically two-letter codes, such as 'en' for English or 'es' for Spanish. If omitted, Google Translate will attempt to detect the source language automatically. source_language (optional): The language code of the source text.This can be a cell reference or a text string enclosed in double quotes. The GOOGLETRANSLATE formula has the following syntax: We will cover the syntax, examples, tips and tricks, common mistakes, troubleshooting, and related formulae in this article. Whether you're working with a multilingual dataset or simply need to translate a single phrase, the GOOGLETRANSLATE formula can save you time and effort. This powerful function allows you to translate text from one language to another using Google Translate's API. In this comprehensive guide, we will explore the GOOGLETRANSLATE formula in Google Sheets.

Correct in french google translate