Translate Any List of Words Instantly in Google Sheets
![Google-Translate-Different-Alphabet](https://i0.wp.com/edtechpicks.org/wp-content/uploads/2019/07/Google-Translate-Different-Alphabet.png?resize=261%2C290&ssl=1)
More than a great tool for foreign language teachers, it’s a must-have resource for nearly all educators, especially since most of us teach ELL, ESL, ESOL students. Enter words in one column and use a simple formula to translate them to a different language in another column. It will even use the correct letters when translating to languages with different alphabets.
How To Translate a Word
- Select the cell where you want the word to appear.
- Type the following formula:
- =googletranslate(original word location,”original language code”,”translated language code”)
![Google Translate Formula](https://i0.wp.com/edtechpicks.org/wp-content/uploads/2019/07/Google-Translate-Formula-Sheets.png?resize=640%2C423&ssl=1)
=googletranslate(A2,”en”,”es”)
![How to Translate Google Sheets](https://i0.wp.com/edtechpicks.org/wp-content/uploads/2019/07/Google-Translate.gif?resize=640%2C360&ssl=1)
Translate an Entire Column
Thankfully you don’t need to type the formula for each row.
- Select the cell that contains your formula.
- Click and drag the blue box (“fill handle”) in the bottom right corner of the cell.
- Continue dragging the fill handle down to all rows you want to be translated.
![Google Translate Formula Bulk Fill](https://i0.wp.com/edtechpicks.org/wp-content/uploads/2019/07/Google-Translate-Bulk-Fill.png?resize=640%2C273&ssl=1)
Translate into over 100 Languages
You can find the codes for all languages supported by Google Translate in this list: https://cloud.google.com/translate/docs/languages
![Translate into over 100 Languages](https://i0.wp.com/edtechpicks.org/wp-content/uploads/2019/07/Translate-into-over-100-Languages.png?resize=640%2C480&ssl=1)
Don't Miss a Pick - Follow Us
![Follow us on Facebook Facebook](https://i0.wp.com/edtechpicks.org/wp-content/plugins/social-media-feather/synved-social/image/social/regular/96x96/facebook.png?resize=48%2C48&ssl=1)
![Follow Nick on Twitter twitter](https://i0.wp.com/edtechpicks.org/wp-content/plugins/social-media-feather/synved-social/image/social/regular/96x96/twitter.png?resize=48%2C48&ssl=1)
![Our board on Pinterest pinterest](https://i0.wp.com/edtechpicks.org/wp-content/plugins/social-media-feather/synved-social/image/social/regular/96x96/pinterest.png?resize=48%2C48&ssl=1)
![Find us on YouTube youtube](https://i0.wp.com/edtechpicks.org/wp-content/plugins/social-media-feather/synved-social/image/social/regular/96x96/youtube.png?resize=48%2C48&ssl=1)
![Check out our Instagram feed. instagram](https://i0.wp.com/edtechpicks.org/wp-content/plugins/social-media-feather/synved-social/image/social/regular/96x96/instagram.png?resize=48%2C48&ssl=1)
![Join our Email List mail](https://i0.wp.com/edtechpicks.org/wp-content/plugins/social-media-feather/synved-social/image/social/regular/96x96/mail.png?resize=48%2C48&ssl=1)