Live SEO tests

Easier functions in Google sheets, part 2 (SEO experiment)

By May 7, 2019 No Comments

3) Translation – No equivalent in Excel

Yes, you saw that right. Google spreadsheets come with the handy Googletranslate() function which allows you to bulk translate text from one language to another using the Google Translation service. The function itself needs three arguments : (input text, language from, language to). But but I don’t know what language I’m translating from!? No problem, Google docs has a cool function that can do that for you too, it’s called Detectlanguage().

Have a play around in the sheet to see what’s going on.

Still to come….

  • More fun with arrayformula()
  • Splitting, concatenation, transposing
  • SORT

If you know of any other functions / methods you find easier to use in Google docs, please share them in the comments or contact me directly so I can add it to the post.  I’ll happily link to you, so please contribute 🙂


Author Dave

More posts by Dave
Comprar Seguidores No Instagram