The story of xlwings Lite is a direct challenge to the pace of innovation inside Microsoft's own ecosystem. In two months, a single developer, with help from an AI, shipped more features for Excel than the Excel team has delivered in two years with their Python integration. That is not a complaint about Microsoft; it is a signal about what is now possible when you separate progress from institutional momentum. The add-in is free, it works with DuckDB and Parquet files, and it just analyzed 46 million taxi rides in four seconds. Power Query cannot touch Parquet files, and its M code remains a barrier for anyone who does not want to learn a proprietary language. The gap is not technical. It is a gap in imagination.
What this means for you is straightforward: the tool that handles your biggest, messiest datasets no longer has to come from the company that built the spreadsheet. The add-in includes an AI assistant called Wingman that edits your Python code and explains SQL queries, and it works with OpenAI, Gemini, Claude, or your own self-hosted models. You bring your own API key, so there is no subscription lock-in. And if you have already started using Microsoft's Copilot function, Wingman offers a drop-in replacement. The practical effect is that you can now combine the familiarity of Excel with the speed of columnar file formats and the flexibility of Python, all without waiting for a roadmap update from Redmond.
The broader point is about ownership of your workflow. When a solo developer can outpace a product team by an order of magnitude, the bottleneck is no longer technology, it is permission. The Excel team has to ship features that work for hundreds of millions of users, which is a real constraint. But that constraint does not apply to you. You can adopt a solution today that does exactly what you need, even if it was built by one person and an LLM over a weekend. The video demonstrates a query against 46 million rows that completes in four seconds. That is not a future possibility. It is a current capability, available for free in the add-in store.
The lesson is not that Microsoft should move faster. It is that you should stop waiting. If you have been frustrated by the gap between what Excel can do and what your data requires, the answer is already here. Install the add-in, bring your own API key, and run a query that would have taken Power Query an hour, or not run at all. The four-second result is the only proof you need.