Skip to content

My Tool Belt

Excel Add-in: MyToolBelt

Ready to become an office superhero? 🚀

My Tool Belt

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?

Expand Excel's Capabilities, Run & Create Python Scripts Right Inside Excel And Automate Some Of The Tedious Tasks In Excel.

My Tool Belt

Expand Excel’s Capabilities, Run & Create Python Scripts Right Inside Excel And Automate Some Of The Tedious Tasks In Excel.

Make productivity your superpower

click to enlarge

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!

Upgrade Anytime

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).

Starter 0 $

Free Forever

Over 30 Powerful Features

Insert Pictures Into Comments
Insert Table Of Contents Gallery
Add Coloured Box Highlights
3 Tickmarks
Free Future Updates
Run Python Files From Excel
Create Xlwings Templates
Create Pandas Dataframes
Create Jupyter Notebooks
Additional Settings
Download for free
PRO 29 $

Life-time License

Over 40 Powerful Features

Insert Pictures Into Comments
Insert Table Of Contents Gallery
Add Coloured Box Highlights
5 Tickmarks
Free Future Updates
Run Python Files From Excel
Create Xlwings Templates
Create Pandas Dataframes
Create Jupyter Notebooks
Additional Settings
Buy Now

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.

run_python

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]
  • sheet_name
  • skiprows [Number of lines to skip]
  • usecols [Excel column ranges (e.g. “A:E”)]
  • nrows [Number of rows to parse]
Pandas Dataframe

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!

Jupyter Notebook

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.

Xlwings Template

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.

Insert Tickmarks

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.

Highlight Cells

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.

Table_of_Contents

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.

pic_in_comment

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

 

More Features

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.

Free Future Updates

frequently asked questions

Have A Question? Ask Away!