Accelerate your Spreadsheets with Python
Highlights
Functions
Define new Excel functions in Python to call from Excel. Analyse data, create charts or do anything you like.
Automation
Use Excel as the UI for your automations. Define macros in Python and call them from Excel. Automate anything, from Excel to Word, or even your operating system.
Editor Integration
xlpro's file structure suits modern tooling. Develop your code in a modern IDE and version your software with Git.
Code Sharing & Tracking
Simple distribution allows users to replicate your Python environment for guaranteed compatibility.
Lightweight
A simple Python wrapper. Bring your own Python or install on the fly. No admin rights necessary.
Customization
Install any libraries and standardize every project created within your business.
One-Click Installation
Beginner friendly. Install xlpro with one click and have it ready to use immediately.
Privacy
No cloud, no telemetry. Your code runs on your Python interpreter on your machine.
Features
Python From The Formula Bar
Define new UDFs in Excel in Python using your favourite libraries and call them from the formula bar. Return simple values, dates, 2D arrays, or arbitrary Python objects.
Mix and match Excel and Python data to use Excel as your UI for your functions.
Have a list, numpy.ndarray or pd.DataFrame? Call show() to convert the object to an Excel array.
Dynamic Charts
Generate figures and charts in Python and display them in Excel, completely dynamically.
Loading your raw data from a csv? API request? Or just want to use a Python visualisation library? Just write a function that returns a figure, and you're good to go.
Inputs changed? No problem - your functions are tied to the Excel recalculation cycle, so your figure is always kept up-to-date.
Python Macros
Need to automate Microsoft Office, filesystem operations, generate documents, or just tired of writing VBA? Simply write a Python function to do what you need, and access it directly from the Excel macro window.
Thanks to its rich open-source ecosystem, Python can automate many of your day-to-day actions or even interact directly with applications such as Excel, Word and Powerpoint.
Maybe now you can automate that tedious task - all in a modern, simple, and robust language.
Ready?
See our Quick Start Guide to use xlpro in your next project.