How to Translate a Column of Cells in Excel (AI, Privacy-Safe)
Excel has no way to translate a whole column at once — the Translate pane does one cell at a time, and GOOGLETRANSLATE only exists in Google Sheets. Here's the one-click way that translates the column with your own AI key, without pasting your data into a website.
Last updated: August 2026
| English | Spanish (new column) | |
|---|---|---|
| Thank you | → | Gracias |
| Out of stock | → | Agotado |
| Order shipped | → | Pedido enviado |
Why Excel makes this hard
Excel's Review ▸ Translate pane translates one selection into a side panel — fine for a phrase, useless for a column of 500 cells. GOOGLETRANSLATE() is a Google Sheets function with no Excel equivalent. So people either translate cell by cell, or paste the whole column into an online translator — which means handing business data to a third-party website.
The 1-click way — Tellsheet's AI Translate
Select the column and run AI Translate. Pick a language and it translates every cell using your own Anthropic API key — only the selected text is sent, there's no Tellsheet backend, and nothing is stored. The result is written to a new column beside the source, so the original stays for reference; blank and non-text cells pass through untouched. The privacy-safe alternative to pasting data into a translation site. Pairs with Remove Accents and Change Case.
Frequently asked questions
Is there an Excel translate function?
No bulk one — GOOGLETRANSLATE is Sheets-only. AI Translate does the whole column and writes a new column.
Where does my data go?
Only the selected text, only to Anthropic under your own key. No backend, nothing stored.
Do I keep the original?
Yes — the translation lands in a new column beside it.
What about blanks and numbers?
They're passed through unchanged — only real text is translated.
Related Excel guides
Translate a column in one click
AI Translate turns a column into any language with your own AI key — only the text is sent — and keeps the original beside it.
Get Tellsheet free See pricing