In this article:

How to Translate in Google Sheets: Easiest Way in 2024

May 8, 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. 

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->