Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
GOOGLETRANSLATE
GOOGLETRANSLATE sends cell text to Google Translate and returns the translated string in the target language. You can specify source and target languages using BCP-47 codes, or use "auto" to let Google detect the source language automatically. It is ideal for localizing product descriptions, support tickets, or survey responses at scale.
Excel
=GOOGLETRANSLATE(A2,"auto","es")Google Sheets
=GOOGLETRANSLATE(A2,"auto","es")Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Reference the cell containing the text to translate as the first argument.
- 2Provide the source language code (e.g., "en") or "auto" to let Google detect it automatically.
- 3Specify the target language code as the third argument (e.g., "fr" for French, "de" for German).
Need a version for your data?
Try: “Translate a column of English product descriptions into Spanish automatically”