How to translate one word into all the foreign languages

Is there an online resource to translate a word into all foreign languages? You could manually look up a word in Google Translate. But don’t you want an online dictionary that can translate in all languages?

Good news. Google Sheets has a function for Google Translate! You can set up a sheet with a function for each language and then have it automatically translate one word into all languages.

In cell A1, put your single word/phrase in English. In cell B1, enter the following:
=GoogleTranslate(A1, “en”, “fr”) 

That “fr” part does the translation for French. For the other 90 languages in Google Translate, here are the codes:

af: Afrikaans
sq: Albanian
ar: Arabic
hy: Armenian
az: Azerbaijani
eu: Basque
be: Belarusian
bn: Bengali
bs: Bosnian
bg: Bulgarian
ca: Catalan
ceb: Cebuano
ny: Chichewa
zh-CN: Chinese
hr: Croatian
cs: Czech
da: Danish
nl: Dutch
en: English
eo: Esperanto
et: Estonian
tl: Filipino
fi: Finnish
fr: French
gl: Galician
ka: Georgian
de: German
el: Greek
gu: Gujarati
ht: Haitian Creole
ha: Hausa
iw: Hebrew
hi: Hindi
hmn: Hmong
hu: Hungarian
is: Icelandic
ig: Igbo
id: Indonesian
ga: Irish
it: Italian
ja: Japanese
jw: Javanese
kn: Kannada
kk: Kazakh
km: Khmer
ko: Korean
lo: Lao
la: Latin
lv: Latvian
lt: Lithuanian
mk: Macedonian
mg: Malagasy
ms: Malay
ml: Malayalam
mt: Maltese
mi: Maori
mr: Marathi
mn: Mongolian
my: Myanmar (Burmese)
ne: Nepali
no: Norwegian
fa: Persian
pl: Polish
pt: Portuguese
pa: Punjabi
ro: Romanian
ru: Russian
sr: Serbian
st: Sesotho
si: Sinhala
sk: Slovak
sl: Slovenian
so: Somali
es: Spanish
su: Sundanese
sw: Swahili
sv: Swedish
tg: Tajik
ta: Tamil
te: Telugu
th: Thai
tr: Turkish
uk: Ukrainian
ur: Urdu
uz: Uzbek
vi: Vietnamese
cy: Welsh
yi: Yiddish
yo: Yoruba
zu: Zulu

When you have a spreadsheet that can automatically do translations like that, you can make blog posts like, “How to say “honeymoon” in 65 languages.

Infographic listing 65 translations of “honeymoon”

How will you use the Google Translate function in Google Sheets?

Enjoyed this blog post?

Join the creatives who receive thoughtful Matt Maldre blog posts via the email newsletter
(Whenever it posts. Around 1-2 times per month)

1 thought on “How to translate one word into all the foreign languages”

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.