Insider Guides

How to Translate Language in Google Sheets in 2022

Story Highlights
  • Translate Language in Google Sheets
  • Translator for Google Sheets
  • Translator Auto Detect Language in Google Sheets

How to Translate Language in Google Sheets in 2022

In a manner analogous to that of Microsoft Excel, Google Spreadsheets is typically centered on working with data such as text, dates, and numbers. This is made possible by the functions integrated into Spreadsheets; however, one of these functions, the ability to translate text within cells, is likely unknown to most users.

As its name makes abundantly evident, it is a formula connected to the Google translator. Through the use of this formula, it is possible to translate text from one language to another in an incredibly easy manner.

Related: What Does CC Mean in Email? What is the Difference Between CC and BCC in Email?

The syntax for its use is as follows:

 GOOGLETRANSLATE(text, [source language, target language]).

A text – The source text for the translation. This may also represent Google Sheets’ cell number, e.g. A1, A2, A3,…

Source language (Language of source code) – The two-letter language code for the language of origin, such as “en” for English, “es” for Spanish, or “auto” for automatic language detection.

Target language – A two-letter abbreviation for the language being translated into; for example, “en” for English or “fr” for French.

Steps to Translate Language in Google Sheets.

The steps below should be followed to translate the language of any word in  Google Sheets:

1. Launch your Google Sheet.

translate language in google sheet

2. Add words that you would translate in cells A2, A3, A4, A5, for example, as show in the picture below.

translate language in Google sheets

3. Click on a different cell now; in this case, B2, B3, B4, B5, … where we expect the translated words in Google Sheets.

google sheets language translation

4. While B2 is still highlighted, click the summation sign at the top right hand. side. Click Google and then Googletranslate to launch Google translate.

translate language in Google sheets

5. A code that looks like this will show up:  =GoogleTranslate( text, [source_language], [target_language] )

This image has an empty alt attribute; its file name is translate32-1024x441.webp

6. Select the cell containing the text you wish to translate, and then click the cell’s corresponding Translate button.
You can select the source language, here it is en(English).
Select the target language you wish to translate., here it is es, which is Spanish. Always put the language codes in quotation marks, as shown below:


translate Google sheets

7. Click enter to translate

Google sheets translate

Google Sheets Text language Translation codes:

FR: Frenchfr
ZH: Chinesezh
HI: Indianhi
AR: Arabicar
PT: Portuguesept
IT: Italianit
UK: Russianuk

The Most Commonly Asked Questions

Can Google Sheets detect language?
Google Sheets’ DETECTLANGUAGE function requires the user to access the function explorer before it can be used. Select the “fx” icon from the sheet’s toolbar to access this function. When the function explorer is visible, type “DETECTLANGUAGE” into the search bar and hit enter.

Can I translate an entire Google Sheet?
Google Sheets is an excellent platform with many useful features. In particular, one of these features allows you to convert the text in a spreadsheet cell into a different language. You only need Google Sheets to translate any word, identify languages, and compile vocabulary lists.

In Google Sheets, how do I translate in bulk?
Once you have one, you can select all the cells you wish to translate by clicking on the corner of the translated cell and dragging down the formula. All translations should be made on your sheet once you are finished. Once the source material has been removed, you will have a fully translated CSV file.

Also, have a look at these helpful guides.

How to Develop Best Strategies in Business

 What is the SSL certificate? How the SSL Certificate Works, and why is SSL important?

How to Delete Page From Facebook

How to set a homepage on Chrome

This article will show you how to translate language in Google Sheets. Share your ideas in the comments section.

Editorial Staff

UpHid's Editorial Team, headed by Chris Kenny, consists of WordPress professionals. Beneficial WordPress tutorials and instructions are being developed here at, making us a go-to destination for internet users.

Leave a Reply

Your email address will not be published.

Back to top button