Data preparation

Data Cleaning Tool: Find Missing Values, Duplicates, Typos and Outliers in Your Spreadsheet

Before any analysis, your sheet needs to be clean. Paste or upload it and this tool checks every column for missing-value codes, extra spaces, inconsistent spellings (“Control”, “control “, “Contrl”), numbers typed as text (“3,45”, “4.1 kg”), duplicate rows and extreme values. Review the suggested fixes, apply the ones you agree with and download a clean CSV with a log of every change.

✅ No login needed100% freeRuns in your browserYour data stays on your device
Data Cleaning Tool✅ Free · no login📚 Cite this tool
Your data never leaves your PC. Your data is analysed on your own computer or phone, even when you upload a CSV or Excel file. Nothing is uploaded, stored or seen by Codanics, and no login is needed.

Fixes to apply

  • PriceFree, no login or sign-up needed
  • Your dataProcessed in your browser, never uploaded
  • Works onPhone, tablet or computer, any modern browser
  • Made byDr. Muhammad Aammar Tufail, Codanics
  • Published17 November 2026
  • Last updated16 November 2026

📚 How to cite this tool

This tool is free. If it helped your thesis, paper, report or assignment, please cite it. It keeps the tools free and helps other students find them.

Citation · APA 7th edition

Tufail, M. A. (2026). Data cleaning tool: find missing values, duplicates, typos and outliers in your spreadsheet [Online tool]. Codanics. Retrieved 16 November 2026, from https://codanics.com/tools/data-cleaning-tool/

In-text citation: (Tufail, 2026) · Narrative: Tufail (2026)

The access date is today’s date, filled in automatically. Author: Muhammad Aammar Tufail. Published 17 November 2026.

🚀 Follow Codanics channel on WhatsApp for more updatesNew free tools, scholarships, PhD positions and research tips, straight to your phone. Free lessons on YouTube too.

How to use the data cleaning tool

  1. Paste your sheet (with column names in the first row) or use Upload CSV / Excel. The example is a deliberately messy field-trial sheet.
  2. Choose which fixes to apply. Trimming spaces, standardising missing codes, merging spellings, fixing numbers stored as text and removing duplicate and empty rows are on by default.
  3. Click Check and clean. Read the summary and warnings, review the suggested category merges (untick any you disagree with) and check the extreme values against your records.
  4. Download the clean CSV and the change log, or copy the clean table back into Excel. Keep the original file and the log together so your cleaning is documented.

What the tool checks

ProblemExampleFix
Extra spaces” PGPR”, “Biochar “Trimmed, so they count as the same category
Missing-value codesNA, N/A, -, ., ?, #N/AWritten the same way (empty, NA or .)
Inconsistent spellingsControl / control / Contrl, Biochar / Bio-char, Akbar-2019 / Akbar 2019Merged to the most frequent spelling (case, spaces, hyphens and 1–2 letter typos)
Numbers stored as text“4,56”, “4.1 kg”, “1 250”Converted to 4.56, 4.1 and 1250
Duplicate rowsPlot 304 entered twiceSecond copy removed
Empty rows and columnsA blank line in the middle of the sheetRemoved
Extreme valuesHeight 1050 cm among values near 100Flagged (3 × IQR rule) so you can check them; optionally blanked

Worked example

The example sheet has 18 rows from a field trial with four treatments. The tool trims spaces, merges “control”, “Contrl”, “pgpr”, “Bio-char” and “AKBAR-2019″/”Akbar 2019” into the main spellings, converts “4,56” and “4.1 kg” to numbers, turns “-“, “NA” and “N/A” into proper missing values, removes the duplicate plot 304 and the empty row, and flags the plant height of 1050 cm, which is almost certainly 105.0. The result is 16 clean rows ready for the field-trial ANOVA.

Good habits for clean research data

  • One row per observation, one column per variable, one value per cell. Put units in the column name (Yield_kg), not in the cells.
  • Use one missing-value code consistently and never use 0 or 999 for “missing”.
  • Use drop-down lists (Data validation in Excel) for categories to stop spelling variants at the source.
  • Never overwrite your raw file: keep it read-only, and save the cleaned file and the change log next to it.
  • After cleaning, check your variables with the descriptive statistics calculator and the outlier test calculator.
Learn the statistics behind these numbers. Codanics has free statistics, R and Python lessons on YouTube and full courses for researchers.

Frequently asked questions

How do I find and fix inconsistent categories like 'Male', 'male' and 'M '?

Paste your data and keep ‘Merge inconsistent category spellings’ ticked. The tool groups values that differ only in case, spaces, hyphens or a one- or two-letter typo, shows the proposed merges and keeps the most frequent spelling. Abbreviations such as ‘M’ for ‘Male’ are not merged automatically because they could be different categories.

Will the tool change my original file?

No. Your file is read in the browser, and you download a new clean CSV. The original stays untouched, and the change log lists every cell that was changed.

How are numbers with decimal commas handled?

With ‘Detect’, a value like 4,56 (one comma, not three digits after it) is read as 4.56, and 1,250 is read as 1250. If your whole sheet uses decimal commas, choose ‘Always decimal comma’.

Why are extreme values only flagged and not removed?

An extreme value can be a typing error or a real observation. Check flagged values against your notebook or field sheet first. If you are sure they are errors and cannot be corrected, tick ‘Blank out extreme values’.

Can it handle large files?

Yes, files with tens of thousands of rows work in a modern browser. The preview shows the first 50 rows, and the download contains everything.

Is my data uploaded?

No. All checks run in your browser and nothing is uploaded or stored.

Do I need to log in or create an account to use the data cleaning tool?

No. There is no login, no sign-up and no email required. Open the page and start using it straight away, for free, on any device.

How do I cite this tool in my thesis or paper?

Use the citation box on this page. In APA 7th edition: Tufail, M. A. (2026). Data cleaning tool: find missing values, duplicates, typos and outliers in your spreadsheet [Online tool]. Codanics. Retrieved [date you used it], from https://codanics.com/tools/data-cleaning-tool/. BibTeX, RIS (EndNote, Mendeley, Zotero), MLA, Harvard, Chicago and Vancouver formats are also available.

Free guides and courses from Codanics

More free tools

See all free Codanics tools → · Codanics on YouTube · WhatsApp channel

Made by Dr. Muhammad Aammar Tufail, Codanics. First published 17 November 2026, last updated 16 November 2026. Found a bug or have an idea for a new tool? Tell us on the WhatsApp channel or in the comments on YouTube. Results are for learning and planning; check important analyses with a statistician or your supervisor.