Excel Data Cleaner screenshot

Excel Data Cleaner

Trim spaces and remove empty rows from pasted cell data.

Privacy First
0 Runs
Updated 2026-11-07
Runs in your browser
No account needed
Nothing sent to a server
Line-based, not a spreadsheet parser

Trim spaces and remove empty rows from pasted cell data. Enter your numbers and get an instant result.

Paste tabular text and this page applies three optional rules — collapse whitespace, drop empty rows and remove duplicate rows — plus an optional case change, then returns the cleaned text.

It works one line at a time. A line is treated as a single cell, so a comma-separated line is one value rather than several columns, and duplicate removal compares whole lines rather than a key column.

Collapsing whitespace replaces every run of spaces with a single space and trims both ends. On quoted CSV that means a value quoted to preserve its spacing loses it.

The order the rules are applied in

Each line is first collapsed and trimmed if that rule is on, then dropped if it is now empty, then re-cased, and only then checked against the set of lines already kept.

Because duplicate detection happens after the case change, `Apple` and `apple` become duplicates under lowercase but not with no case change. Order the rules in your head the same way the page does or the count will surprise you.

With all three rules off, the output is the input with only the blank-line behaviour applied, which makes the page a quick way to see exactly what a rule changes.

  • 1. Collapse and trim whitespace
  • 2. Drop a line that is empty
  • 3. Change case
  • 4. Drop a line already seen

What it cannot tidy

It does not parse columns. Two rows with the same values in a different field order are different lines and both survive.

It also does not fix a stray quote or a broken line ending, because it never parses the quoting. If your data has embedded commas inside quotes, split it into real columns before pasting it here.

How to use the cleaning rules

Paste the tabular text, tick Cleaning Rules for collapsing whitespace, dropping empty rows and removing duplicates, and choose a Normalizing Case of lower, upper, title or none. Each rule applies one line at a time.

Read the Cleaned Output; duplicate removal compares whole lines, so a comma line is one value rather than columns. Collapsing trims both ends, which also strips spacing a quoted CSV value was preserving.

What to Expect

Best for

  • Collapsing ragged spacing in a list copied out of a document
  • Removing blank lines and exact duplicate lines from a pasted column
  • Normalising one column of names to upper, lower or title case

Not ideal for

  • A real spreadsheet file, which this page cannot open
  • Deduplicating on one key column while keeping other columns intact
  • CSV with quoted fields that contain commas or newlines

What this tool keeps

  • The order of the surviving lines
  • Everything after the first whitespace collapse, including punctuation
  • A line that looks duplicated but differs in a character

What may need cleanup

  • A line that held several columns and is now one value
  • Quoted spacing that the collapse rule removed
  • Duplicates that differ only by case when no case change is selected

Common errors

  • Pasting CSV and expecting separate columns
  • Enabling duplicate removal and case change together and losing rows you wanted to compare
  • Expecting embedded quotes and commas to be understood

Example use cases

  • Cleaning a column of email addresses before a mail merge
  • Removing repeated lines from a pasted list of tags
  • Normalising a list of names to title case

Sample input

Four lines: two comma-separated pairs, a blank line, and a padded pair.

Sample output

Three lines, the doubled space collapsed to one and the blank line removed.

Who this is for

  • People tidying a column pasted out of a document
  • Analysts preparing a list before an import
  • Anyone who needs a quick deduplicate on plain lines

Frequently asked questions

Which rules does the data cleaner apply?

Optionally collapse whitespace, drop empty rows, remove duplicate rows and change case, then return the cleaned text.

Can it deduplicate on one key column?

No. Rows are compared whole, so deduplicating on one column while keeping the others needs a spreadsheet.

Why did a line with several columns become one value?

The whitespace collapse rule joins the columns, so leave that rule off when the spacing carries meaning.

Developer program

Build custom tools for your store

Join the SDK program to create useful ecommerce utilities for your store.