Instructions on how to translate languages ​​on Excel spreadsheets

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.

Instructions on how to translate languages ​​on Excel spreadsheets Picture 1

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:

Instructions on how to translate languages ​​on Excel spreadsheets Picture 2

Refer to some of the following articles:

1. How to change the default save file format in Word, Excel and Powerpoint 2016?

1. Change the slash to a dot in Excel format

1. Instructions for deleting empty lines and columns in Excel 2016

Good luck!