Using Google Translate in Google Sheets
- Mar 26
- 1 min read
If, like us, you work with international colleagues, you have to utilise this feature.
There is no need to leave your spreadsheet to translate content; there is a built-in translate function in Google Sheets.
=GOOGLETRANSLATE Function
You can translate entire columns of product descriptions, names, or feedback notes without ever leaving your document.
Imagine you have an English phrase in cell A1 and you need it in Spanish. You simply type: =GOOGLETRANSLATE(A1, "en", "es")
If you aren’t sure what the original language is, you can use "auto" as the source language. Sheets will figure it out for you.
Top Tip: If you change the original text, the translation updates instantly. No more outdated translated versions floating around.
Here is a handy cheat sheet of the most common language codes you can use with the Google Translate formula.
English | en |
Spanish | es |
French | fr |
German | de |
Italian | it |
Dutch | nl |
Arabic | ar |
Portuguese | pt |
To learn more about Google Sheets productivity features, book a live training session with Cloudshed.
