Download Data Cleaning Add-Ins for Microsoft Excel

Tested prompts for excel data cleaning add-in compared across 5 leading AI models.

BEST BY JUDGE SCORE Claude Haiku 4.5 9/10

You're looking for an Excel add-in that can clean messy data without you manually writing formulas for every edge case. Maybe you inherited a spreadsheet with inconsistent date formats, trailing whitespace, mixed capitalization in product names, or 40,000 rows where half the phone numbers have parentheses and half don't. Native Excel tools like Text to Columns, Find and Replace, and TRIM get you part of the way, but they fall apart on fuzzy matching, pattern detection, and bulk normalization.

AI-powered add-ins and prompt-based workflows now handle this work directly inside the grid. You point them at a column, describe the fix in plain English, and they return cleaned values you can paste back or accept in place. This page shows you the actual prompt, the outputs from four different models (so you can see which one handles your type of mess best), and a comparison of where each one wins.

Below that, you'll find concrete scenarios, example inputs and outputs, and the mistakes people make when they first wire an AI cleaner into Excel. Use it to pick the right tool and skip the trial-and-error.

When to use this

Use an AI data cleaning add-in when the rules are fuzzy, the dataset is too large to eyeball, or the inconsistencies are too varied for a single formula. It fits best when you can describe the desired output in a sentence but writing the logic would take an hour. It's also the fastest path when you need to standardize free-text fields.

Standardizing company names (IBM, I.B.M., International Business Machines) across a CRM export
Parsing messy address strings into street, city, state, and ZIP columns
Normalizing product SKUs, phone numbers, or dates that arrived in five different formats
De-duplicating customer records where names and emails have typos or slight variations
Classifying free-text survey responses or support tickets into clean categories

When this format breaks down

Regulated data (PHI, PII under HIPAA, financial records) that can't leave your tenant without a compliant deployment
Deterministic, rule-based cleaning like stripping whitespace or converting case, where a formula or Power Query step is faster and free
Very large datasets (500k+ rows) where per-cell API calls become slow and expensive compared to a SQL or Python job
Work that requires perfect auditability, since AI outputs can vary slightly between runs unless you lock temperature and cache results

The prompt we tested

You are an expert in Microsoft Excel add-ins for data cleaning. Based on the user's situation below, recommend the most suitable Excel data cleaning add-ins and explain how to install and use them.

Follow these rules:
Return a ranked list of 4-6 Excel data cleaning add-ins (e.g., Power Query, Ablebits, Kutools, XLTools, ASAP Utilities) with a one-line description, key cleaning features relevant to the user's task, pricing tier (free/paid), and a short install path (e.g., Insert > Get Add-ins or vendor download link). Keep each entry under 60 words and end with a one-sentence recommendation of the best fit for the user's specific scenario.

User's data cleaning situation:
I have a sales spreadsheet with about 50,000 rows exported from our CRM. It has inconsistent date formats, extra whitespace in customer names, duplicate entries, and some merged cells I need to unmerge. I'm on Excel 365 on Windows and prefer free tools if possible.

Provide your recommendations:

Model comparison

Model	Quality	Cost	Latency	Tokens
Claude Opus 4.7	9	$0.0893	17.6s	363 / 1118
Claude Haiku 4.5	9	$0.0039	7.0s	247 / 721
GPT-5.4	Not run yet
Gemini 2.5 Pro	8	$0.0013	17.1s	234 / 203
Grok 4.1 Fast Reasoning	9	$0.0002	8.9s	363 / 352

Outputs

Claude Opus 4.7 9/10

# Excel Data Cleaning Add-in Recommendations

## 1. Power Query (Get & Transform) — **Best Overall**
Built-in ETL tool in Excel 365, ideal for large datasets and repeatable cleaning workflows.
**Key features:** Standardize date formats, TRIM whitespace, remove duplicates, split/merge columns, and refresh transformations automatically on new CRM exports.
**Pricing:** Free (built-in)
**Install:** Already included — go to *Data > Get Data* or *Data > From Table/Range*.

## 2. ASAP Utilities
Veteran utility suite with 300+ tools for fast, one-click cleaning tasks.
**Key features:** Unmerge cells and fill down values, trim spaces, fix date formats, delete duplicate rows, and clean non-printable characters.
**Pricing:** Free for home/student; paid for business (~$49)
**Install:** Download installer from asap-utilities.com → run .exe → enable in *File > Options > Add-ins*.

