- This topic has 0 replies, 1 voice, and was last updated 2 years, 5 months ago by Yusuf.
- February 19, 2020 at 10:47 pm #86226Spectator@yusuf
Google Translate is a popular tool used to translate text from one language to another. Interestingly, it now features a function that makes translation on Google Sheets seamless. With this function, you can use the superpowers of Google Translate right inside your Google Sheets. Let’s get started.
For this demonstration, you need to have a google account. Hurry and sign up if you haven’t already. You can access your Google Sheet through Google Drive. Click new, and click on Google Sheet. You should now have a screen like the one in the image below.
Translating Text in Google Sheets
To translate any text in Google Sheets, input the Google Translate function, with the text, source language, target language, and hit enter. Below is how the function is used.
=GOOGLETRANSLATE("TEXT", "SOURCE_LANG", "DESTINATION_LANG")
Replace the text with any sentence you want to translate, input the source language, and the destination language. Your translation should appear after hitting the enter key. In the case where the text was already typed in a cell, make reference to the cell in the function. If you’re inputting the text right into the function, you need to enclose it within quotes, but cell reference does not require quotes. In our example, there are some texts already entered in A2, A3, and A4. To translate the texts from English to German we type.
=GOOGLETRANSLATE(A2, "en", "de")
A2 is the cell address containing the text to be translated. “en” is the two-letter code for English the source language, and “de” is the code for German, the target language. An important point to note is, in a case where the source language is not known, “auto” can be used as the source language. This will make Google Translate to automatically detect the language of the text.
The image above shows the text in A2 successfully translated into German. To translate the rest of the cells under column A, simply click and drag the bottom-right corner of the cell A2.
Bonus: Using Google Translate with ImportFeed Function
Google Sheet’s ImportFeed function provides a robust way to get public online data directly into your spreadsheet. To import a feed into your spreadsheet type the function below.
=IMPORTFEED(url, [query], [headers], [num_items])
The URL is the location of the feed to be imported, the query parameter is the field to be displayed, the header parameter indicates whether to include column headers, as an extra row above the returned text. Finally, num_items is the number of rows to be returned.
When the feeds are imported successfully, you can go ahead and translate them using the GoogleTranslate function in this manner.
=GOOGLETRANSLATE("A2", "en", "de")
The Function above will translate the content of cell A2 from English to German.
- You must be logged in to reply to this topic.