How to translate Google Sheets cells with AI (2026 guide)

Google Sheets has had =GOOGLETRANSLATE() since 2008. It still works — for short, simple phrases. For real production use (product descriptions, support replies, marketing copy), it's not enough. The output is robotic, doesn't preserve tone, and adds artifacts like alternates and romanization that you then have to strip.

This guide shows the AI-formula replacement. Cleaner output, any language, no glue code.

The one-line version

=AI_TRANSLATE(A2, "Spanish")

That's it. A2 is the source text. The second argument is the target language. The formula returns just the translation — no commentary, no romanization, no "also: alt phrasing".

Why AI translation beats =GOOGLETRANSLATE

• Tone preservation. Marketing copy that's warm in English stays warm in Spanish. =GOOGLETRANSLATE flattens tone aggressively.
• Context awareness. Polysemy ("bank", "charge") gets resolved based on surrounding sentences, not in isolation.
• Format preservation. Lists, line breaks, and inline punctuation survive. Older statistical MT mangles these.
• Instruction following. You can append "keep brand name unchanged" or "use formal address" and it actually listens.

Real examples

Specify a source language explicitly

=AI_TRANSLATE(A2, "English", "Korean")

Third argument is the source language. Useful when your column is in a language the auto-detector might fumble (Catalan vs Spanish, Bahasa Melayu vs Indonesia).

Add tone or formality constraints

=AI_TRANSLATE(A2, "French", "", "Use formal 'vous' address. Keep brand name 'Acme' unchanged.")

Fourth argument is free-form instructions. These bind the model harder than any system prompt you'd write manually.

Translate a column into many languages at once

# Row 2:
=AI_TRANSLATE($A2, "Spanish")  # B2
=AI_TRANSLATE($A2, "French")   # C2
=AI_TRANSLATE($A2, "German")   # D2
=AI_TRANSLATE($A2, "Japanese") # E2

Drag down. 1,000 products × 4 languages = 4,000 calls = ~$0.20 with Claude Haiku, the strongest translation model. Done in 25 minutes.

Which model to use

From our head-to-head comparison:

• Claude Haiku 4.5 — cleanest translation output. No alternates, no romanization. Best for high-stakes text (marketing, legal).
• Gemini 2.5 Flash — ⅓ the cost. Excellent on common language pairs. Good default for bulk product catalogs.
• GPT-4o mini — middle. Strong on European languages.

Set your default provider in gptsheet → Menu → API keys. You can override per-formula via the optional model parameter.

Language coverage

All three providers support 100+ languages. Practical sweet spots:

• European languages (Spanish, French, German, Italian, Portuguese, Dutch, Polish) — flawless.
• Asian languages (Japanese, Korean, Chinese, Thai, Vietnamese) — excellent.
• RTL languages (Arabic, Hebrew) — strong, but verify cell formatting renders correctly.
• Low-resource languages (Tamil, Swahili, Welsh) — good but worth spot-checking with a native speaker.

Bulk translation: the Bulk runner

Dragging =AI_TRANSLATE down 10,000 rows works, but Sheets will recalculate the entire column whenever anything else in the workbook changes. Sidebar → Bulk tab → set input range, prompt template ("Translate {value} to Spanish"), output start cell, Run. Results are written as static values, no recalc storms.

Cost

Average translation: ~250 input tokens (source text) + ~250 output tokens (translation). At Gemini Flash list prices:

• 1,000 translations — $0.10
• 10,000 translations — $1.00
• 100,000 translations — $10.00

One-time gptsheet license ($49) + your provider bill. No subscriptions, no per-call markup, no credit packs to refill. More on BYOK pricing here.