How to Clean Up a List Online

Q: How do I clean up a messy list online?

Paste your list into the Data Cleaner tool . Select a preset that matches your data type (Quick Clean, Email, Numbers, Dates, etc.) or enable individual options manually. The output updates instantly.

Dirty data is the most common reason a list comparison produces wrong results. Two items that look identical can compare as different because one has a trailing space, a null marker where the other has a blank, or a date written as "06/12/2026" where the other says "2026-06-12". Cleaning your list before working with it fixes all of this in one pass.

Clean your list now. Paste, select a preset, copy.

Open Data Cleaner →

Start with a preset

The Data Cleaner has six presets that group the most useful options for common data types. Pick the one closest to your data and adjust from there:

Quick Clean: trims whitespace, removes blank lines, and replaces common null markers. Good starting point for any list.
Email: lowercases everything, trims whitespace, removes blank lines. Normalises email lists for deduplication or import.
Numbers: strips currency symbols, normalises decimal separators, removes thousands separators. Turns "$1,234.56" into "1234.56".
Address: trims whitespace, normalises capitalisation, removes extra internal spaces. Reduces formatting variation in address data.
Database: replaces null markers (NULL, n/a, none, -) with blank, trims whitespace, removes blank lines. Useful for exports from SQL databases or spreadsheets.
Dates: detects and normalises common date formats to a consistent output. Handles US, European, and ISO date formats.

The most common cleaning problems

Trailing whitespace

Trailing spaces are invisible but they break comparisons. "apple" and "apple " are different strings. The Data Cleaner's trim option strips leading and trailing whitespace from every line. It's on by default in every preset.

Null markers

Data exports represent missing values in different ways: NULL, null, N/A, n/a, none, None, -, or just an empty string. If two systems use different conventions, they'll never match. The Replace Null Values option converts all common variants to a single blank line (or a value you specify).

Inconsistent date formats

One system exports "12/06/2026" and another exports "2026-06-12". They mean the same date but compare as different. The Dates preset attempts to detect the format each line is using and convert everything to a consistent output. It handles US dates (MM/DD/YYYY), European dates (DD/MM/YYYY), ISO dates (YYYY-MM-DD), and common variations with different separators.

Currency and number formatting

Price data from different regions uses different decimal and thousands separators. "$1,234.56" in US format and "1.234,56" in European format represent the same number. The Numbers preset strips currency symbols and normalises separators so numeric values are consistent and sortable.

When cleaning is not enough: invisible characters

If your list still has items that look identical but won't match after cleaning, the culprit is usually an invisible character that the standard trim doesn't catch: a non-breaking space (Unicode 0x00A0), a zero-width space (0x200B), or a carriage return (0x000D) embedded in the middle of a line.

Paste your list into the Invisible Character Detector to see every hidden character annotated with its type. The cleaner's Strip Invisible Characters option can then remove them automatically.

Clean first, then compare

If you're about to compare two lists that came from different systems, clean both lists with the same settings before comparing. Apply the same preset to List A and List B, copy each cleaned output, then run the comparison. This way the diff reflects real differences in the data rather than formatting differences in how each system exported it.

Compare your cleaned lists

Find what's only in A, only in B, in both, or in either.

Compare Two Lists →

Frequently Asked Questions

How do I clean up a messy list online?

Paste your list into the Data Cleaner tool. Select a preset that matches your data type (Quick Clean, Email, Numbers, Dates, etc.) or enable individual options manually. The output updates instantly.

Why do my lists not match even though they look identical?

Almost always invisible characters or whitespace differences. A trailing space, a non-breaking space, or a hidden carriage return makes two lines compare as different even though they look the same on screen. Run your list through the Invisible Character Detector first to see what's actually in each line.

How do I remove blank lines from a list?

Enable Remove Blank Lines in the Data Cleaner options, or use the Quick Clean preset which includes it. You can also do this in Text Fixer if you need to combine it with other text transformations.

How do I standardise null and empty values?

The Data Cleaner has a Replace Null Values option that converts common null markers (null, NULL, n/a, N/A, none, None, -, empty) to a blank line or a value you specify. This is part of the Database and Quick Clean presets.

How do I clean up date formats in a list?

Use the Dates preset in the Data Cleaner. It attempts to detect common date formats and normalise them to a consistent output format. It handles US dates (MM/DD/YYYY), European dates (DD/MM/YYYY), ISO dates (YYYY-MM-DD), and several variations with dashes, slashes, or dots.

How do I strip currency symbols from a list of prices?

Use the Numbers preset. It strips common currency symbols ($, euro, pound, yen) and normalises decimal separators so 1,234.56 and 1.234,56 are treated consistently. The output is clean numeric strings ready for sorting or importing.

What is the difference between Data Cleaner and Text Fixer?

Data Cleaner is focused on normalising dirty input data: replacing null markers, fixing dates, stripping currency, removing hidden characters. Text Fixer is for transforming and reformatting clean data: sorting, deduplicating, changing case, adding prefixes, splitting on delimiters. Use the Cleaner first, then the Fixer if you need further transformation.

Should I clean my data before comparing lists?

Yes, almost always. If two lists came from different systems they likely have subtle formatting differences: different whitespace, different null representations, different date formats. Cleaning both lists first with the same settings means your comparison will find genuine differences, not formatting noise.