top of page
Search

How to Translate an Entire Column in Google Sheets in Seconds

  • Jun 4
  • 1 min read

Did you know Google Sheets has a translation tool built in? You can translate entire columns of text with a simple formula =GOOGLETRANSLATE.


It goes like this:


=GOOGLETRANSLATE(text,"source current language", Language to be changed to")


For example


=GOOGLETRANSLATE(E4,"en","es")


In this example, we are translating cell E4 from English to Spanish.


Spreadsheet showing a Notes header and a selected cell with =GOOGLETRANSLATE(E4, en, es) in blue.

When you write your formula and hit enter, you will get:


Google Sheets grid with a selected blank cell; row text reads Novedades en Google Workspace and Introducción a NotebookLM.

Top Tip: You can drag the formula down to translate the column.


Spreadsheet with Spanish course topics in rows, blue-highlighted cells, and text like Novedades en Google Workspace and Copiloto para EA

Here are some handy country codes (you can Google any codes you might need):


Language

Code

English

en

Spanish

es

French

fr

Janpanese

ja


We train people in countries all over the world. We find this feature really useful when scheduling and sharing session content.


Don't forget that Gemini in Google Sheets can help you write any formulas you are not sure of.


To learn more about Google Sheets book, CloudShed's live and interactive Google Sheets training sessions.


bottom of page