Google Sheets Has a Built-In Translator — One Formula Translates Thousands of Cells
=GOOGLETRANSLATE() turns any spreadsheet into a translation machine. Product catalogs, survey answers, contact lists — translated in seconds, for free.
01. What It Is
Google Sheets ships with a function called GOOGLETRANSLATE that connects directly to Google Translate. Point it at a cell, give it a source and target language, and it returns the translation — live, inside the spreadsheet. Drag the formula down a column and a thousand rows translate themselves.
Its companion, DETECTLANGUAGE, identifies what language a cell is written in, so you can build sheets that handle mixed-language data automatically — for example, translating only the rows that aren't already in English.
Why It Matters
Translating data — not documents — is awkward with normal tools: copy-pasting hundreds of cells into a translator and back is error-prone misery. Doing it where the data already lives, with a formula anyone can copy, removes the entire workflow.
Who Can Benefit
- E-commerce sellers localizing product catalogs
- Researchers handling multilingual survey responses
- Support teams reviewing customer feedback from multiple countries
- Anyone running a bilingual business — like an English/Spanish audience
02. Step-by-Step Guide
- 1
Put your text in a column
Open a Google Sheet and place the text to translate in column A, one item per row.
- 2
Write the formula
In cell B1, type: =GOOGLETRANSLATE(A1, "en", "es") — this translates English to Spanish. Use two-letter ISO codes for any language pair.
- 3
Auto-detect the source
Don't know the source language? Use "auto": =GOOGLETRANSLATE(A1, "auto", "en").
- 4
Drag to translate everything
Grab the small square at the cell's corner and drag down. Every row translates — a 2,000-row catalog takes seconds.
- 5
Freeze the results
When done, select column B, copy, and use Edit → Paste special → Values only. This replaces live formulas with static text so translations don't re-fetch on every load.
Pro Tips
- Combine with DETECTLANGUAGE: =IF(DETECTLANGUAGE(A1)="en", A1, GOOGLETRANSLATE(A1,"auto","en")) only translates what needs it.
- Add columns for several target languages and translate your catalog into five markets at once.
- For business-critical copy, use this as a first draft and have a native speaker review.
Warnings & Limitations
- It's machine translation — fine for data and drafts, not for legal text or polished marketing copy.
- Very large sheets with live formulas can load slowly; paste as values when finished.
Related Tricks
This ChatGPT Trick Can Turn Any Photo Into a Reusable Template
Upload one image, extract its exact style as a written 'style recipe', and reuse it forever to generate consistent visuals on demand.
Most iPhone Users Don’t Know Their Phone Has a Secret Invisible Button
Your iPhone's back panel is a hidden button. Double or triple tap it to take screenshots, launch the camera, run Shortcuts — anything you want.
Google Docs Has a Free Transcription Engine Hiding Behind One Menu Item
Voice Typing in Google Docs turns speech into text in real time, in dozens of languages, for free — and most people walk past it every day.