18 tools to merge, clean, and transform Excel data in seconds

Automate your team's repetitive tasks. Zero formulas, zero errors, from day one.

✓ Merge and compare tables from different sources
✓ Export and structure data for analysis
✓ Split tables into multiple sheets automatically
✓ Fill, clean, and prepare data without errors

Ideal for HR, Finance, Management, Operations, and Controlling to:

Process large volumes of data from ERP or external files.
Consolidate information for recurring reports.
Clean, validate, and structure data without errors.

Watch Data Tools Suite in action

🚀 Free Version 🛒 Buy PRO Version

🌍 Multilanguage: EN, ES, PT, DE, FR, IT⚙️ Format: Excel Add-In.

Express Merge & Consolidation

Compare lists, find matches, and combine multiple sheets or forms into a single master table in just 2 clicks.

Formula-Free Data Cleaning

Remove spaces, fix distorted ERP text, unpivot columns, and fill blank cells completely in bulk.

Local Corporate Security

Your financial and payroll data is never uploaded to the cloud. Everything is processed locally on your computer, 100% securely.

Full Application Catalog

🔗 Merge and Consolidate Tables

Merge Tables

Combine data from two tables based on one or more matching criteria.

Consolidate Forms

Consolidate standardized forms located on different sheets.

Append Tables

Append data from multiple worksheets into a single master table.

Summarize Multiple Tables

Create a combined summary of tables located across different sheets.

Compare Lists

Compare columns and identify matches or missing data between two tables.

Summarize a Table

Generate custom data summaries based on single or multiple criteria.

🧹 Clean and Prepare Data

Clean & Transform Text

Remove accents, convert text to numbers, and clean trailing spaces.

Unpivot Columns

Normalize flat data formats to prepare them for Pivot Tables.

Fill Empty Cells

Fill empty ranges instantly with above values or constants.

Select and Filter Cells

Manage duplicates, errors, or blank cells in bulk. Select the first occurrence of each value or isolate all repeated rows. Instantly highlight values or formulas that match any specific criteria.

🔢 Operations and Calculations

Operations on Ranges

Perform mathematical calculations in bulk without auxiliary formulas.

Split into Sheets

Divide a master table into multiple worksheets by cell value.

Conditional Formula

Use an assisted builder for conditional lookups and sums.

Extract Data

Extract structured data from tables using direct search queries.

🛠️ Management and Utilities

Manage Worksheets

Hide, sort, protect, or export worksheets in bulk.

Color Markers

Apply instant visual status alerts based on numeric ranges.

Manage Workbooks

Organize, rename, and manage multiple files and folders at once.

Clean Objects & Names

Audit and delete broken names, hidden objects, and external links.

Other Features

Custom format buttons and extra data utilities.

Added Functions

Over 30 brand-new built-in calculation functions.

OneClic

18 direct shortcuts for your most frequent actions.

• See Installation Details for Optipe add-ins.

• Check Configuration Settings and Installation Issues.

Frequently Asked Questions about Data Tools Suite

Are all 18 applications included in the same download? Yes, absolutely. When you install Data Tools Suite, a single menu is added to your Excel ribbon, giving you full access to all 18 data management applications and over 30 built-in calculation functions. There is no need to pay for or install separate add-ins.

How does the DTS PRO version update? The PRO version includes a seamless, automatic update system. As we optimize processing algorithms or release compatibility updates for new Microsoft Excel versions, your suite will stay up to date without any extra costs.

Is it secure for my company's confidential information? It is 100% secure. Unlike cloud-based platforms, Data Tools Suite runs strictly locally on your computer. No financial, strategic, or HR data ever leaves your spreadsheet or is transmitted over the internet. Your information remains completely protected under your company's internal security protocols.

Does it support large volumes of data without freezing Excel? Yes, it is specifically developed for analysts and auditors who handle thousands of rows. The algorithms optimize Excel's internal memory usage, ensuring that heavy tasks that would normally freeze the application (such as mass duplicate matching or unpivoting massive tables) are resolved smoothly in seconds.

Can I evaluate the suite before purchasing corporate licenses? Of course. We offer a fully functional free trial version so you can verify directly, using your department's actual daily reports, how a repetitive task that takes half a morning is reduced to just 3 minutes.

"We purchased licenses for our Controlling team. What used to take half a morning of manual data merging and consolidation is now resolved in minutes. Worth every penny."

— Head of Controlling, Transport Company, Chile

What used to take half a morning now takes 3 minutes.
Same Excel, same team.

Need to roll this out across your team?

This email address is being protected from spambots. You need JavaScript enabled to view it.

Licenses for 5 or 10 users →

Data Tools Suite: 18 apps for Excel data and tables

18 tools to merge, clean, and transform Excel data in seconds

Watch Data Tools Suite in action

Express Merge & Consolidation

Formula-Free Data Cleaning

Local Corporate Security

Full Application Catalog

🔗 Merge and Consolidate Tables

Merge Tables

Consolidate Forms

Append Tables

Summarize Multiple Tables

Compare Lists

Summarize a Table

🧹 Clean and Prepare Data

Clean & Transform Text

Unpivot Columns

Fill Empty Cells

Select and Filter Cells

🔢 Operations and Calculations

Operations on Ranges

Split into Sheets

Conditional Formula

Extract Data

🛠️ Management and Utilities

Manage Worksheets

Color Markers

Manage Workbooks

Clean Objects & Names

Other Features

Added Functions

OneClic

Frequently Asked Questions about Data Tools Suite

Need to roll this out across your team?

Get back time for what matters

Compare Lists in Excel

Personalized document sending from Excel

⚡ Boost Your Excel

📋 User Testimonials

🎯 Data Tools Suite + MultiMail

Data Tools Suite: 18 apps for Excel data and tables

18 tools to merge, clean, and transform Excel data in seconds

Watch Data Tools Suite in action

Express Merge & Consolidation

Formula-Free Data Cleaning

Local Corporate Security

Full Application Catalog

🔗 Merge and Consolidate Tables

🧹 Clean and Prepare Data

🔢 Operations and Calculations

🛠️ Management and Utilities

Frequently Asked Questions about Data Tools Suite

Need to roll this out across your team?

Get back time for what matters

Compare Lists in Excel

Personalized document sending from Excel

⚡ Boost Your Excel

📋 User Testimonials

🎯 Data Tools Suite + MultiMail

Save 5+ hours per week in Excel

Ready to start?