Translate texts in Excel

[kyhm97]

Hi

I'm trying to find a way to automatically translate texts in Excel, but none of the functions I have found work.
The company where I work seems to have many security levels so that's why I have limited options. I already tried the following ones:
*Add-ins-> Blocked by the company
*Google sheets-> Blocked by the company
*Power Query in Excel-> The company didn't allow some connection I should make with the translator tool
*I'm currently trying with Power Automate, but it needs some connection with Azure, which is also blocked by the company

I'm wondering if there is any other option I could try. Do you know any other? :S

Thank you for your support
Best regards!

 

[rlv01]

3rd party translation is a security risk. When you use an external translation service (google translate or other) you send them text and they send back the translated text. They keep the text you sent. If the text you send them contains propriety information or personal information covered by various laws such as the EU's GDPR then you are potentially exposing your employer to intellectual property loss and/or legal liability. It seems like your company has gone to some effort to lock down that risk. Are you sure you want to undermine that? You should probably talk to your IT department to find out if they have an authorized service and use that.

 

[John_w]

Are you allowed to use Google Translate?

This code is a UDF which translates text using https://translate.google.com/.

Google Translate Macro Function - How to rafear to Cell and/or Text in Quotes?

Hello experts, i modify actual script to create a function in Excel to translate from Google Translator with formula. In order to work, you need to add Reference "Microsoft Internet Controls" (Tools>References) I create it referring to a cell range value with syntax...

www.mrexcel.com