xlwings

With undisclosed usage limits, Python in Excel will never be more than a prototyping tool. That’s why I am working so hard on xlwings Lite. This is from a Reddit discussion: reddit.com/r/excel/commen… #xlwings #pythoninexcel #python #microsoftexcel

It’s been 5 years since my book came out, which means it’s time for an update! The 2nd edition is now available (unedited) on the O’Reilly Learning Platform: oreilly.com/library/view/p… Print versions will be available in early June and are already available for pre-order: amazon.com/Python-Excel-E… The 2nd edition includes three new chapters on Python in Excel and xlwings Lite. It also updates the stack: • uv instead of conda • Python 3.8 → 3.14 • pandas 1.0 → 3.0 There are also new sample cases featuring DuckDB, the OpenAI API, and Hugging Face.

xlwings Lite now has an App Mode 🚀 ! It enables you to quickly ship an Excel app to end-users who don't bother about how it works and who shouldn't change your Python code by accident. In App Mode, xlwings Lite hides the code editor and shows each script with an own button. It also renders the module and function docstrings in Markdown and shows a list of your custom functions. It's pretty powerful! #xlwings #python #microsoftexcel #pythoninexcel

Two things I don't like about Power Query: * It uses M code * It has no Copilot integration to write the M code for me But, I don't really care anymore because xlwings Lite + DuckDB is the new Super Power Query. In my latest video, I am analyzing 46 million records in 4 seconds with SQL. I also demo how Wingman can edit and explain the code. 👉 youtube.com/watch?v=vT0SDv… #pythoninexcel #xlwings #microsoftexcel #powerquery #duckdb

It's here 🚀! Wingman Chat is now available in xlwings Lite, in addition to the =WINGMAN() formula, and you can connect it with the latest models from OpenAI, Gemini, Claude (new!), and any other model that runs on https and supports CORS (bring your own API key). Compared to Copilot in Excel and Claude in Excel, xlwings Wingman does something fundamentally different: it creates Python code that you can inspect, iteratively improve, and run via button or as custom function. Unlike Copilot and Claude, you can reuse your deterministic functions across workbooks and rerun them as often as you need. They are 100% deterministic and 100% free. As with everything in xlwings Lite, this is early stage. Right now, Wingman does not have access to your data in Excel. Giving it optional access is on the roadmap.

RT @felixzumstein: Today I am launching =WINGMAN() 🚀 WINGMAN is a drop-in replacement for Microsoft's COPILOT function. It's part of the f…

Python in Excel without a Python REPL is like Excel without the formula bar. So I added one to xlwings Lite! #pythoninexcel #python #pyodide #xlwings #microsoftexcel

As you know, I’m on a mission to fix the many design flaws of Python in Excel, one by one. In that spirit, I am happy to announce that xlwings Lite now works with your local files! 🚀 Drag and drop files and folders straight into Excel. On Windows, you can even mount a local folder permanently with full read and write access. In one of my next posts, I’ll show you what crazy things this unlocks 👀

TL;DR: The xlwings video course is now free on YouTube 🚀 Back in 2018, I recorded a video course to help fund the development of xlwings. Today, the course is outdated and platform costs are bigger than the revenues. Instead of updating it, I decided to make it free for everyone. 👉 Watch the full xlwings course on YouTube: youtube.com/playlist?list=… #xlwings #python #pythoninexcel #youtube #course

Over the last 7 months, I was completely tied up. In 2026, I am back in building mode with two simple goals: * Fix Python in Excel: xlwings Lite already does that, but the plan is to make it 10x better. * Fix Copilot in Excel: Microsoft treats Copilot in Excel as a one off magic action. I think Copilot should work like a better macro recorder: create a script that you can iteratively tweak and reuse. After all, you are not building that financial model just once, are you? #pythoninexcel #python #microsoftexcel #copilot

My 2025 highlight was launching xlwings Lite at the end of March. It took me just 2 weeks from idea to mostly working. That's because of vibe coding and because most of the code is shared with xlwings Server. I still consider it a proof-of-concept as I didn't have time to work on it in the 2nd half of this year, but by now it feels like a very successful one: * 5,000 monthly users * 2 hardcore fans: @amarHarolikar and @ruudvanderham * Used in classes at @Columbia and @ColoradoStateU * A spike in “I think you’re onto something here” messages * Users publishing videos before I had even announced it publicly * 5 ⭐ rating by 38 users on Microsoft's marketplace. Keep them coming: marketplace.microsoft.com/en-us/product/… I am really looking forward to getting back to xlwings Lite in 2026 🚀

xlwings is a relatively popular solution amongst actuaries. That's why I was invited to speak at the Actuarial Technology Summit, a virtual conference happening next week on December 11! For a 25% discount, use the following code: a84mc67d My talk has the title "Why I Built xlwings: A Different Take on Python in Excel" and if you're an actuary, I'd be happy to see you online :)! 👉 fullstackactuarial.com

I need your help! I'm building xlwings Lite as a solo indie hacker with zero marketing budget. What I do have is an amazing and growing community of users. If xlwings Lite has helped you, it would mean a lot to me if you left a quick review in the add in store 🙏 🙏 🙏 ! 👉 appsource.microsoft.com/en-us/product/…

PSA: Every add-in from Excel's add-in store is down, including xlwings Lite. Apparently, it's a global Azure outage that also affects Heathrow, NatWest and Minecraft. This doesn't affect self-hosted versions of xlwings Lite, by the way... bbc.com/news/articles/…

RT @felixzumstein: This didn’t age well. Two years after this tweet, I’ve closed my first 5-figure, multi-year contract for xlwings Server…

Polars is on a roll! 🚀 @RitchieVink , the creator of Polars recently announced Polars Cloud and now @DataPolars landed in Excel too! @SvenBosau made a great video showing how to create custom functions and scripts in Excel without installing Python: youtube.com/watch?v=5RYM_4… New to Polars? Think of it as a modern take on pandas, but faster, more memory-efficient, and able to handle datasets larger than your RAM. #polars #pythoninexcel #xlwings #python #dataframe

After @turnleafan, @CountryRisk_io is now the 2nd data provider (that I know of) to make their data feed available through xlwings Lite! More power to Excel users! 🔥 🚀 👉 countryrisk.io/blog/countryda… #xlwings #pythoninexcel #python #microsoftexcel

Using Polars with Python in Excel shouldn't be any harder than this! And yes, xlwings does have a Polars converter since a couple of months... #xlwings #polars #dataframes #pythoninexcel #python #microsoftexcel @DataPolars

This is ridiculous and fun at the same time! xlwings Lite can help out Python in Excel by autogenerating Python in Excel code. But let's start at the beginning: You just got a workbook with one sheet of data per team. There are 50 teams in your company, so 50 sheets. You need to analyze/clean the data and you want to do this using Python in Excel. First step: create a DataFrame of all the sheets. Here's the thing: you need to use the xl() formula 50 times as you can't use any variables in it. That's a lot of work, so instead, you can use a bit of xlwings Lite magic to autogenerate that PY cell for you. After reading @DaveOnData daily praise of Excel's Copilot, I would have expected it to be able to create the Python cell for me, but it ended up hallucinating (it used the xl function in a loop). Get the code here: github.com/xlwings/xlwing… #xlwings #pythoninexcel #python #microsoftexcel

Here's a new banger video by AIgineer demoing how xlwings Lite can create beautiful dashboards with matplotlib/seaborn and @duckdb (I keep hearing about DuckDB left and right these days). 👉 youtu.be/83iMf1MSRLk?si… #xlwings #python #pythoninexcel #microsoftexcel