The Two Groups Every Listicle Mixes Together
Search for "free AI data cleaning tool for Excel" and you get a list of ten products, all tagged "free." They are not the same kind of free. Roughly half are freemium: real AI, real Excel add-ins, and a monthly allowance so small that a single messy spreadsheet exhausts it. The other half are genuinely free and unlimited, but the "AI" in the description is marketing for pattern matching and rule engines that have shipped in Excel since 2016.
Neither group is bad. Mixing them in one ranked list is what wastes your afternoon: you install an add-in, clean two columns, hit a paywall, and start over. So here they are separately, with the numbers taken from each vendor's own pricing or support page as of September 2026 — not from review blogs, which routinely quote caps that were raised or removed a year ago.
The AI Tools: What the Free Tier Actually Gives You
Microsoft Copilot in Excel Best if you already pay
The most capable option, and the one with no free tier at all. Microsoft's own support documentation states that Copilot in Excel requires a Microsoft 365 Personal or Family subscription with an AI credits plan, a Microsoft 365 Premium subscription, or a commercial Copilot licence. There is no "free with limits" path — a free Microsoft account gets you nothing inside Excel.
Prices from Microsoft's individual pricing page: Personal $9.99/month, Family $12.99/month, Premium $19.99/month. Personal and Family each include 60 AI credits per month, and Excel's "Analyze data" is one of the features that spends them. Premium is the plan Microsoft describes as offering extensive usage beyond the standard credit limits. On the business side, Copilot Business is $21 per user/month and the enterprise add-on is $30 per user/month with an annual commitment.
Two practical constraints people hit on day one: Copilot editing only works when Calculation Options are set to Automatic, and Microsoft's own guidance tells you to review and verify everything it produces, explicitly warning against relying on it for finance, legal, or medical decisions. That is a fair caveat, and it applies to every tool on this page.
Ajelix 10 requests/month
Ajelix bundles 17 AI tools with both an Excel add-in and a Google Sheets add-on, and the free plan gives you access to all of them — for 10 requests per month. That is the whole allowance. If a request is "generate the formula that normalises this address column," you have ten of those, and a spreadsheet with a dozen dirty columns is already over budget before you finish the first pass.
The next step up is steep: Lite is $39 per user/month ($32 billed yearly), Pro $99, Max $199. There is no $5 hobby tier. Ajelix is priced for a finance team that has already decided to buy, not for someone cleaning a one-off export.
GPTExcel 4 uses per 12 hours
GPTExcel's free plan needs no credit card and, per the company's FAQ, allows 4 requests per day, refreshed every 12 hours, covering formula help, pivot tables, scripts, SQL and regex generation. Pro raises that ceiling to roughly 1,000 requests per day.
Four uses per half-day is genuinely usable for the narrow job it is best at: you describe a transformation in English, it writes the formula, you paste it into Excel and it runs locally forever after. GPTExcel does not touch your data — it generates the instruction, you apply it. That makes the small cap far less painful than it sounds, and it makes GPTExcel the safest free AI option in this group for confidential spreadsheets.
Numerous.ai No free tier
Worth naming because it appears on nearly every "free AI tools for Excel" list and it does not belong there. Numerous.ai's pricing page offers the first 7 days for $1, then $10/month billed annually for 500,000 characters of input and output plus 500 formula generations. There is no permanent free plan. A one-dollar week is a fair trial; it is not free.
Rows 5 AI tasks/month
Rows is a browser spreadsheet with AI built in rather than an Excel add-in, so it means importing your file and working somewhere else. Its free plan is free forever with no trial and no card, and the caps are specific: 5 AI tasks per month, 1 MB maximum file import, 500 API calls/month, 7 days of version history, unlimited spreadsheets. That 1 MB import ceiling is the one that bites — a 20,000-row CSV with a dozen columns clears it easily, and you find out at upload time.
The Genuinely Free Tools: Powerful, but No AI
Power Query — already installed, already paid for
The single most underused data cleaning tool in this article ships inside Excel at no extra cost. Microsoft's documentation confirms Power Query is included in Excel for Microsoft 365, Excel 2024, 2021, 2019 and 2016 on Windows, Excel for Mac on Microsoft 365, and Excel for the web. It handles removing columns, changing data types, filtering rows, splitting columns, sorting and aggregating — and it runs locally, using the .NET framework 4.7.2 or later and the Edge WebView2 runtime rather than sending anything to a server.
Its real advantage over every AI tool here is repeatability. A Power Query transformation is a saved recipe, not a one-time edit: next month's export gets the same twelve cleaning steps applied with one refresh, and the original file stays unchanged. No AI tool on the freemium list gives you that, at any price tier, without spending credits again.
OpenRefine — for the mess Excel cannot fix
OpenRefine reached version 3.10.0 on 26 February 2026 and is released under the BSD 3-clause licence, free and open source with no tiers to hit. It runs entirely on your own machine — the project's own description of the privacy model is that your data is cleaned locally, not in a cloud service.
Its clustering feature is the reason to bother installing it. Given a column containing "New York", "new york", "NYC", "New York " and "New York", OpenRefine groups those into one cluster and lets you merge them in a single action. That specific job — inconsistent categorical values — is exactly what people are hoping AI will do for them, and OpenRefine has done it deterministically and for free since long before the AI add-ins existed. The trade-off is honest: it is a separate Java application with a browser interface, not something inside Excel, and there is a real afternoon of learning curve.
Single-purpose browser tools for the small stuff
Not every cleaning job needs a workflow. For one column pasted out of a spreadsheet, a focused tool is faster than opening anything: Remove Duplicate Lines for de-duplicating a list, Remove Extra Spaces for the trailing whitespace that breaks lookups, Text Case Converter for standardising capitalisation, and AI Text Cleaner for stripping the invisible characters and smart quotes that arrive with text copied out of PDFs and web pages. When the destination is an API or a database rather than another sheet, CSV to JSON handles the export. All of them process in your browser, so nothing is uploaded. Our guide on how to clean text data online walks through the order to run those steps in.
The Free AI Route That Actually Works
If what you want is genuine AI judgement applied to messy data without paying, the working route in 2026 is not an add-in. It is: export the sheet to CSV, upload it to a general-purpose assistant's free tier, describe the cleaning in plain English, and paste or import the result back.
Both ChatGPT and Claude allow file uploads and code execution on their free plans, with daily usage limits that reset rather than a hard monthly credit balance. Neither vendor publishes a stable public number for free-tier file uploads, so treat the cap as "a few files per day" and plan around it — but a few files per day is considerably more than Ajelix's ten requests per month or Rows' five AI tasks. The assistant writes and runs actual cleaning code against your file, which is a different and more capable operation than generating a formula for you to paste.
The catch is the one worth taking seriously: you are uploading the file to someone else's servers. For a scraped list of conference talks that is fine. For customer records, patient data, salary tables, or anything under an NDA, it is not, and no free tier makes it fine. That is precisely where Power Query and OpenRefine earn their place — local processing is not a feature they charge for. If your spreadsheet lives in Google Sheets rather than Excel, our breakdown of free AI tools for Google Sheets data analysis covers the equivalent options on that side.
Comparison Table
| Tool | Free Tier | Best For | Limitation |
|---|---|---|---|
| Copilot in Excel | None — needs M365 Personal $9.99/mo (60 AI credits) | People already on Microsoft 365 | No free path at all; credits are shared across apps |
| Ajelix | 10 requests/month, all 17 tools | Trying an add-in before committing | Next tier jumps to $39/user/month |
| GPTExcel | 4 requests per 12 hours, no card | Formula and regex generation | Writes instructions, does not clean the file itself |
| Numerous.ai | No free plan — 7 days for $1 | A paid, high-volume workflow | Listed as free almost everywhere; it isn't |
| Rows | 5 AI tasks/month, 1 MB import cap | Small files, browser-based work | Not Excel; the 1 MB ceiling blocks real exports |
| Power Query | Included in Excel, unlimited | Repeatable monthly cleaning | No AI; you define every step yourself |
| OpenRefine 3.10 | Free and open source (BSD 3-clause) | Inconsistent categories, fuzzy duplicates | Separate app; real learning curve |
| ChatGPT / Claude free | Daily upload limits, reset each day | One-off cleaning of non-sensitive data | File leaves your machine; unusable for private data |
Which One Should You Use?
- You clean the same export every month: Power Query, and nothing else comes close. Build the query once, refresh it forever. The time you spend learning it pays back on the second run.
- You have one messy file and it contains nothing confidential: export to CSV and hand it to ChatGPT or Claude on the free tier. Highest capability per zero dollars, by a wide margin.
- The data is confidential: Power Query or OpenRefine, both local. If you want AI help, GPTExcel is the compromise — it generates the formula from your description without ever seeing your rows.
- Your problem is inconsistent categories: OpenRefine's clustering. This is the specific job it beats every AI tool at, deterministically and for free.
- You already pay for Microsoft 365: use the 60 AI credits you are already buying before installing a third-party add-in. Check what you have before you shop.
- You just need one column tidied: skip all of it and use a single-purpose browser tool. Thirty seconds, no install, no upload.