Excel Add-in: MyToolBelt
Ready to become an office superhero? 🚀
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
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!
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)
Over 30 Powerful Features
One-Time Payment = Lifetime License
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
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]
- 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.
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.
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!
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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!
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.