How to Turn Google Sheets into a Translator

You can translate words from over 10 different foreign languages

2 min. read

Updated onJanuary 22, 2024

updated onJanuary 22, 2024

Share this article

Improve this guide

Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more

Key notes

Many people love Google Docs, Sheets, and all the other free office services fromGooglebecause they are efficient and familiar.

They are also compatible with their Microsoft counterparts (Google Docs with Microsoft Word,GoogleSheets with Microsoft Excel, etc.), making them great for personal use on a low budget.

Fewer people know just how cross-compatible Google Docs is with other services from Google. One good example is how you can transform Google Sheets into a multi-language translator.

This can be easily done by manipulating a few cells and giving them specific operating functions.

How can I turn Google Sheets into a translator?

In this step-by-step guide, we will show you how you can turn a simpleGoogleSheets document into a multi-purpose translator.

By doing this, you won’t need to go to theGoogleTranslate app in a separate tab anymore.

If you are looking to turn Google Sheets into a translator, all you have to do is use a cell formula and apply it to the text you want to translate. The app will then translate the text according to your settings.

Basically, the formula allows you to translate a sentence or a word written on a row or column from one language to another. The first language inserted is the one in which the sentence or word is written. The second language inserted is the one you want to translate to.

One neat thing about this trick is that it supports dragging, meaning you can take the function and drag it along a column, and it will adapt accordingly.

Additionally, this trick works with all languages that are supportedby Google Translate.

Go tohttps://docs.google.com/.
Press on theMain Menubutton in the top-left corner (it looks like 3 horizontal lines).
SelectSheetsfrom the drop-down list.
Press on the one labeledBlankto start a new spreadsheet.

5.Select a cell, and label it with the name of a language for easier recognition. In our example, we choseEnglish.

6.Select other cells, and label them with the names of other languages.Again, in our test, we chose Spanish and French, but you are free to use any languages you want.

Right under the cell where you wroteEnglish, write anEnglish word or a sentence.

8.Select another cell, such as right under Spanish, and write the following line in the functions bar (fx):=GOOGLETRANSLATE(C2,”en”, “es”).In our case,C2is the cell where we wrote the English word or sentence. Change this according to your needs.

PressEnterto apply the formula.

10.After a brief loading time, the destination cell will contain the translation of the source cell.

What language abbreviations can I use in Google Sheets?

For a quick summary of all major language abbreviations, check out the list below:

In case you are looking for thebest kanji translator image,we recommend you check out this guide to learn more about them.

If you are wondering how togrant editing rights to a person or group on Google Sheets, we have a separate guide for you.

Did you find this trick useful? If you have any other questions or suggestions, leave them in the comments section below and we’ll certainly look at them.

How to Turn Google Sheets into a Translator#

How can I turn Google Sheets into a translator?#

What language abbreviations can I use in Google Sheets?#

How to Turn Google Sheets into a Translator

How can I turn Google Sheets into a translator?

What language abbreviations can I use in Google Sheets?