In this article:

How to Translate in Google Sheets: Easiest Way in 2024

google sheets translate
Source: thenextweb.com

What is GOOGLETRANSLATE in Google Sheets?

The Google Translate function in Google Sheets refers to the integration of Google's language translation features within a spreadsheet. This integration allows you to translate text from one language to another directly within your spreadsheet using a simple formula.

GOOGLETRANSLATE Formula

The basic formula of the GOOGLETRANSLATE function is as follows:

=GOOGLETRANSLATE(text, [source_language], [target_language])

where:

text: The text you want to translate.

[source_language]: The two-letter code of the source language (e.g., 'en' for English). This is optional; if you don't specify it, Google will attempt to auto-detect the language.

[target_language]: The two-letter code of the source language (e.g., 'en' for English). If you don't specify this, Google will attempt to auto-detect the language.

How to Translate in Google Sheets

Follow the steps below to translate text from one language to another directly in your spreadsheet.

1. Open Google Sheets and Type Text for Translation in a Cell

Open a new or existing Google Sheets document. Type the text you want to translate into a cell, such as "Hello World" in cell A1.

translate google sheets

2. Click on Destination Cell and Begin GOOGLETRANSLATE Function

Click on the cell where you want the translated text to appear, like B1. In this cell, type =GOOGLETRANSLATE( to start the formula.

translate in google sheets

4. Reference the Cell Containing Text to Translate in the Formula

After the opening parenthesis, click on the cell with the text you want to translate, or type its cell reference. In our example, use A1.

google translate sheets

6. Input Source Language Code After Text Reference (Optional)

After the text reference, type a comma. Add the source language code in quotes, like "en" if you want to translate an English word. You can find these codes in the Google Translate documentation or online. Skip this step if unsure of the language.

google translate google sheets

7. Specify Target Language Code in the Formula

Type another comma. Then, add the target language code in quotes, such as "es" for Spanish.

google translate in google sheets

8. Complete the Formula and Press Enter to Translate

Type a closing parenthesis to complete the function, making it =GOOGLETRANSLATE(A1, "en", "es"). Press Enter, and the translation, like "Hola Mundo", appears in the cell.

google sheets translate formula

9. Repeat Process for Additional Translations as Needed

To translate more text, repeat these steps. Change the source and target languages as needed for different translations.IMAGE

how to translate in google sheets

We hope that you now have a better understanding of the GOOGLETRANSLATE function and how to translate in Google Sheets. If you enjoyed this article, you might also like our article on how to set up t-test in Google Sheets or our article on how to see edit history in Google Sheets. 

Automate everything you track in spreadsheets with Lido
Learn more

Automate manual tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Trigger
Action
Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
ADDCALENDAREVENT
Creates a one- or multiple-day calendar event with optional attendees
ADDHUBSPOT
Adds an object to Hubspot
ADDSLACKCHANNEL
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
CREATEGOOGLEDOC
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
CREATEPDF
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
FETCH
Makes any HTTP request and returns the response
INSERTROWS
Inserts given array below defined values in given worksheet
SENDGMAIL
Sends an email using your Google account
SENDOUTLOOK
Sends an email using your Microsoft Outlook account
SENDSLACK
Sends a Slack message
SENDSMS
Sends an SMS message using your Twilio account
UPDATECELL
Updates cells with given values
UPDATEHUBSPOT
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started