How to translate languages on Google Sheets spreadsheet
To translate the language in each cell on the spreadsheet into another language, use the function below:
=GOOGLETRANSLATE("văn bản cần dịch"; "ngôn ngữ nguồn";"ngôn ngữ đích")
Suppose if you want to translate text in cell A1 from English (en) to Vietnamese (vi), you use the function below:
=GOOGLETRANSLATE(B64;"en";"vi")
If you remove the target language (in the example above, "vi") from the function, the GOOGLETRANSLATE function will automatically convert the text to the default language on your spreadsheet.
Use GoogleTranslate with the ImportFeed function
Below is an animation demonstrating how to use the Google Translate function in a spreadsheet (with ImportFeed) to translate a feed from another language into your own.
In this example the translation from English to French:
Use the Google Sheets add-on
Although Google Sheets' built-in functions work quite effectively and quickly. But if you find having to type out formulas like that is too cumbersome, or you might just want a quick way to translate an entire sheet, use a free add-on called Translate My Sheet.
After installing the Translate My Sheet add-on from the Google Workspace Marketplace, you can immediately start translating some cells or your entire spreadsheet.
On the worksheet interface, click the Extensions tab in the upper left corner of the screen. In the pop-up menu, click Translate My Sheet and select ' Start a New Translation '.
When the sidebar menu opens, you can perform several tool setup options. You will see the Source Language section set to Auto Detect . However, you can select another language in the drop-down list if you want. Then, select Target Language (target language).
At the bottom in the Advanced Settings section , you turn on the corresponding toggles for translating the entire worksheet, copying the worksheet for translation, or applying a background color to changed cells. It all depends on your actual needs.
If you only want to translate specific cells instead of the entire worksheet, select the exact cells you want.
When you're ready, click ' Translate '.
You will see a pop-up message indicating the number of cells to be translated. If correct, select ' Yes ' to continue.
You will see the edited cells or new sheets according to the settings selected above.
Whether you choose to use built-in functions or add-ons, there are options to quickly translate languages in Google Sheets.
Wish you success!
You should read it
- How to use Google Translate to translate languages on the phone
- For the first time in 4 years, Google Translate is adding new languages
- Google Translate adds support for 110 new languages, including Cantonese
- Translate language on Viber
- How to translate text on photos for iPhone with Translate Photo
- How to translate languages right on the camera with Google Translate
- Translate text directly on iPhone keyboard with Gboard's Translate
- How to use Mate Translate to translate on Chrome
May be interested
- 6 useful functions in Google Sheets you may not know yetin this article, i will show you 6 useful functions for the google sheets spreadsheet that you should know such as vlookup, countif, sumif, join, index, ... in addition, you can refer to the functions. and other tips follow the link in the post.
- How to fix Google Sheets not allowing scrollinggoogle sheets is a free and easy to use spreadsheet application that works right out of the box. however, sometimes users face some glitches.
- How to translate a conversation on Google Assistantthe google assistant updates the interpreter feature to translate desired words into other languages.
- How to translate the example of the original word on Google Translateif you want to translate examples of the word being searched on google translate, you can install the google translate plus utility.
- 5 reasons you should give up Excel and start using Google Sheetsgoogle sheets is a spreadsheet web application that works as part of the google docs toolkit. google sheets was released in 2006, nearly two decades after the first release of microsoft excel.
- 3 simple ways to download pronunciation files on Google Translateyou often hear english (or other languages) through google translate and want to download its audio file but don't know how? it's easy to do that with 3 ways outlined in this article.
- Google Translate has 'spoken' Vietnameseyesterday (december 4), google just announced the release of a complete package of translation tools from vietnamese into 34 languages and vice versa here.
- How to Make a Google Spreadsheetif you're accustomed to creating your spreadsheets using an office suite or software like microsoft excel, you won't have any issue in creating a google spreadsheet. google spreadsheet works the same as excel, and you can do most of the...
- How to Delete Empty Rows on Google Sheets on Androidthis wikihow teaches you how to select and delete an empty row from a spreadsheet file on google sheets, using android. open google sheets on your android. the sheets app looks like a green document icon on your apps menu. it will open up...
- How to fix Google Chrome Translate not workinggoogle chrome's translation feature makes it easy to navigate websites in foreign languages. however, sometimes it can stop working due to outdated settings, cache issues, or extension conflicts.