[G Suite Tips] Translating text in Google Sheets

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

Popular

Popular Posts

Get The Latest News

Subscribe Our Newsletter

No Spam, only provides you the latest technology updates.

Follow Us

Know More

Related Posts

What is BigQuery to marketers and why should marketers be using it? (part 1)

BigQuery is a data warehousing platform that allows marketers to uncover what’s working and what can be improved in their digital marketing campaigns. With this invaluable insight, BigQuery allows companies to increase the effectiveness of their marketing campaigns by 79% and tailor these campaigns to their relevant goals. This article will demonstrate the tremendous capabilities of BigQuery to marketers and why it is a must-use for every digital marketer today.

Picking the Right Project Management Software for You: Asana vs Wrike

How to pick a project management tool? Asana vs Wrike full comparison

A broad spectrum of project management tools are present in the markets, so when choosing the right software, enterprises’ needs as the starting point is important by evaluating the work purposes, the problem desired to be solved or the situation desired for improvement. Asana and Wrike are the two giants in the project management market, how should companies compare and make a decision?

Access Identity Hong Kong Series 2021

PRESENTED BY The Teh Group Introduction Raising the Bar for Identity and Access Management Excellence to Safeguard Your Digital Assets. In today’s boundaryless business world,

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