Google Sheets · GOOGLETRANSLATE
Google Sheets translates for you
Translates any cell between 100+ languages. Google Sheets only.
The formula
=GOOGLETRANSLATE(A2, "en", "es")What each part means
A2The text"en"From English"es"To Spanish
Example
| A | B | |
|---|---|---|
| 1 | English | Spanish |
| 2 | Thank you for your order | |
| 3 | Your invoice is ready | |
| 4 | See you tomorrow |
| A | B | |
|---|---|---|
| 1 | English | Spanish |
| 2 | Thank you for your order | Gracias por su pedido |
| 3 | Your invoice is ready | Su factura está lista |
| 4 | See you tomorrow | Hasta mañana |
Step by step
- Click cell B2.
- Type the formula:
=GOOGLETRANSLATE(A2, "en", "es") - Press Enter.
- Drag the small square in the bottom-right corner of the cell down to copy it to the other rows.
Where it works
- Google Sheets (free)
- Not available in Excel
- Works on phone and computer
The same formula in other languages
- English GOOGLETRANSLATE
- Español GOOGLETRANSLATE
- Português GOOGLETRANSLATE