Skip to content
BoringKit

Use case

Clean up a messy CSV export

To clean a messy CSV export, open it in CSV Cleaner to trim stray spaces, drop empty rows and columns and fix the delimiter, then remove duplicates by a key column such as email and check the result against your import rules. Every step runs in your browser with no upload, and Free jobs need no account for files up to 256 KB and 500 data rows.

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

  1. 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.

  2. 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.

  3. 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.

  4. Combine several exports

    Stack CSV files into one, keeping every column and recording which file each row came from. Open CSV Batch Consolidator.

  5. 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.

  6. 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