The 7 Best Excel Add-Ins You Need to Get Now

Written by co-founder Kasper Langmann, Microsoft Office Specialist.

Whether you’re in finance, or doing data analysis, there’s an Excel add-in for it.

Many of us spend a lot of time automating our tasks, especially repetitive ones.

And believe it or not, with so many buttons that you see on your Excel spreadsheets, they are still not enough.

Creating add-ins on your own, although possible, can be time-consuming and intimidating.

Kasper Langmann, Co-founder of Spreadsheeto

Good thing the internet is flooded of both free and paid add-ons that will enhance your productivity. We have curated the 7 best add-ins for your every need in this article.

How to Install the Add-Ins?

Before we go through the best add-ins, let’s review first how to install and run the add-ins.

After downloading the desired add-ins, simply run their setup files and complete the installment.

setup wizard of ablebits add-ins

To check, open Excel and click ‘File’ from the tab list.

file from the tab list

Then, click ‘Options’ at the bottom which will open another window called ‘Excel Options’.

select options from the file tab

Now, click ‘Add-ins’ from the left-hand sidebar.

add-ins options on the left-hand sidebar

It will then show you all the available add-ins you have downloaded.

Kasper Langmann, Co-founder of Spreadsheeto

For instance, if you downloaded Ablebits Add-in, you’ll see it in the list. 

If you want to run it, just select ‘COM Add-ins’ and hit ‘Go’.

ablebits add-in as COM add-ins

Once there, tick the add-in’s checkbox and click ‘OK’. You’ll then see the newly-installed add-in running.

tickbox of ablebits add-in

Now that we’re through that, let’s proceed to the 7 best Excel add-ins you need.

Ablebits Duplicate Remover

page of ablebits duplicate remover add-in

It’s very common in large amounts of data to have tons of duplicate information that can slow down your computer or make your spreadsheets even more complicated.

With these add-ins, you will be able to find and analyze good and bad data so you can delete them and restore peace and order in your worksheet.

Some alternatives will give you options to include blank cells, unique, and their first occurrences.

Kasper Langmann, Co-founder of Spreadsheeto

If you want to clean your data, Ablebits’ free Duplicate Remove Toolkit could help.

AutoChart

front page of autochart from the spreadsheet guru

Excel’s charts work fine.

 But they have limitations as all things have.

 Plus, repetitive, not engaging charts can lose your audience focus on your presentation.

 Put more visual options for your data by downloading The Spreadsheet Guru’s AutoChart add-in.

This add-in would help you create, edit and manipulate lots of charts. You can also brand all your charts and even create your own presets!

Kasper Langmann, Co-founder of Spreadsheeto

You can download the trial version or buy it for $35.

Lucidchart

front page of lucid chart add-in

Charts are great but again, nothing’s perfect.

With Lucidchart, you can create stunning diagrams and flow processes which are very important if you are working with a team.

 With Lucidchart drag-and-drop interface, you will be able to visually communicate your complex data with less effort than merging and unmerging cells.

 Sign-up for an account now and see if this free add-in can add value to your project. If you need more features and storage for a single user, you can buy it for $9.95/month. Business plans start from $20/month, $7/user.

ASAP Utilities Add-in

front page of asap utilities excel add-in

The add-in from ASAP Utilities is one of the most powerful Excel add-in in the market.

This add-in has more than 300 features.

In addition, you can add the tools you like to your menus and even assign shortcuts to them. And if you forgot the tool’s name, you can quickly search and run it even without going through the menu.

Kasper Langmann, Co-founder of Spreadsheeto

It’s free for home and student use. The business edition costs $49.

Ablebits Insert Watermark

front page of ablebits insert watermark

Watermark is a great way to protect your intellectual property especially with projects that you have worked very hard for many months.

If you want to keep proprietorship on your worksheets, putting a watermark on them is the best way.

Ablebits’ free Insert Watermark Add-in will allow you to create, insert, and delete your watermark or turn a picture into a one. This will also allow you to put texts on your watermark.

If you are working on big projects and researches, protecting your sheets should be a priority.

Kasper Langmann, Co-founder of Spreadsheeto

Ablebits Text Toolkit

front page of ablebits text toolkit

Data can easily get messy.

With unwanted characters, unnecessary spaces, and inconsistent text cases, your spreadsheets can be more confusing. People like to look at clean worksheets.

This free Text Toolkit from Ablebits is to your spreadsheet what landscaping is to your lawn.

With its quick way of removing extra spaces, unwanted characters, and changing text cases, your projects will be looking neat in no time.

Kasper Langmann, Co-founder of Spreadsheeto

Also, it can provide the word and character count, and even convert text to numbers, extract substrings and replace irrelevant symbols.

Date and Time Formula Wizard

front page of ablebits date and time formula wizard

Formulas have been a headache for many Excel enthusiasts.

Getting the right formula with dates and hours is a big need in many projects. Automating all of these can save you a lot of time and effort that you can spend on other more worthy tasks.

Getting the formula for subtracting or adding years, months, days, hours, minutes, and even seconds, is an addition that can get the job done in seconds.

Try out Ablebits’ free Date and Time Formula Wizard. This formula builder will enable you to get the right procedure in a matter of a couple of clicks.

Wrapping things up…

Accomplishing more doesn’t always mean you have to work harder than the rest. Especially in Excel.

Do away with complicated and intimidating labor of Excel VBA and building your add-ins. Just figure out what needs to be done and more likely than not, someone has already walked that path before.

Just find it and download it, although some require a minimal subscription. Then run it in your worksheets and focus more on getting your project done. It’s that easy! 😊

Kasper Langmann, Co-founder of Spreadsheeto