[G Suite Tips] Translating text in Google Sheets

Share on facebook
Share on twitter
Share on pinterest
Share on linkedin

If you want to translate words or phrases from one language to another, you’ll probably use Google Translate. But what will you do if you need to translate a batch of words in spreadsheets? Keep switching back and forth between Google Translate and Spreadsheets? 

In fact, translating words in Google Sheets is as simple as inputting a formula. Here’s the formula:

=GOOGLETRANSLATE(“text”, “source language”, “target language”)

text: the text you want to translate

* The value for text must either be enclosed in quotation marks or be a reference to a cell containing the appropriate text.

source language: the language being translated from

*Please use the two-letter language code, e.g. “zh-TW” for Traditional Chinese or “en” for English.

target language: the language being translated to

* Please use the two-letter language code, e.g. “zh-TW” for Traditional Chinese or “en” for English.

Check out how to do it in the video below!

Check out the language code here!

Language Name

Language Code

Chinese Simplified

zh-CN

Chinese Traditional

zh-TW

English

en

Filipino

tl

French

fr

German

de

Greek

el

Indonesian

id

Irish

ga

Italian

it

Japanese

ja

Korean

ko

Latin

la

Polish

pl

Portuguese

pt

Russian

ru

Spanish

es

Swedish

sv

Thai

th

Turkish

tr

Vietnamese

vi


Source: Google Support

What's Hot

Most Popular

Get The Latest Updates

Subscribe To Our Newsletter

No spam, notifications only about new updates.

Follow Us on Social Media

Read More

Related Posts

5 Ways to Improve Your Ecommerce Conversion Attribution

A shopper’s journey to making a purchase very likely consists of multiple sessions. The last session would therefore be where the conversion gets its attribution from. This would likely be very misleading. Luckily this issue likely only exists on your reports and Google Ads, if you enable automated bidding, likely knows the best attribution to use (Data-driven Model)

master concept website launch

Breaking news: Our new website is launched!

With a mission to make the brand new website faster, easier to navigate, and more user-friendly. Our amazing staff have spent more than three months’ days & nights building from scratch, and we are delighted to officially announce the launch on Aug 25, 2020.

Master Concept

Leave Us Your Message.
We are ready to talk!

Leave Us Your Message.
We are ready to talk!

Leave Us Your Message.
We are ready to talk!

Can't Find What You Need? Join Our Latest Event!

Be the first to learn about
New Trends