Free Standard Data Cleaning Tutorial
Free Tools are browser-based utilities that run entirely on your device, like CSV Editor , Fuzzy Matching Tool , CSV Diff and Plagiarism Checker. They work without an account and without uploading files, making them ideal for quick checks and sensitive data. For larger, repeatable workflows inside Google Sheets, use Standard Data Cleaning. See all free tools.
Quick Overview
| Tool | What it does | What it is best for |
|---|---|---|
| CSV Editor | Inspects, cleans, deduplicates, filters, sorts and transforms CSV files with a health report | Preparing a single file for analysis or import |
| Fuzzy Matching Tool | Scores similarity between two lists and flags near-duplicates | Matching names and emails across two lists |
| CSV Diff | Compares two CSV files by a key column and reports added, removed and changed rows | Reconciling two exports of the same dataset |
| Plagiarism Checker | Compares texts or documents and highlights verbatim and reworded passages | Checking writing against sources you already have |
TIP 1: Use the tutorial links on each tool page to jump to the relevant section. All tools work offline after the page loads.
TIP 2: For sensitive files, prefer the free tools. File contents never leave your browser. Anonymous page views are counted.
Your files stay private. Every free tool processes data locally in your browser. Read the privacy policy.
How to choose
Use CSV Editor for a single file, Fuzzy Matching Tool for two lists and CSV Diff for two files. When you need to run the same logic inside Google Sheets on thousands of rows, move to
Standard Data Cleaning.
CSV Editor
The Free CSV Editor opens large CSV and TSV files in your browser, even files over 100 MB using streaming mode. It shows a health report and lets you filter, sort and transform without uploading.
Steps
| Step | Action | Details |
|---|---|---|
| 1 | Open file |
Drag and drop or use
Open CSV.
Try sample data to explore. Large files open in streaming mode.
|
| 2 | Inspect health |
Check the
Health
strip and
Health
panel for duplicates, empty rows and outliers.
|
| 3 | Clean |
Use
Filter
,
Find and Replace
and
Transform
to trim, change case and remove columns or rows.
|
| 4 | Export |
Open
Export
to choose delimiter, line ending and encoding, then download CSV, TSV or JSON.
|
Example
Open a vendor list, use
Filter
to show empty emails, then
Transform
to trim and title-case names. Press
Export
to download the cleaned file.
Fuzzy Matching Tool
The Fuzzy Matching Tool scores how similar two lists are, perfect for catching typos and near-duplicates like "Jon Smith" and "John Smyth".
Steps
| Step | Action | Details |
|---|---|---|
| 1 | Paste lists |
Paste values into
List A
and
List B
, one per line.
|
| 2 | Choose options |
Pick
Mode
and
Header
, then set
Similarity
with the slider.
|
| 3 | Match and review |
Press
Match
to see scores and the distribution bar. Lower the threshold to find more matches.
|
| 4 | Export |
Use
Copy
or
Download CSV
for results above the threshold.
|
Example
Paste customers into List A and a master list into List B, set
Similarity
to 85 percent and press
Match.
Review pairs above 85 percent as likely duplicates.
CSV Diff
The CSV Diff compares two CSV files by a key column and shows added, removed and changed rows with a match rate.
Steps
| Step | Action | Details |
|---|---|---|
| 1 | Load files |
Load
File A
and
File B.
Check
First row is a header
if needed.
|
| 2 | Pick key column |
Choose
Key column: rows matched by this column
on each side. The tutorial suggests a shared header when available.
|
| 3 | Compare |
Press
Compare
to see added, removed and changed rows by key.
|
| 4 | Download |
Use
Download diff CSV
for the full result.
|
Example
Load last month and this month exports, pick
id
as the key column on both sides, then
Compare.
Review
added
for new customers and
changed
for field-level edits.
Plagiarism Checker
The Plagiarism Checker compares your text against documents you supply and highlights verbatim passages in red and reworded passages in amber. Nothing is uploaded to any server.
Steps
| Step | Action | Details |
|---|---|---|
| 1 | Add texts |
Paste into
Text A
and
Text B
, open .txt files or switch to
Multiple files
to add up to 20 documents.
|
| 2 | Set sensitivity |
Reworded sensitivity
controls how aggressively paraphrased sentences are flagged. Verbatim matches are always detected.
|
| 3 | Run the check |
Select
Check similarity
for two files or
Compare all pairs
in matrix mode.
|
| 4 | Review and export | Hover highlights for scores, click matrix cells to inspect a pair, then download the CSV report. |
Possible Issues
- No rows after filter. Clear the filter or check the column selection.
- No match found. Lower the similarity threshold and inspect candidate pairs.
- Large file is slow. Use streaming mode in Free CSV Editor or process in smaller batches.
- Diff shows duplicate keys. Choose a column with unique values as the key column.
Frequently Asked Questions
Do free tools upload my files?
No. Every free tool runs entirely in your browser. Files are read locally and never uploaded.
Which tool should I use for deduplication?
Use Free CSV Editor to deduplicate rows inside one file. Use Fuzzy Matching Tool to score similarity between two lists and find near-duplicates across lists.
How do I compare two CSV files?
Open CSV Diff , load File A and File B, pick the key column on each side, then press Compare to see added, removed and changed rows.
Can I use these tools for large files?
Yes. Free CSV Editor uses streaming mode for very large files. Fuzzy Matching Tool handles thousands of rows in the browser. For larger, repeatable jobs, use Data Cleaning Automation.
Where is my session stored?
In your browser only. Use Export or Download to keep a copy. Use Discard to clear a saved session.