×

6
7

DiscussionPower Query Alternative Excel Adddon (self.Python)

submitted by Puzzleheaded_Luck641

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.

all 12 comments
sorted by:
best
topnewcontroversialoldq&a

[–]ianitic 6 points7 points  (0 children)

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.

[–]marr75 3 points4 points  (1 child)

Just cut the Excel out.

[–]keithcu 1 point2 points  (3 children)

I built a plugin for LibreOffice Writer/Calc: https://github.com/KeithCu/writeragent

I'll look into adding PowerQuery features 🤣

More comments

More from r/Python

  Hide

101
102

DiscussionWhy doesn’t Python have true private variables like Java? (self.Python)

submitted by PalpitationOk839

62
63

DiscussionSQLalchemy vs Psycopg3 (self.Python)

submitted by aronzskv

58
59

DiscussionBuilding a Python Library in 2026 (self.Python)

submitted by funkdefied

26
27

NewsPyTexas 2026 is this weekend (Apr 18th-19th) at Austin's beautiful central library. (self.Python)

submitted by AlSweigartAuthor of "Automate the Boring Stuff"

13
14

DiscussionBuilding a web game (self.Python)

submitted by BigTimberFGC

12
13

ResourcePDF Extractor (OCR/selectable text) (self.Python)

submitted by qPandx

7
8

Daily ThreadSunday Daily Thread: What's everyone working on this week? (self.Python)

submitted by AutoModerator[M] - announcement

7
8

Daily ThreadTuesday Daily Thread: Advanced questions (self.Python)

submitted by AutoModerator[M]

6
7

Daily ThreadSaturday Daily Thread: Resource Request and Sharing! Daily Thread (self.Python)

submitted by AutoModerator

5
6

DiscussionQuestion about posting rules (showcases) (self.Python)

submitted by KennedyRichard

Comments, continued...

[–]amazonv 1 point2 points  (1 child)

Python in Excel from anaconda

https://www.anaconda.com/partners/python-in-excel

[–]Puzzleheaded_Luck641[S] 0 points1 point  (0 children)

Python is Also available excel native but external Data or operation doesn't work. Performance is super super slow. Because it's send the data to Microsoft server

[–]No_Soy_Colosio 0 points1 point  (0 children)

Probably not, but you can just extract the data from the file and process with Polars/DuckDB if you prefer SQL.

[–]Meathixdubs 0 points1 point  (0 children)

I tried forcing Excel to be the center of everything for way too long and it just got messy.

DuckDB ended up feeling way cleaner for me, especially if you’re already semi-comfortable with SQL. Less fighting the tool, more just getting stuff done.

[–]fzumstein 0 points1 point  (0 children)

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.