xlwings Lite now ships with Python 3.14 (that's the latest one) and pandas 3.0 (in comparison, Python in Excel is on Python 3.12 with pandas 2.2). It's currently opt-in (Settings > Workbook), but will become the default for *new* workbooks over the next days. Existing workbooks run against the Python version they were created with, unless you make the switch manually. This was possible due to yesterday's Pyodide 314.0.0 release, the WebAssembly-based Python distro that powers xlwings Lite. Besides upgrading Python, it also starts an exciting new era where Pyodide packages (i.e., wheels), can now be uploaded to PyPI.org, just like normal Python wheels. #pythoninexcel #pyodide #webassembly #python #microsoftexcel

xlwings Lite now supports streaming functions! The docs include a sample about how to stream live BTC prices: lite.xlwings.org/custom_func… Enjoy! #xlwings #pythoninexcel #python #microsoftexcel

xlwings Lite notebooks now support Plotly plots 🔥 This is perfect for exploratory data analysis as you can zoom in, deselect categories, and get additional information in tooltips on hover. 👉 Install xlwings Lite for free from the Microsoft Marketplace: marketplace.microsoft.com/en… @plotlygraphs #xlwings #plotly #microsoftexcel #pythoninexcel

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/comments/… #xlwings #pythoninexcel #python #microsoftexcel

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=vT0SDvgQ… #pythoninexcel #xlwings #microsoftexcel #powerquery #duckdb

Today I am launching =WINGMAN() 🚀 WINGMAN is a drop-in replacement for Microsoft's COPILOT function. It's part of the free xlwings Lite add-in and works with your existing API key for OpenAI, Gemini, and other OpenAI API compatible providers. While the COPILOT function is occasionally useful, I don't want to spend another $20/month when I can have a GEMINI-powered function for free. Install xlwings Lite from here (while you're there, feel free to leave a review!): marketplace.microsoft.com/en… #AI #Copilot #PythonInExcel #microsoftexcel

VBAとPython in Excel、どっちを使えばいい？🤔 結論：賢く使い分けるのが正解！「自動化・連携のVBA」と「分析・予測のPython」の役割分担を分かりやすく解説します。 #PythoninExcel #VBA #データ分析 #note #note初心者 note.com/kenta_1932/n/n8ba31…

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

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=PL… #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

🐍 Mac users, this one's for you. Editable initialization for Python in Excel is now live. Set your imports, preload libraries, and tailor your environment. Details: msft.it/6012tnyje #PythoninExcel #MicrosoftExcel #ExcelforMac

🐍 Python in Excel update: Editable initialization is now available on Mac as well as Windows. Customize your imports, preload libraries, and streamline your setup. 🔗 msft.it/6015tT6MB #PythoninExcel #MicrosoftExcel #ExcelforMac

You can now run Python directly in Excel — no setup, no add-ins! Type your Python code right in the formula bar & see instant results. To watch click 👉youtu.be/ZC9nnO5-2FQ #PythonInExcel #ExcelTips #Microsoft365 #DataScience #Productivity #ExcelUpdate #Automation

⚡ICYMI in October: Python in Excel for Windows now supports editable initialization. Set up your environment your way with custom imports and defaults. msft.it/6012tHCF8 🐍 #PythoninExcel #MicrosoftExcel

🐍 ICYMI: Python in Excel is now more flexible than ever. Edit default initialization so every workbook starts your way. Get the specs in our blog. msft.it/6012sfXze #PythoninExcel #MicrosoftExcel

📊 Editable initialization is live for Python in Excel for Windows. View and edit code, add your own imports, and save changes that travel with your workbook. 🐍 msft.it/6011sLWnL #PythoninExcel #MicrosoftExcel

📊 Python in Excel just got more flexible with editable initialization. Whether you're a data scientist, analyst, or developer, this unlocks a new level of productivity in your Python workflows. msft.it/6012sahEs #MicrosoftExcel #PythoninExcel

🐍 Big news for Python in Excel users! You can now edit the default initialization, allowing you to tailor imports, defaults, and configurations to fit your workflow. Get the specs in our new blog. msft.it/6011sadgt #MicrosoftExcel #PythoninExcel

This didn’t age well. Two years after this tweet, I’ve closed my first 5-figure, multi-year contract for xlwings Server. Here’s how you can win as a solo developer against the combined power of @Microsoft and @anacondainc: * Solve the real problem. The most-upvoted feature request for Excel was about Python as a VBA replacement, not turning sheets into Jupyter notebooks. * Listen to active users. xlwings has ~2,000 GitHub issues where *real* users say what they need. Microsoft showed mockups to *potential* users and asked for a rating from 1-10. * Enterprise features matter. Air-gapped self-hosting, Azure & AWS support, SSO, authorization, and access to internal databases. * Support all packages. Enterprises need *their* versions of *their* libraries. * No #BLOCKED! errors, please. * Be cheaper. The Python in Excel add-on is $24,000 per 100 users/year. * Respond to GitHub issues. Microsoft has not responded to any Python in Excel issues on GitHub for over a year. #pythoninexcel #python #xlwings #microsoftexcel