Write Excel Add-Ins
in Python
Use Microsoft Excel as a user friendly front-end to your Python code. No VBA, just Python!
PyXLL, the Python Add-in for Microsoft Excel
Python, fully integrated into Excel - that's PyXLL!
Use Excel as the front-end user interface to your Python applications and toolkits.
See features for just some of what PyXLL can do.
Python applications, in Excel
Put your Python tools into the hands of Excel users.
Business users spend their days in Excel so why spend time and money building another custom user interface?
Create rich spreadsheets combining your Python code with all the features of Excel.
I used to copy and paste data from different systems into one spreadsheet. It was a nightmare keeping track of where the data came from and many calculations happened off-sheet in other systems.
Now I use the Python add-in written by our quants directly from Excel. I always know I'm working with the right data and can access all our models.
Risk Manager – New York
Bring your own Python
No cloud dependencies, use your own local Python environment and packages. No code or data leaves your PC.
Compatible with your existing Python packages, including compiled C extensions such as numpy, scipy pandas and polars. It's your Python environment so you can install anything you like!
Leverage the full Python ecosystem as well as packages you've already written to deliver functionality in Excel quickly.
We had already been using Python for a long time at my firm and I was amazed at how easy it was to get started with PyXLL.
The fact it uses our existing Python environment was a massive win for us. All of our existing packages worked, including C extensions developed by our quants.
Having our own in-house Python tools available directly in Excel has been an absolute game changer!
Desk Analyst – New York
Deploy to the whole team
Build powerful Excel tools using Python for your whole team, without any VBA.
The end Excel users don't need to know Python to use your add-in!
Automate the deployment and updates to your end users so they don't need to worry about installing anything.
I love how quick it is to get from ideas to code in Python!
Our analytics are written in Python and we rely on them for our trading. With PyXLL, they're available as an Excel add-in and the traders have the tools they need in a way that works for them.
They don't need to care that it's written in Python, they just care that its our analytics in Excel.
Quant Developer – London
Develop using best practices
You can keep your code in a version control system, no code needs to be saved in Excel.
Your Python code runs in Excel, but it's not limited to only be in Excel. Test, debug and re-use your code outside of Excel.
Use your favorite Python IDE, version control system, and testing frameworks!
For me, Excel development used to mean looking over a user's shoulder, hacking VBA, and never knowing what would break next.
We rewrote our legacy VBA code in Python which gave us huge benefits, but our users love Excel and wouldn't give it up.
PyXLL made it easy to expose our Python code to Excel as an add-in.
Now our workbooks are super-reliable, way faster, and do much much more than before!
Senior Python Developer – London
Featured Blog Posts
Request a demo
Book a demo session and let us show you what PyXLL can do for you!