Benefits and Features of PyXLL

Try PyXLL for yourself with our free 30 day trial, or contact us to schedule a demo.

Start your free trial

Complete Python Integration for Excel

Create workbooks for interactive analysis, modelling, live dashboards and more directly in Excel, all written in Python. PyXLL is the complete solution for writing Excel add-ins in Python.

Faster, Simpler Excel Workbooks

PyXLL is optimized for performance. It's built to work with numerical packages like NumPy, Pandas and SciPy ensuring that your spreadsheets will run fast.

Frictionless Development

Use your favorite Python IDE to develop and debug your Excel add-in, and reload without restarting Excel. Code is separate from Excel enabling version control, unit testing and continuous deployment.

Help When You Need It

Contact our global support team whenever you need help. PyXLL has detailed documentation and includes example code to get you started, but we're always here for you whatever you need.

Call Python Functions From Excel

Expose your analytics or modelling functions directly to Excel users. Any Python function can be turned into an Excel worksheet function, or User Defined Function (UDF).

  • Interactive modelling, analysis and ad-hoc calculations
  • Build dashboards using Python functions
  • Source data from your existing systems
  • Faster calculation times than VBA
Call Python Functions From Excel

Macros, Menus and Ribbon Tabs

Automate Excel using macros, menu items, custom ribbon tabs and context menus, entirely in Python.

  • Use Excel instead of building your own UI
  • Bind macros to on-sheet buttons and other elements
  • Full control of the ribbon with Python actions
  • No VBA required, automate Excel with Python
All Python packages can be used with Excel, including Panads, NumPy, SciPy and QuantLib.

Real Time Data

Stream live market data into your spreadsheets in real-time.

  • Make auto-updating dashboards with live data
  • Source real time data from anywhere with Python
  • Use Python's asyncio event loop or your own threads
  • No complicated setup required
Real Time Python Functions Called From Excel

Charts and Plotting

Use Python's plotting and charting toolkits for amazing data visualizations from within Excel.

  • Create charts from Excel worksheet functions and macros
  • Integration with all the common Python plotting packages
  • Use matplotlib, plotly, bokeh, altair and other packages
  • Update charts as input data changes
Python Plotting and Charts Integration in Excel

Lightning Fast Object Cache

Pass Python objects directly between Excel worksheet functions for cleaner and faster workbooks.

  • No need to always expand large arrays in Excel
  • Reduce spreadsheet clutter by returning objects in a single cell
  • Pass returned Python objects to other Python functions
  • Avoid time wasted reconstructing objects
Pass Python objects between Excel functions

Deep UI Integration

Add intuitive tools right in Excel where you need them using your choice of Python UI toolkit.

  • Windows can be floating or docked
  • Works with PySide2, PyQt5, wxPython, Tkinter and more
  • Two way interaction between Excel and the user interface
  • Uses Excel's native task panes for seamless integration
Excel Custom Task Panes in Python with PyXLL

Frictionless Developer Experience

Use any Python distribution (including Anaconda) and your preferred Python IDE or editor.

  • All code is external to Excel so is easily managed and deployed
  • Debugging support for all major Python IDEs
  • Reload automatically or manually, without restarting Excel
  • Code can be run and tested outside of Excel
Debug Python functions running in Excel with any Python IDE

More Features

Performance

  • Multi-threaded worksheet functions
  • Asynchronous functions
  • Fast Python object cache
  • NumPy and Pandas support
  • Disable calculations in function wizard
  • Users can abort long running functions

Complete VBA Replacement

  • Worksheet functions (UDFs)
  • Real time data (RTD) functions
  • Macros, menus and keyboard shortcuts
  • Ribbon toolbars and context menus
  • Access to the entire Excel Object Model
  • Function documentation and IntelliSense

Developer Experience

  • Automatic reloading of Python code
  • Test Python code outside of Excel
  • Debug using any major Python IDE
  • Add function help to Excel functions
  • Write array and dynamic array functions
  • No VBA required!
Request a demo and start writing Excel add-ins in Python.

Ready for a demo?

Book a demo session and let us show you what PyXLL can do for you!

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.