CSV Viewer and Cleaner

Opening a CSV in Excel is where a lot of data quietly breaks. Long numbers turn into scientific notation, leading zeros vanish from phone numbers and postcodes, and dates get rewritten into whatever format your machine happens to prefer. This CSV viewer opens the file in your browser and shows you exactly what is in it, character for character, before any of that happens. It works out the separator on its own, handles quoted fields containing commas and line breaks, highlights empty cells, and tells you when a row has more columns than the header. You can trim stray spaces, drop blank rows and save a clean copy. Nothing is uploaded, which matters because CSV files usually hold customer lists.

How to use

1. Drop your CSV file onto the box, or press Choose a file. You can also paste rows straight into the text area.
2. Leave the separator on Detect automatically. It reads the header line and picks whichever of comma, semicolon, tab or pipe is really being used.
3. Look at the table. Empty cells are shaded so gaps are obvious, and the note underneath warns you if any row has a different number of columns to the header.
4. Pick a clean up option if you need one. Trim removes spaces around every value; the second option also removes rows that are entirely blank.
5. Download the clean CSV, or copy it to paste straight into a spreadsheet.

Why use our csv viewer and cleaner?

The parser is the part that matters. Most quick CSV tools split on commas, which works until a value contains a comma inside quotes, or a line break inside a cell, and then every row after it is wrong. This one reads the file properly: quoted fields, doubled quotes as an escape, embedded newlines and the byte order mark that Excel adds to the front of files it saves. That is the difference between a viewer you can trust with a real export and one that quietly corrupts it.

It also tells you what is wrong rather than just showing you rows. Ragged rows are the most common problem in exported data and the hardest to spot by eye, because the file still looks fine until a column silently shifts. The warning names the count so you know whether it is one stray record or half the file. Large files stay usable too: the table shows the first two hundred rows so your browser is not asked to build fifty thousand of them, while the download and copy still give you everything.

Who is this tool for?

Anyone who receives CSV exports from a shop, a payment provider or a CRM uses this as the first stop, to see what actually arrived before importing it anywhere. It answers the practical question quickly: are the columns what I expect, is anything missing, and is the separator what the other system assumed.

It is also the safe way to look at a file containing personal data. Uploading a customer list to a random website to preview it is a genuinely bad idea and a lot of people do it anyway. Here the file never leaves the machine. Once the data is clean, our CSV to JSON converter turns it into something an API will accept, and JSON to CSV goes the other way.

Frequently asked questions