
They both need to be the two-letter code of a language. The second and third variables are optional, they are called source_language and target_language. This can be a text between brackets, like this “Hello, welcome to our website”, or a cell. The first variable you need to fill in is the text you want to translate. =GOOGLETRANSLATE( text, , )Įxample 1: Translating the word ‘Cheese’ from English to SpanishĮxample 2: Translating cell A1 from Dutch to German To use the GoogleTranslate function in Google Sheets, select the cell and type in the following formula. In this tutorial, you’ll learn how to use the function. You can now translate words and sentences in bulk, with the ease of Google Sheets.

However, did you know that Google Translate was also available in Google Sheets? It’s awesome. Thanks to that application, it’s easier to communicate with people who don’t speak your language.

You’ll probably already know Google Translate, the most popular translation tool on the internet.
