ergeneration.blogg.se

It performs translation without any human input to the process. Google Translate is an automated translation service provided by Google. The following KB article should help- kb.sdl.com/ See the table below for language codes to use with the GOOGLETRANSLATE function.I would think this is related to the API and the usage limits Rather than writing "spanish" for example, you would provide "es" as the language argument.Īs of February 2020, Google Translate supports 108 languages, which means that you can use the GOOGLETRANSLATE function to translate text between all of these languages in Google Sheets.

"spanish") as an argument, your formula will return a #VALUE! error. If you attempt to provide the actual language (e.g. When using the GOOGLETRANSLATE function in Google Sheets, the language arguments in the formula need to be in the form of the language codes shown in the table below. This formula returns a result of "How are you?" in English in cell C5.

Google will detect the language of the text in cell C5 (Icelandic) and translates it to the system language of the user's computer, which, in this example, happens to be English. We can just leave from_language and to_language blank.

In the fourth and final example we see more fun text in cell A5, but again, we don't know what language this is. This formula detects the language is Afrikaans (we could use the DETECTLANGUAGE function if we need to know which language this is) and returns a result of "Translating is fun" in English in cell C4. We can supply "auto" as the second argument, so that Google will detect the language on its own. In the third example, we see some text in cell A4, but we're not sure what language this is. This formula returns a result of "This is Japanese!" in English. In the second example we see that the text in cell A3 is written in Japanese and we want to translate it to English. This formula returns a result of "Hello!" in English. We use A2 as the first argument, "es" (the language code for Spanish) for the second argument, and "en" (the language code for English) as the third argument. In the first example, we see that the text in cell A2 is written in Spanish, but we want to translate it to English. Here are some examples of the GOOGLETRANSLATE function in action. Examples with the GOOGLETRANSLATE Function in Google Sheets