Google Docs integrates a number of new features that enable users to translate languages on each cell on a spreadsheet to another language or detect specific languages used in a spreadsheet.
Google Docs integrates a number of new features that enable users to translate languages on each cell on a spreadsheet to another language or detect specific languages used in a spreadsheet.
To translate languages on each cell on a spreadsheet to another language, use the following function:
= GoogleTranslate ("text", "source language", "target language")
Suppose if you want to translate English A1 (English) cell text into Arabic (Arabic), use the following function:
= GoogleTranslate (A1, "en", "ar")
If you leave the target language (in the example above "ar") from the function, the GoogleTranslate function will automatically convert the text to the default language on your spreadsheet.
Use GoogleTranslate and ImportFeed function
Below is an animation describing how to use the Google Translate function in a spreadsheet (with ImportFeed) to translate the feed from another language into your language.
In this example, translate from English to French:
Refer to some of the following articles:
- How to change the default save file format in Word, Excel and Powerpoint 2016?
- Change the slash to a dot in Excel format
- Instructions for deleting empty lines and columns in Excel 2016
Good luck!