Analyze 46 million taxi rides in 4 seconds in Excel with DuckDB and Parquet files

Hi all! It's been 1 year since I published the free Excel add-in xlwings Lite in Excel's add-in store. I didn't have the time to work on it last year ever since I released it, but I am back now and in the first 2 months of this year, I (with Claude's help) have shipped more features than the whole Excel team in the last 2 years with their Python in Excel solution.

In my latest video I am using DuckDB together with Parquet files to analyze 46 million Yellow Cab taxi rides in just 4 seconds. It's a classic job for Power Query. But Power Query can't deal with Parquet files and uses M code that I personally just can't get used to. Which would be half as bad if they would add Copilot support to Power Query. In that light, the video also shows you the integration with xlwings Lite's AI assistant "Wingman", which can edit your Python code and explain the SQL query. Wingman works with OpenAI, Gemini, Claude, and your self-hosted models (bring your own API key). It also offers a drop-in replacement for your =COPILOT function. Happy to hear your thoughts!