Skip to content
Allin
Sign up · Sign in

CSV cleaner

Trim spaces, drop empty rows and remove duplicates from a CSV.

Related tools

All Transform & clean tools →
Add line numbersPrefix every line of your text with a sequential line number.Alphabetize wordsSort all the words in your text into alphabetical order.Alternating case (mocking) generatorTurn text into aLtErNaTiNg CaSe for the mocking meme style.Bionic reading converterTurn any text into bionic reading format, which bolds the first part of each word so your eye can move faster while the brain fills in the rest. Adjust the fixation strength, see a live styled preview, and copy a Markdown version to paste anywhere that supports bold.Case converterConvert text to UPPERCASE, lowercase, Title Case or Sentence case.Toggle caseSwap uppercase to lowercase and vice versa for every letter.Comma-separated ↔ linesConvert a comma-separated list into lines, or lines back into a comma list.Remove repeated charactersCollapse runs of the same character into one (helllo → helo).

Open CSV cleaner and you get an answer straight away, with no account to create. You will find it under Transform & clean, with Add line numbers and Alphabetize words for the neighbouring cases.

How to use it

  1. Open the tool — no signup or install needed.
  2. Enter your input or adjust the available options.
  3. Get your result instantly, then copy or download it.

Frequently asked questions

What is CSV cleaner?

Trim spaces, drop empty rows and remove duplicates from a CSV.

When would I actually use this?

Cleaning up a paste before it goes anywhere: stripping duplicates from a list, normalising case, removing accents for a filename, or sorting lines.

What is the most common mistake?

Sorting text as if it were ASCII. Accented letters land after Z in a byte sort, which puts "Zurich" before "Émile" and produces a list no reader will accept.

What else is filed next to it?

Add line numbers, Alphabetize words and Alternating case (mocking) generator share its section. They are not variants of it — being filed together is not the same as being alike — but that is where to look if this turned out not to be the tool you wanted.

Where do the figures come from?

Transformations use the browser's Unicode-aware string handling, so case changes and sorting respect the locale rather than byte order. Nothing is truncated: what comes out is the whole of what went in.

Further reading

All guides →
ExplainerCSV to JSON: The Five Cases That Break Every ConverterQuoted delimiters, embedded newlines, ambiguous types, duplicate headers and encoding. Each one was run through the converter and the exact output is printed here — including the two cases it does not rescue.ExplainerWhy Your CSV Breaks Accents and Dates in ExcelThree completely different faults hide behind the same sentence. One is the encoding, one is the separator, one is Excel guessing at types while it opens the file — and the fix for each is different. Here is how to tell them apart in five seconds.GuidePasting a Table Into a Pull Request: What Breaks, and the Two Characters That Break ItA Markdown table has exactly two forbidden characters in a cell: the pipe and the line break. Here is what each one does, how a converter handles them, why the escape has to be applied in the right order, and why padding never matters.ExplainerSemicolon, Tab, Pipe: Choosing a Delimiter That Survives the TripWhy the reader's language decides the delimiter, what the converter does to the quoting when you switch, what the sep= first line really is, and the count of quoted cells on the same export written five ways.How-toNumbering the Lines of a Text for a Review with Several PeopleNumbering starts at 1 and cannot be set to 0, the alignment is spaces rather than zeros, and the remover undoes eight of the eleven separators without touching the indentation. What it still cannot do is tell your numbers from its own.ExplainerSentence Case and Title Case: The Rules Differ by LanguageEnglish title case has three different cutoffs depending on the style guide. French, Spanish, Portuguese and Italian have none at all. German capitalises every noun. The tool knows about none of this — here is exactly what it does.