## 3. Ablebits Ultimate Suite
Polished commercial suite with wizards for complex cleaning and dedupe scenarios.
**Key features:** Advanced Duplicate Remover, Trim Spaces, Unmerge Cells & Fill, Convert Text to Date, and fuzzy-match duplicates.
**Pricing:** Paid (~$99/yr); 14-day free trial
**Install:** *Insert > Get Add-ins* (search "Ablebits") or download from ablebits.com.

## 4. Kutools for Excel
Feature-rich toolkit popular for quick fixes on messy exports.
**Key features:** Unmerge cells with auto-fill, remove extra spaces, advanced dedupe across columns, and batch date conversion.
**Pricing:** Paid (~$49); 30-day free trial
**Install:** Download from extendoffice.com → run installer → new Kutools tab appears in ribbon.

## 5. XLTools
Lightweight add-in focused on data cleaning, automation, and SQL queries in Excel.
**Key features:** Clean Data wizard, automatic date parser, duplicate remover, and whitespace trimmer.
**Pricing:** Freemium (Clean Data module free); full suite paid
**Install:** Download from xltools.net → run installer → enable in Add-ins.

## 6. Power Tools (Google-style add-in via AppSource)
Simple ribbon add-in for basic cleanup tasks.
**Key features:** Remove duplicates, trim whitespace, and format cleanup.
**Pricing:** Free/freemium
**Install:** *Insert > Get Add-ins* → search "Power Tools".

---

### ✅ Best Fit for Your Scenario
Since you're on Excel 365, prefer free tools, and have 50,000 rows needing **repeatable** cleaning from CRM exports, **Power Query is your best choice** — it handles all four issues (dates, whitespace, duplicates, unmerging via "Fill Down" after unmerge) natively, scales easily beyond 50K rows, and lets you refresh the same cleaning steps on future exports with one click. Supplement with **ASAP Utilities (free)** for the one-off unmerge-and-fill step if needed.

Claude Haiku 4.5 9/10

# Excel Data Cleaning Add-ins for Your CRM Data

## 1. **Power Query (Recommended)**
**Description:** Built-in ETL tool for Excel 365 that transforms messy data at scale.

**Key Features:** Remove duplicates, trim whitespace, standardize date formats, split/merge columns, unmerge cells via formulas.

**Pricing:** Free (included with Excel 365)

**Install:** Data > Get Data > Launch Power Query Editor

**Why it's best for you:** Handles 50K rows effortlessly, free, native to Excel 365, and covers all your needs—duplicates, whitespace, dates, and cell operations—without external dependencies.

---

## 2. **ASAP Utilities**
**Description:** Lightweight add-in with 300+ Excel utilities for quick data cleaning tasks.

**Key Features:** Remove duplicates, trim spaces, standardize dates, unmerge cells, find/replace patterns.

**Pricing:** Free (basic) / Paid ($30 one-time)

**Install:** Download from asap-utilities.com > File > Options > Add-ins > Browse

**Why consider:** Fast one-click operations; free version covers your core needs (duplicates, whitespace, unmerge).

---

## 3. **Kutools for Excel**
**Description:** Feature-rich add-in with 300+ tools for data manipulation and cleaning.

**Key Features:** Remove duplicates, clean whitespace, date format conversion, unmerge cells, advanced find/replace.

**Pricing:** Paid ($39/year)

**Install:** Download from extendoffice.com > Install wizard > Excel restart required

**Why consider:** Intuitive interface, handles merged cells elegantly, strong date standardization; premium quality justifies cost if budget allows.

---

## 4. **Ablebits (formerly Merge Cells)**
**Description:** Specialized add-in excellent for handling merged cells and data consolidation.

**Key Features:** Unmerge cells (primary strength), remove duplicates, trim whitespace, standardize formats.

**Pricing:** Free (limited) / Paid ($40/year)

**Install:** Download from ablebits.com > Add-in installer > Restart Excel

**Why consider:** Best-in-class unmerge functionality; free tier may cover basic needs depending on merge complexity.

---

## 5. **XLTools**
**Description:** Cloud-based Excel add-in focusing on data quality and deduplication.

**Key Features:** Remove/find duplicates, standardize text, trim spaces, date conversion, data validation.

**Pricing:** Paid ($99/year) with free trial

**Install:** Insert > Get Add-ins > Search "XLTools" or xltools.net

**Why consider:** Enterprise-grade duplicate detection; overkill unless duplicates are extremely complex.

---

## **Summary Recommendation**

