Translate with Google Sheets

Why translating with Google Sheets

Google Translate is an amazing feat of engineering, which uses artificial intelligence to translate speech and text from a chosen language into another. In most cases, Google Translate’s own interface embedded in Google Search or on translate.google.com suffices to get some ad-hoc thing translated quickly.

But in some cases, you want something more powerful and scalable to be able to translate in bulk. For coders, there’s the Translation API for instance. But what if you’re less technical, and still want to use Google Translate in a structured, more scalable environment?

Again, as in other Case Studies presented here, Google Sheets comes to the rescue!

Registered members will see more and get their free file.

The simple formula to translate something within Google Sheets is as follows:

=GOOGLETRANSLATE(B16, “en”, “fr”)

  • Here, the ‘B16’ part concerns the reference to the cell containing the text you want to translate.
  • After that, you add the source language — the language in which the original text is written — using the language’s abbreviation.
  • After that, you declare the target language — the language to which the source text has to be translated — again using that language’s abbreviation.

This content is locked

Login To Unlock The Content!

Access the file FOR FREE: