About PyXLL
PyXLL is an Excel add-in that allows developers to write Excel functions, macros, and menus in Python.
PyXLL is an Excel add-in that enables developers to integrate Python code directly into Microsoft Excel, replacing the need for VBA. It allows for the creation of custom worksheet functions (UDFs), macros, and user interface elements like ribbon toolbars and task panes, all written in Python. This facilitates the use of powerful Python libraries such as Pandas, NumPy, and Matplotlib for complex data analysis, modeling, and visualization within the familiar Excel environment. The software supports real-time data streaming and asynchronous functions to build dynamic, high-performance dashboards. PyXLL offers a 30-day free trial, with paid plans available on a monthly or annual subscription basis. Support is provided through documentation, videos, and a contact form.
Pros & Cons
- Integrates Python seamlessly into Excel, replacing the need for VBA.
- Allows use of powerful Python data science libraries like Pandas and NumPy directly in spreadsheets.
- Supports real-time data streaming for live, auto-updating dashboards.
- Enables creation of custom user interface elements like ribbons and task panes.
- Code can be developed and debugged in standard Python IDEs with automatic reloading.
- Limited compatibility with older versions of Excel
- Steep learning curve for users unfamiliar with Python
- Relatively high cost compared to other Excel add-ins
- Limited customer support resources available
- Lack of advanced features compared to other similar tools
Features
Key features
Write Excel User Defined Functions (UDFs), macros, and menus using Python instead of VBA.
Stream live data into spreadsheets from Python sources for auto-updating dashboards.
Create custom ribbon toolbars, context menus, and task panes to build intuitive user interfaces within Excel.
Optimized for use with numerical packages like NumPy, Pandas, and Polars for fast data processing.
Pass Python objects between worksheet functions without serializing them, improving performance and simplifying workbooks.
Additional features
Write non-blocking functions that can perform long-running tasks without freezing Excel.
Use Python plotting libraries like Matplotlib, Plotly, and Bokeh to create data visualizations within Excel.
Full support for Excel's dynamic arrays, allowing Python functions to return variable-sized results.
Supports debugging in standard Python IDEs and features automatic code reloading without restarting Excel.
Provides full access to the Excel Object Model, allowing for complete automation of Excel from Python.
Pricing
Monthly plans
- Billed monthly, cancel anytime
- Perfect for individual users
- No long term commitment
- Add more users at any time
- Updates and support included
Annual plans
- Best pricing for teams
- Discounts for multi-user licenses
- Add more users at any time
- Updates and support included
Billed annually as $349/user/year. Equivalent to $30/user/month.
Source: vendor pricing page →Countries & Languages
Interface languages
Billing currencies
No reviews yet
Be the first to drop a review
Alternatives to PyXLL
ChemStat
ChemStat is a statistical analysis software for environmental data, designed for Windows. It helps analyze…
GRID Spreadsheet Engine
GRID Spreadsheet Engine is a spreadsheet software from GRID that provides a modern spreadsheet use…
DewesoftX
DewesoftX is a data acquisition software from Dewesoft that provides comprehensive test and measurement monitoring…
DataFi Analytics Dashboard
DataFi Analytics Dashboard is a data management platform from DataFi that provides a unified interface…
Spot something wrong or outdated?
Suggest a correction — a reviewer verifies every change.
About PyXLL
PyXLL is an Excel add-in that allows developers to write Excel functions, macros, and menus in Python.
PyXLL Details
PyXLL's In-App Market Place
Does PyXLL have an in-app market place?
Yes
How many Mini-Apps in the marketplace?
0
Mini Apps
Pricing Options
Plans
Monthly plans
- Billed monthly, cancel anytime
- Perfect for individual users
- No long term commitment
- Add more users at any time
- Updates and support included
Annual plans
- Best pricing for teams
- Discounts for multi-user licenses
- Add more users at any time
- Updates and support included
Billed annually as $349/user/year. Equivalent to $30/user/month.
Source: vendor pricing page →Accepted Payment Currencies
USD, EUR, GBP
Pros & Cons
- Integrates Python seamlessly into Excel, replacing the need for VBA.
- Allows use of powerful Python data science libraries like Pandas and NumPy directly in spreadsheets.
- Supports real-time data streaming for live, auto-updating dashboards.
- Enables creation of custom user interface elements like ribbons and task panes.
- Code can be developed and debugged in standard Python IDEs with automatic reloading.
- Limited compatibility with older versions of Excel
- Steep learning curve for users unfamiliar with Python
- Relatively high cost compared to other Excel add-ins
- Limited customer support resources available
- Lack of advanced features compared to other similar tools
PyXLL's Support Options
Email Address
support@pyxll.comDocumentation
https://www.pyxll.com/docs/index.htmlPyXLL's Alternatives
ChemStat
ChemStat is a statistical analysis software for environmental data, designed for Windows. It helps analyze…
GRID Spreadsheet Engine
GRID Spreadsheet Engine is a spreadsheet software from GRID that provides a modern spreadsheet use…
DewesoftX
DewesoftX is a data acquisition software from Dewesoft that provides comprehensive test and measurement monitoring…
DataFi Analytics Dashboard
DataFi Analytics Dashboard is a data management platform from DataFi that provides a unified interface…
