Excel Add-in: MyToolBelt
Ready to become an office superhero? 🚀
Current Version: 2.1
Compatibility: PC Only | Works on 32-bit or 64-bit
Requires: Excel 2007 or later (incl. Office 365 Desktop)
MyToolBelt saves every smart office worker time and effort when it comes to analysis with a unique set of tools you won’t find anywhere else:
- Generate flawless Python code based on your cell selection
- Call Python scripts from Excel without having to lift a finger
- Create Jupyter Notebooks from Excel
- Add tickmarks to cells and highlight key areas
- Create an informative table of contents with ease
- … and many more powerful features
This is your new superpower; why go to work without it?
My Tool Belt
Make productivity your superpower
When you want to fly through the working day without a worry in the world, you need the right tools at your disposal. With MyToolBelt only ever a click away, you’ll be able to excel in Excel, accelerate your analysis and do it all in less than half the time. You really are starting to sound like a real-life superhero!
By effortlessly integrating Python and Excel, MyToolBelt allows you to turn spreadsheet analysis from the most time-consuming part of your day, into one of the easiest. Now you know how to make productivity your superpower, all you have to do is decide what to do with all your spare time and extra energy. Sounds like the perfect problem to have!
See Some of the Features in Action!
The FREE Version offers already tons of powerful features. I recommend getting started with the FREE version. If you want to unlock the full potential of the Excel Add-in, you can upgrade to the PRO version at any time. The upgrade requires a license key, which you can purchase directly through the Add-in (no extra installation is needed).
Over 30 Powerful Features
Over 40 Powerful Features
Run Python Files From Excel
After locating your Python interpreter, you can execute Python files directly from Excel.
In the Pro Version, you can also add several Python interpreter paths. This is helpful when you need to execute your Python code from different virtual environments.
Create Pandas Dataframes
Generate Python files with a click of a button. Select the cell range you want to transform, and the add-in creates the Python code to read in the Excel data as pandas dataframe.
Instead of messing around with all of the available options in the pandas ‘read_excel’ method, the add-in does it for you.
MyToolBelt will translate the cell range into the following pandas arguments:
- io [File Name]
- skiprows [Number of lines to skip]
- usecols [Excel column ranges (e.g. “A:E”)]
- nrows [Number of rows to parse]
Create Jupyter Notebooks
Have you ever wanted to do some quick analysis of your Excel data in a Jupyter Notebook?
MyToolBelt can convert an Excel cell range into a Jupyter Notebook. Just select the cell range, and the add-in will create a new Jupyter Notebook in the workbook’s directory. Inside the Jupyter Notebook, you will find your ready-to-use dataframe based on your selection. This feature is a real time saver!
Create xlwings Templates
xlwings is a Python library that makes some of the data analysis features of Python available in an Excel instance, including support for NumPy arrays and pandas Series and DataFrames.
MyToolBelt makes it even easier to integrate xlwings into your Excel file. Select the Excel cell range you want to manipulate, click on the ‘Create xlwings template’ button, and you will find a new Python file in the workbook’s directory. The new Python file includes an xlwings boilerplate code based on your selection. You can now use the Python ecosystem to manipulate the Excel data.
Add Tickmarks to Your Spreadsheet
With a click of a button, you can insert various tickmark icons into your spreadsheet. This feature is a great way to highlight and draw attention to specific cells.
Highlight Important Areas
Point out essential areas in your spreadsheet by placing a coloured box around your selected cells. You can choose between four colours (red, green, yellow & blue). Additionally, by clicking a button, you can also remove all box highlights.
Insert Table of Contents Gallery
Add a gorgeous Table of Contents sheet at the front of your Excel workbook that provides clickable picture tiles to each sheet in the workbook to make your hard work shine.
Insert Pictures into Comments
MyToolBelt allows you to insert pictures or images into a cell comment quickly.
This feature is a great way to add additional information to your cell while keeping the spreadsheet tidy.
Even more Powerful Features
There are even more features:
- apply darker or lighter shades of a colour
- easily insert drop-down lists
- trim selected cell
- convert text to checkboxes
- change border colours
- ..and much more
Free Future Updates
There might be more features coming in the future. But rest assured, all future updates will be free. You can check if you are using the latest version inside the add-in. If there is an update available, MyToolBelt will download the latest version for you.