What you get
Each tool does one job and shows what it changed, so you can see how many rows and cells were affected before you download. Values are not guessed or reformatted: dates, IDs such as 007 and amounts stay as written unless you choose a step that changes them.
Use the steps you need in the order below, downloading each result and opening it in the next tool.
How to clean a CSV file step by step
Tidy cells and rows
Trim spaces, collapse repeated spaces, remove empty rows and columns, and export with a comma, semicolon, tab or pipe delimiter. Open CSV Cleaner.
Remove duplicate records
Match on the whole row or on key columns such as email or order ID, optionally ignoring case. The first occurrence is kept. Open Remove Duplicate Rows.
Validate before importing
Add rules such as required, unique, number range, YYYY-MM-DD date or allowed values, and download a list of every failing cell. Open CSV Rules Validator.
Combine several exports
Stack CSV files into one, keeping every column and recording which file each row came from. Open CSV Batch Consolidator.
Add columns from a second file
Join a lookup CSV by a key column, like an exact-match VLOOKUP, and see which rows found no match. Open CSV Join / Lookup.
Split into smaller files
Create one file per column value, such as region, or a new file every set number of rows. Each file keeps the header. Open CSV Segmenter.
Synthetic example
Illustrative, made-up inputs and the result to expect. Review your own output before using it.
- Input
export.csv (synthetic): id , name , city 001, Sample A ,Springfield ,, 002,Sample B,Shelbyville 001,Sample A,Springfield
- Settings
CSV Cleaner: Trim cells, Remove empty rows, Remove duplicate rows
- Result
id,name,city 001,Sample A,Springfield 002,Sample B,Shelbyville The summary counts the trimmed cells, the empty row and the duplicate row removed.
When to use it, and its limits
A good fit when
- An export from a shop, CRM, form or bank has stray spaces, blank lines, repeated records or the wrong delimiter for the app you are importing into.
- You need to check a file against simple rules before an import, and want a list of exactly which cells fail.
- The data contains customer or business records that should stay on your device rather than be uploaded.
Limits to know first
- Free, without an account: CSV Cleaner and Remove Duplicate Rows take 256 KB of text, 500 data rows and 100 columns per job. Validation, join, combine and split jobs also take 500 data rows, with up to 10 validation rules, 2 files to combine and 20 split files.
- A no-card trial, Plus or Pro raises these per-job limits; each tool page lists the exact values.
- These tools read CSV text. Excel workbooks need converting to CSV first with XLSX to CSV.
- The validator reports problems and never fixes them; correct the source and run it again. Join keys match exact text, and duplicate checks do too unless you turn on Trim cells or Ignore case.
- Remove Duplicate Rows reports how many rows it removed but does not list the removed rows.
Frequently asked questions
How do I clean a CSV file without Excel?
Open the file in CSV Cleaner, switch on the steps you need, such as Trim cells, Remove empty rows and Remove duplicate rows, check the summary and table preview, then download the clean CSV. It runs in your browser with no upload.
How do I remove duplicate rows by email?
Open Remove Duplicate Rows, choose the email column as the matching column and turn on Ignore case if capitalisation varies. The first row for each email is kept in its original order.
How do I check a CSV before importing it?
Use CSV Rules Validator: add a rule per column, such as Required, Unique, ISO date or Allowed values, and run it. errors.csv lists every failing cell with its row, column, rule and value. A passing check does not guarantee another app will accept the file.
Can I split a large CSV into smaller files?
Yes. CSV Segmenter splits one file by column value or every set number of rows, and each output file keeps the header row. Free jobs produce up to 20 files from a CSV of up to 500 data rows.
Is my CSV uploaded?
No. These website tools process the file in your browser tab, and the data is not sent to BoringKit or kept in browser storage.
How big a CSV can I clean for free?
Free jobs need no account and accept up to 256 KB of text and 500 data rows per job, with no daily quota. A trial, Plus or Pro allows larger files.
Tools for this job
- CSV Cleaner: trims cells, removes empty rows and columns, dedupes and changes the delimiter.
- Remove Duplicate Rows: removes repeated records by whole row or chosen columns.
- CSV Rules Validator: checks columns against rules and lists every failing cell.
- CSV Join / Lookup: adds columns from a lookup file by a key column.
- CSV Segmenter: splits a CSV by column value or row count.
- XLSX to CSV: turns an Excel sheet into CSV before cleaning.