Home/Browse/Office Suites/Kutools for Excel

Kutools for Excel

An add-in that puts several hundred spreadsheet operations behind single buttons, covering the tedious tasks that otherwise mean a formula, a macro, or twenty minutes of manual work.

Version 30.60 68.2 MB Windows 7 / 8 / 10 / 11 (64-bit) Updated 4 days ago

Overview

What this release is

Kutools is a collection of roughly three hundred operations that the spreadsheet application can technically do already, if you are prepared to write the formula, record the macro, or do it by hand. Each one becomes a button with a dialogue box. Individually none of them is remarkable. Collectively they remove a substantial share of the tedious work from a spreadsheet job.

The range and cell tools cover the operations everyone has needed and none of which are built in. Combine several columns into one keeping the separators, split one column into many by any rule, transpose a range in place, convert between ranges and tables, fill blank cells with the value above them, and swap two ranges without a temporary staging area.

Worksheet and workbook management is the second large group. Split one sheet into many by a column value, merge many workbooks into one, compare two ranges and mark the differences, copy a formatting layout across every sheet at once, and rename or reorder sheets in bulk. Anyone who has manually split a report by region will understand immediately why this is worth having.

The formula group deserves its own mention. Several hundred named formulas for the calculations that come up repeatedly, from counting by colour and summing visible cells to date and text manipulations that would otherwise take a nested expression nobody wants to maintain. There is also a formula helper that builds the expression from a dialogue rather than from memory.

The remaining tools cover conversion, cleanup, and navigation: convert numbers stored as text in bulk, remove every space and non printing character, convert dates between formats, delete blank rows and columns across a workbook, and a navigation panel that lists sheets, workbooks, columns, and named ranges in a sidebar for jumping around a large model quickly.

Feature set

What you get

Range operations

Combine, split, transpose, swap, and fill ranges through dialogue boxes rather than formulas or macros.

Workbook management

Split sheets by column value, merge workbooks, compare ranges, and apply formatting across every sheet at once.

Named formula library

Several hundred ready formulas for common calculations, including counting and summing by colour or visibility.

Bulk cleanup

Convert text stored numbers, strip non printing characters, normalise dates, and delete blank rows workbook wide.

Navigation panel

A sidebar listing sheets, workbooks, columns, and named ranges for moving quickly through a large model.

Formula helper

Builds the expression from a dialogue rather than requiring the syntax from memory.

Changes in this build

What changed

New tools added across the range, formula, and cleanup groups
Faster operation on very large sheets through improved batch processing
Navigation panel rebuilt with search across sheets and named ranges
Improved compatibility with the current spreadsheet application release
Fixed the split operation that could drop formatting on the resulting sheets

Installation

How to install it

Turn off real time protection before extracting and keep it off through the configuration step.
Close the spreadsheet application completely before running setup. An add-in cannot install into a running host.
Extract the archive to a short path and run the setup executable as administrator.
Apply the included configuration step before opening the spreadsheet application.
Open a workbook and confirm the new ribbon tabs are present with no trial notice.

Hardware

System requirements

Processor	Any 1 GHz or faster processor, 64-bit
Memory	2 GB, 4 GB recommended for large workbooks
Graphics	No requirement
Storage	200 MB
Display	1280 x 720
System	Windows 7 through Windows 11 with a supported spreadsheet application installed

Package

Release information

Title	Kutools for Excel
Version	30.60
Developer	ExtendOffice
Category	Office Suites
Platform	Windows 7 / 8 / 10 / 11 (64-bit)
Package size	68.2 MB
Interface languages	Multilingual (12 interface languages)
Release identifier	BS-30600001
Listed	4 years ago
Last rebuilt	4 days ago
Total downloads	107,661

Questions

Before you start

Which spreadsheet versions are supported?

The releases from 2016 onward and the current subscription builds, in both perpetual and subscription form.

Do the tools change my files permanently?

They perform normal spreadsheet operations, so the usual undo applies to most of them. Bulk operations across a workbook are worth testing on a copy first.

Does it slow the application down?

Barely. It adds ribbon tabs and loads its tools on demand rather than at startup.

Can individual tool groups be hidden?

Yes. The ribbon layout is configurable, so unused groups can be removed from view.