**Use Power Query first**—it's free, powerful, and solves all five issues (duplicates, whitespace, dates, merged cells, 50K rows). If you need faster one-click operations, add the free version of ASAP Utilities as a secondary tool.

Gemini 2.5 Pro 8/10

Of course. Here is a ranked list of Excel data cleaning add-ins tailored to your situation.

***

### Recommended Excel Data Cleaning Add-ins

1.  **Power Query**
    A powerful data transformation and preparation tool built directly into Excel.
    **Key features:** Automatically detects and transforms inconsistent date formats, trims whitespace, removes duplicate rows, and unmerges cells by filling down values.
    **Pricing:** Free (built into Excel 365).
    **Install path:** Already included. Access via **Data > Get & Transform Data > From Table/Range**.

2.  **ASAP Utilities**
    A popular add-in that adds a comprehensive menu of time-saving tools and shortcuts to Excel.
    **Key features:** Unmerge cells and fill blanks, advanced character and space trimming, and a utility to select/delete duplicate rows.
    **Pricing:** Free for Home & Student use; Paid for business use.
    **

Grok 4.1 Fast Reasoning 9/10

1. **Power Query**  
   Built-in ETL tool for transforming large datasets. Key features: standardize dates via locale/change type, trim whitespace, remove duplicates, split unmerged data. Free. Install: Data > Get Data > Launch Power Query Editor.  
   (28 words)

2. **ASAP Utilities**  
   Free suite of 300+ productivity tools. Key features: trim whitespace, fix dates, deduplicate rows, unmerge cells in bulk. Free (donationware). Install: Vendor site download (asap-utilities.com).  
   (32 words)

3. **Ablebits Power Tools**  
   Collection of data manipulation utilities. Key features: instant duplicates finder/remover, text trim/clean, date format converter, unmerge cells. Free version available. Install: Insert > Get Add-ins > Search "Power Tools".  
   (35 words)

4. **Kutools for Excel**  
   Comprehensive toolkit for Excel tasks. Key features: merge/split cells, trim all sheets, advanced duplicates removal, date formatting. Paid ($49/year, 60-day trial). Install: Vendor download (extendoffice.com).  
   (33 words)

5. **XLTools Combo**  
   Robust add-in for cleaning and analysis. Key features: bulk unmerge, whitespace remover, fuzzy duplicates, date parser. Paid ($98 lifetime, trial). Install: Vendor download (xltools.net).  
   (30 words)

**Best fit: Power Query is the top recommendation for your 50k-row CRM data on Excel 365, as it's free, native, scalable for large sets, and directly addresses dates, whitespace, and duplicates—unmerge cells manually first via Home > Merge & Center.**

What makes these work

01

Show the model 3-5 examples
Paste a few input-output pairs into the prompt before the bulk data. Few-shot examples dramatically improve consistency, especially for formatting rules like phone number patterns or title casing conventions that are hard to describe in words.
02

Clean in a sidecar column
Never overwrite the source column on the first run. Write cleaned values to a new column, diff them against the original, and only replace once you've spot-checked at least 50 rows. This catches systematic errors before they corrupt your data.
03

Batch in chunks of 50-200
Most add-ins process row-by-row or in small batches. Chunking keeps token costs predictable and lets you stop early if the output drifts. It also makes retries cheap when the API times out on a single batch.
04

Lock the output schema
Tell the model exactly what columns to return and in what order, ideally as JSON. Loose prompts like 'clean this up' produce inconsistent output that won't paste back into the sheet cleanly.

More example scenarios

#01 · Normalizing inconsistent country names in a sales export

Input

A column with values like: USA, U.S.A., United States, US, america, United States of America, U.S., states. 8,400 rows total, used for a pivot by country.

Expected output

Every variant mapped to 'United States'. The add-in returns a cleaned column plus a small mapping table showing each source value and its standardized form, so you can review edge cases before overwriting the original data.

#02 · Splitting a messy full-name column

Input

A 'Contact' column containing entries like 'Dr. Jane M. Doe, PhD', 'john smith jr', 'MARIA GARCIA-LOPEZ', and 'Li, Wei'. Need first name, last name, and title in separate columns for a mail merge.

Expected output

Three new columns: Title (Dr., empty, empty, empty), First (Jane, John, Maria, Wei), Last (Doe, Smith, Garcia-Lopez, Li). Suffixes like PhD and Jr are dropped or moved to a Suffix column based on the prompt.

#03 · Cleaning product descriptions scraped from supplier PDFs

