LATEST UPDATES
latest

How to Translate text using Google Sheet

Translate text using Google Sheet

If a translator software is not available at your disposal for text translation, afraid not. Google Sheet at your service. Here's how you can translate a whole bunch of text using Google Sheet.

1. Open a new Google Sheet
2. Type in the text that you want to translate in cell A1
3. Use the following formula to translate that text

In this case, text would be A1 where you have pasted the text to be translated. Here is a list of codes that you need to use in place of [Source Language], and [Target Language]:

en = English
es = Spanish
zh = Chinese
ru = Russian
hi = Hindi
ja = Japanese
ar = Arabic
ko = Korean
pt = Portugese
ge = German
it = Italian
fr = French
tl = Tagalog
vi = Vietnamese

So, to translate from English to German, the formula would look like:

Try it out and let me know if it helps. And always remember, sharing is caring!
« PREV
NEXT »