Using Google Translate in Google Sheet [2024]

By Geoff Griffiths @mmatraining1980

With my copy in column B, starting in cell B2, and with the language short codes “en” for the original language and “no” for Norwegian – what I want to translate the English into, in cells E1 and F1 respectively, the code I place in cell D2 is:
=GOOGLETRANSLATE(B2,$E$1,$F$1)

I can drag the formula down to translate all the English in column B.

That’s it really

By the way – if you have a site that’s randomly in 2 languages, or more – you can use detect language Google Sheets function

=DETECTLANGUAGE(“cellnumber”)