Build an Excel Language Translator Using Power Query (No API Key | Free Google Translate Method)

Learn how to build a fully automated Excel translation tool using Power Query and Google Translate - with no API key required.

Users simply select the input language, output language, and type any text they want to translate.
Perfect for business workflows, customer support, localization, or multilingual reporting.

We’ll cover:
✔ Setting up the translation table
✔ Creating a language picker using ISO language names
✔ Writing the Power Query script
✔ Calling Google Translate in Excel
✔ Adding a one-click VBA refresh button

Get ISO Language table: https://tinyl.co/3zyY

⬇️ Download free Excel Workbook and M Code: https://tinyl.co/3zDz

VBA Macro Code:
Sub RefreshTranslation()
ThisWorkbook.Connections("Query - TranslationTable").Refresh
End Sub

Don't forget to save your file as Excel Macro-Enabled Workbook

#PowerQuery #ExcelAutomation #GoogleTranslate #TranslateInExcel
#AdvancedExcel #ExcelForBusiness #DataAutomation

Видео Build an Excel Language Translator Using Power Query (No API Key | Free Google Translate Method) канала EZ Excel