Skip to content

My Tool Belt

Excel Add-in: MyToolBelt

Ready to become an office superhero? 🚀

My Tool Belt

Current Version: 2.2

Compatibility: PC Only | Works on 32-bit or 64-bit

License: 3 personal devices per license

Requires: Excel 2007 or later (incl. Office 365 Desktop)

MyToolBelt is the ultimate data analysis tool that combines the power of Python with the flexibility of Excel for maximum efficiency and productivity. With MyToolBelt, you can access a wide range of powerful features, such as:

  • Generate Python code to effortlessly import data into Pandas DataFrame
  • Effortlessly call Python scripts from within Excel
  • Easily convert Excel data into Jupyter Notebooks
  • Quickly add tickmarks and highlight important areas in your data

 

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

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!

Upgrade Anytime

With the FREE version, you’ll already have access to a wealth of powerful features. But if you want to take your productivity to the next level, consider upgrading to the PRO version. The upgrade process is easy: just buy a license key through the Add-in, and you’ll be ready to go! (no additional installation is required)

Starter0 $

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
PRO47 $

One-Time Payment = Lifetime 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

Feature comparison

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

With the click of a button, you can generate Python files with the Excel data you need. Simply select the cell range you want to convert, and the add-in will create the Python code to read it as a Pandas DataFrame.

No need to struggle with the various options in the Pandas ‘read_excel’ method. The add-in does the work for you, translating your cell range into the appropriate 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]

This makes it easy to import your Excel data into Python and start working with it right away.

Pandas Dataframe

Create Jupyter Notebooks

Have you ever wished you could quickly analyse your Excel data using a Jupyter Notebook?

MyToolBelt makes it easy! Simply select the cell range you want to convert, and the add-in will create a new Jupyter Notebook in the same directory as your workbook. When you open the notebook, you’ll find your Pandas DataFrame ready to use based on your selected cell range. No more tedious data importing – just quick and easy analysis at your fingertips.

This feature is a huge time saver! Say goodbye to tedious data importing and hello to quick and easy analysis.

Jupyter Notebook

Create xlwings Templates

xlwings is a Python library that brings some of Python’s data analysis capabilities to Excel, including support for NumPy arrays, Pandas Series, and DataFrames.

MyToolBelt makes it even simpler to integrate xlwings into your Excel file. Just select the cell range you want to manipulate, click the ‘Create xlwings template‘ button, and a new Python file will appear in your workbook’s directory.

This file contains xlwings boilerplate code based on your selection, allowing you to use the Python ecosystem to manipulate your Excel data.

Try it out and see how easy it can be!

Xlwings Template

Customize the Python code

Looking to integrate your Excel data into your existing Python code? The MyToolBelt Excel add-in makes it easy!

With just a few clicks, you can select a cell range and copy the generated Python code (ready-to-use Pandas DataFrame) to your clipboard.

But that’s not all – you can also customize the code to fit your needs. For example, you can use an absolute file path or change the default variable for the DataFrame.

Python_Settings_v1

Add Tickmarks to Your Spreadsheet

The ability to insert tickmark icons into your spreadsheet with just a click of a button is a great way to highlight and draw attention to specific cells. This feature can be very useful for organizing and prioritizing information within your spreadsheet.

Insert Tickmarks

Choose from Multiple Tickmark Cell Locations

Need to customize the placement of your tickmarks? With this feature, you can set and save a default position for your tickmarks, giving you control over their placement. And with multiple cell location options to choose from, you can find the perfect fit for your needs.

Tickmark_Menu

Highlight Important Areas

By using the coloured box highlighting feature, you can easily draw attention to essential areas in your spreadsheet. This feature allows you to choose from four different colours (red, green, yellow, and blue) to surround your selected cells. Additionally, you can quickly remove all box highlights by clicking a button.

Highlight Cells

Insert Table of Contents Gallery

Take your Excel workbook to the next level with the Table of Contents sheet feature! With just a few clicks, you can add a stunning Table of Contents sheet to the front of your workbook that includes clickable picture tiles for each sheet. This not only makes your workbook more visually appealing, but also makes it easier for you and others to navigate. Show off your hard work and make it shine with the Table of Contents sheet feature.

Table_of_Contents

Insert Pictures into Comments

MyToolBelt offers a convenient feature that allows you to quickly insert pictures or images into a cell comment. This can be a great way to add extra information to your cells without cluttering up the spreadsheet. By using this feature, you can keep your spreadsheet organized and tidy while still providing important details.

pic_in_comment

Create Cohesive Layouts with Matching Colors

Need to create a professional layout with matching colors? The MyToolBelt Excel add-in has you covered! With the color shading feature, you can apply darker or lighter shades of a color to any selected cell or shape. This simple tool makes it easy to create cohesive and visually appealing designs without any hassle.

Darken_Lighten_Color

Change Border Colors

The MyToolbelt Excel add-in makes it easy to change border colors in your spreadsheets. No more wasting time and energy on this tedious task. Simply select the cell range and click “Change Border Color” to bring up a color picker window. From there, you can easily choose the color you want and watch as MyToolbelt updates your borders in a flash. Save yourself time and frustration with MyToolbelt’s convenient border color change feature.

Change_Border_Color_v1

One-Click Header Dividers

With just one click, you can insert white inner borders between header cells to clearly separate them and give your spreadsheet a sleek, cohesive look. No more tedious multiple clicks to achieve this effect – MyToolbelt makes it easy. Simply select the cell range and click the “Insert White Dividers” button to add these stylish dividers in a snap. Make your Excel work more efficient and give it a polished, professional touch with MyToolbelt’s convenient header divider feature.

Insert_White_Dividers_v1

Eliminate White Spaces Easily

Get rid of pesky white spaces and avoid potential errors in Excel with the help of the MyToolbelt add-in. Whether you’re using formulas like VLOOKUP or just want to keep your data clean and accurate, removing leading and trailing white spaces is key. MyToolbelt makes this task a breeze with a simple click of a button. Streamline your Excel work and eliminate the risk of errors with this convenient feature.

Trim_Cells

Even more Powerful Features 

Looking for even more features to streamline your Excel work? You can also:

  • easily insert drop-down lists,
  • convert text to checkboxes,
  • write cell values to comments,
  • divide/multiply cells by a number,
  • and much more…

With so many valuable tools at your fingertips, you’ll be able to tackle any task easily. Save time and enhance your Excel work – try out the MyToolBelt add-in now!

 

More Features

Free Future Updates

Get ready for even more features with MyToolBelt! I’m constantly working to improve the add-in and to bring you the best experience possible. And the best part? All future updates are completely free. Just check for updates within the add-in to ensure you’re always using the latest version. Don’t worry about manually downloading updates – MyToolBelt will handle it all for you.

Free Future Updates

frequently asked questions

Have A Question? Ask Away!