Translation function in Excel


Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

Can you call a Translation service to return results in Excel?

After checking out the clever European word translator, we started wondering about loading translations into Excel.   It should be simple to have some code to call a web server and return a translation of a word.

Office 2010 and Office 2013 have a ‘mini translator’ feature in the Research pane but that has to be done manually. 

We’re looking for an automated approach, ideally a function like Translate(“English”, “Turkish”,”My Hovercraft is full of eels”).  

It’s not an unreasonable ask for Excel since its main rival, Google Docs, has been able to do it since 2009 with the function GoogleTranslate(“text”, “source language”,”target language”) which can translate words, phrases and sentences.

Sadly, Microsoft hasn’t put a similar function into Excel.

We found an add-in Google Translate for Excel which also supports the Bing Translate service.   Aside from the price of $39, you also have to pay for API access to Google Translate.

For occasional use, you might want to make a Google Docs worksheet and copy the results from there to Excel.

subs profile e1563205311409 - Translation function in Excel
Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address