Input

Cells like '10mm  hex bolt, SS316, pack/50', '10 MM Hex Bolt SS-316 (50pk)', 'bolt hex 10mm stainless 316 50-pack'. 2,300 rows from four suppliers.

Expected output

A standardized description column: '10mm Hex Bolt, SS316, 50-pack' for all three variants, plus extracted attribute columns for size, material, and pack quantity that you can sort and filter.

#04 · Categorizing open-ended survey feedback

Input

A 'What could we improve?' column with 1,200 free-text answers ranging from 'app crashes on login' to 'more dark mode options pls' to 'pricing is confusing for teams'.

Expected output

Each row tagged with a category (Bugs, Feature Request, Pricing, UX, Other) and a one-line summary. The model flags ambiguous responses for human review instead of forcing a category.

#05 · Fixing date formats from a mixed-region report

Input

A date column with '03/04/2024', '4-Mar-24', '2024.03.04', 'March 4th, 2024', and blanks. Context: all are US-format dates from a single system that changed locales mid-year.

Expected output

A single ISO 8601 column (2024-03-04) with blanks preserved as empty cells. The add-in returns a confidence flag on ambiguous rows like '03/04/2024' so you can verify the US interpretation before committing.

Common mistakes to avoid

Trusting the first 10 rows
The model often nails the obvious cases and fails on the long tail. Always review a random sample from the middle and end of the dataset, not just the top. Edge cases cluster in unexpected places.
Sending PII to a public endpoint
Default add-ins route data through the vendor's API, which may violate your company's data policy. Check whether the add-in supports Azure OpenAI, a private deployment, or local models before loading customer records.
Skipping the mapping table
If the add-in can output a source-to-cleaned mapping, use it. Without that audit trail you can't explain to a stakeholder why 'Acme Corp.' became 'Acme Corporation' in row 4,000, and you can't reproduce the cleaning run.
Using AI for deterministic work
Don't burn API calls on UPPER(), TRIM(), or a simple Find and Replace. AI is for fuzzy, context-dependent cleaning. Using it for mechanical transforms wastes money and introduces variance into work that should be perfectly repeatable.
Ignoring temperature settings
Many add-ins default to a creative temperature, which means the same input can produce slightly different output on rerun. For cleaning tasks, set temperature to 0 or the lowest available value to get consistent, reproducible results.

Related queries

Frequently asked questions

What is the best free Excel add-in for data cleaning?

Microsoft's built-in Power Query is the strongest free option for rule-based cleaning and handles most deduplication, splitting, and format standardization without AI. For AI-powered cleaning, the free tiers of Ajelix, SheetAI, and Excelly-AI cover small jobs. If you're on Microsoft 365, the native Copilot in Excel handles natural-language cleaning prompts on supported plans.

Can ChatGPT clean Excel data directly?

Yes, through the ChatGPT Excel add-in or by pasting ranges into a chat with a clear prompt. For larger jobs, the official OpenAI add-ins and third-party tools like GPT for Excel let you call the model from a cell formula, which scales better than copy-paste. Just watch for token limits on wide tables.

How do I clean thousands of rows without paying per API call?

For deterministic cleaning, use Power Query or a Python script via the new Excel Python integration, both of which are free. For AI-required work, batch rows into groups of 50-100 per call and cache results. If you're running this monthly, a local model via Ollama plus a custom add-in eliminates per-call costs entirely.

Is it safe to use an AI add-in on confidential company data?

It depends on the add-in's deployment. Public API-based add-ins send your data to the vendor's servers, which may breach confidentiality agreements. Look for add-ins that support Microsoft 365 Copilot (runs in your tenant), Azure OpenAI with a private endpoint, or on-device models. Always check your company's data classification policy first.

What's the difference between Power Query and an AI cleaning add-in?

Power Query applies deterministic, repeatable transformations you define step-by-step, ideal for structured cleaning that runs the same way every time. AI add-ins interpret fuzzy instructions and handle unstructured inputs like free text, misspellings, and varied formats that would take dozens of Power Query steps. Most serious workflows use both: Power Query for structure, AI for the messy edges.

Can an AI add-in detect and remove duplicate records with typos?

Yes, this is one of the strongest use cases. Standard Excel duplicate removal only catches exact matches, but AI add-ins can identify that 'Jon Smith, jsmith@acme.com' and 'John Smith, j.smith@acme.com' are the same person. Use an add-in that returns a confidence score per match so you can review borderline cases before merging.