Translate in Sheets

Last week I watched my coworker cut and paste responses from a spreadsheet to Google Translate and back again. It seemed like a tedious process that I knew had to have an easier solution. And if there wasn't, I thought that could be a solution an extension or addon could solve.

A Google Search away, I found that Google Sheets has a TRANSLATE forula built in. I remember hearing about it a few years ago, but I forgot about it until now.

The Documentation from Google is here.

The basic idea is this:

GOOGLETRANSLATE(text, [source_language, target_language])