Data Tools Suite

Data Tools Suite: 17 Essential Excel Add-ins to Transform Your Data Management. Save time, reduce errors, and boost productivity. Remove duplicates, spaces, and errors in seconds, merge multiple Excel sheets effortlessly, split a table into individual sheets with just a few clicks, and much more.

Multilanguage: DataToolsSuite is available in English, Spanish, Portuguese, German, French and Italian. Videos and support are only available in English and Spanish.

Try it for free or buy a PRO version of Data Tools Suite and boost your Excel now.

Data Tools Suite is ideal for those who:

Use Excel to manage data and generate information for decision making.
In their companies have organizational systems, ERP or similar, but require export data to Excel to build more developed analysis or criteria other than those provided by these systems.
Perform operations on the data to prepare PivotTable as standardize texts, fill blank cells, group data from different sheets, among others.
Waste valuable time performing routine tasks on the data in Excel.

Try Data Tools Suite for free and supercharge your Excel NOW! Download

Optipe DataToolsSuite applications:

Data Tools Suite

Summarize a Table

Generates a summary of a data table by one or multiple criteria.
Allows various aggregation functions (sum, average, count, max, min).
You can update the summary after generated.

Consolidate Templates

Generates a consolidation of templates or forms located on different sheets.

Group Tables

Group data from multiple tables located in different sheet in a single table.
Allows you to choose the tables and fields to include in the group.

Select and Filter

Select cells by various criteria.
You can also filter the cells.
Optionally, mark the selected cells with a color and can extend the selection to the entire row.

Operations on a Range

Performs arithmetic operations simultaneously in a range of cells.
Lets you add, subtract, multiply or divide by a constant, round (to integer, ten, hundred, or thousand).
It also allows you to define a custom operation.

Summarize Multiple Tables

Generates a summary of multiple tables located in different sheets.
Allows various aggregation functions (sum, average, count, max, min).
You can update the summary after generated.

Create Conditional Formula

Create a formula to search, count or sum data conditionally based on one or more criteria.
Match types: search data, search position, look if exists (yes / no), count occurrences, sum data, average, maximum, minimum.

Manage Worksheets

Group sheets located in different workbooks.
You can hide, show, sort, protect, unprotect and rename the sheets.
Also allows you to save sheets in individual files.

Fill Empty Cells

It allows you to fill the empty cells in a range with a reference to the cell above.
Also you can fill with text or numeric constants.

Forms, Names, Hyperlinks

Select all shapes or objects, names and existing hyperlinks in Excel sheet or workbook.
Selected items can be removed.

Merge Tables

Allows merge data from two tables based on one or more criteria.
Incorporates in the first table matching data from the second one.
Match types: search data, search position, look if exists (yes / no), count occurrences, sum data, average, maximum, minimum.

Extract Data from Table

Extracts data from a table or database similar to a query.
Allows various criteria for extraction.
It also allows you to split a table in multiple sheets.

Unpivot Columns

Rotate or unpivot two-dimensional columns.
The result table may be used as database for Pivot Tables.

Manipulate Text

Modifies character strings.
Change to uppercase or lowercase, remove accents, converts text formatted numbers to number, removes blanks.
Also add prefixes or suffixes.

Color Markers