Google Sheets is a great tool for translating languages, but it can be a bit of a challenge to get started. In this article, we’ll show you how to translate languages in Google Sheets using the built-in tools and tips. First, you’ll need to create a new sheet that will serve as your translation project. To do this, open Google Sheets and click on the “New Sheet” button (it looks like a plus sign). Next, give your new sheet a name and click on the “Create” button. You’ll now be able to start translating! To start translating, first select the language you want to work with from the dropdown menu on the toolbar at the top of your new sheet. Then, click on the “Translate” tab at the top of your sheet. Here, you’ll find all of the tools you need to translate your text. The first thing you’ll want to do is select the text you want to translate from your original language into your target language. Next, click on the “Translate” button in the bottom left corner of your screen and enter your translation into the box that pops up. Once you’ve finished translating all of your text, it’s time to save your work! To do this, click on the “File” tab at the top of your sheet and select “Save As.” Then, choose a filename for your translation and click on OK. ..
When not everyone you work with speaks the same language natively, you may need to use a translator. In Google Sheets, you can translate languages so that collaborating or reviewing spreadsheets is a bit easier.
We’ll show you two ways to translate languages in Google Sheets. The first method uses a function and formula while the second uses a third-party add-on. Take a look at how to use each to see which is best for you.
Use the GOOGLETRANSLATE Function
Just like Google offers its own translation tool, it provides a function for Google Sheets. GOOGLETRANSLATE lets you translate specific text or that in a cell with a simple formula.
RELATED: How to Scan and Translate a Picture in Google Translate
The syntax for the formula is GOOGLETRANSLATE(text, source_language, target_language). The first argument is required. As mentioned, you can use a cell reference or enter the text within quotation marks.
If you don’t enter a source language, the formula detects it automatically and if you don’t enter a target language, it uses the system language by default. For both, you’ll enter the two-letter language code in quotes.
Let’s look at some examples.
With the following formula, we’ll translate “Please select an option” from English to Spanish:
To translate that same text using its cell reference (A1) and the same languages, you would use this formula:
If you have the two-letter language codes in cells, you can reference those in the formula too. Here, we’ll translate cell A1 from the language in cell A2 to the language in cell A3:
For more functions and formulas like this, take a look at some basic Google Sheets functions you should know.
Install a Google Sheets Add-On
While the function above is a good option, you may not be a fan of using functions and formulas. Or you may simply want a quick way to translate an entire sheet. This is when the free Google Sheets add-on Translate My Sheet comes in handy.
RELATED: 14 Google Sheets Functions That Microsoft Excel Needs
After you install the add-on from the Google Workspace Marketplace, you can translate a selection of cells or your whole spreadsheet.
Go to the Extensions tab, select Translate My Sheet, and pick “Start a New Translation” in the pop-out menu.
When the sidebar opens, you can set up the tool. You’ll see the Source Language set to Auto Detect, but you can choose a different language in the drop-down list if you like. Then, pick the Target Language.
At the bottom under Advanced Settings, enable the toggles for translating the entire sheet, duplicating the sheet to translate, or applying a background color to changed cells per your preferences.
If you only want to translate particular cells rather than the whole sheet, select the cells.
When you’re ready, click “Translate.”
You’ll see a pop-up message letting you know the number of cells that will be translated. If this looks correct, select “Yes” to continue.
You’ll see either the edited cells or new sheet per the above settings you selected.
For additional extensions, take a look at some of the best Google Sheets add-ons.
Whether you pick the function and formula or the add-on, you have options to more easily work with others who speak a different dialect when using Google Sheets.
