Free Tools Tutorial
Free Tools are browser-based utilities that run entirely on your device, like Free CSV Editor, Fuzzy Matching Tool and CSV Diff. 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 Data Cleaning Tools. See all free tools.
Quick Overview
| Tool | What it does | What it is best for |
|---|---|---|
| Free 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 |
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. Nothing leaves your browser and no data is stored.
Your files stay private. Every free tool processes data locally in your browser. Read the privacy policy.
How to choose
Use Free 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
Data Cleaning Tools.
Free 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.
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.
- Diff shows duplicate keys. Choose a column with unique values as the key column.
- Large file is slow. Use streaming mode in Free CSV Editor or process in smaller batches.
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.