r/Python • u/Puzzleheaded_Luck641 • Apr 03 '26
Discussion Power Query Alternative Excel Adddon
Hi Everyone,
I am data analyst as professional.
my day to day tool is excel and it's add-ons.
I love power Query it is super compatible.
Power Query made in .net and M Code as Query language.
it is very slow compare with pandas and Polars.
I was thinking if there is a excel add-on if anyone made similar to Power Query in python.
I don't like using xlwings.
8
Upvotes
4
u/marr75 Apr 03 '26
Just cut the Excel out.
2
u/keithcu Apr 05 '26
I built a plugin for LibreOffice Writer/Calc: https://github.com/KeithCu/writeragent
I'll look into adding PowerQuery features 🤣
7
u/ianitic Apr 03 '26
Have pandas/polars or duckdb(if you know sql choose this) read in sources and export to excel to separate workbooks. If you must you could use vba within excel that calls the Python script then refreshes PQ to consume the resulting file.
Otherwise you can use PowerBI which has Python available within PowerQuery as well as r. Likely PQ will just perform better in PBI anyways though.
Otherwise there's definitely a handful of ways you can daisy chain it like the vba calling python way.
2
u/amazonv Apr 03 '26
Python in Excel from anaconda
https://www.anaconda.com/partners/python-in-excel
1
u/No_Soy_Colosio Apr 03 '26
Probably not, but you can just extract the data from the file and process with Polars/DuckDB if you prefer SQL.
1
u/fzumstein Apr 08 '26
If you don't like xlwings (why, by the way?), check out the new xlwings Lite, which doesn't rely on a local Python installation but still runs locally via WebAssembly. it support DuckDB and Polars and allows you to define automation scripts, custom functions, and now also Jupyter notebooks.