> text csv

View and clean up a table (CSV)

The export from the cash register, the customer list from the old program, the file Excel opens wrongly: here you see what is in it, tidy it up and save it so that Excel understands it.

JavaScript is turned offThis tool works in your browser and needs JavaScript for that.

Choose CSV file

or just drag it here.

CSV · TXT · TSV · UP TO 20 MB · STAYS ON YOUR DEVICE

Read

Delimiter

First row is the headerThe column names come from the first row; it is not sorted or counted

Clean up

Remove blank linesRows without content are dropped Remove duplicate rowsIf a row is already there character for character, only the first stays Trim spaces at the edges“ Miller ” becomes “Miller”, in every cell Straighten quotation marksLeftover quotation marks around values go, "" becomes ", curly ones (“ ” ‘ ’) become straight

Remove or reorder columns

Untick a box and the column disappears from the table and the output. The arrows move a column to the left or right.

Table

Show long cells in fullOtherwise the table shows the first 36 characters with … after them; you see the whole cell when you point at it with the mouse, and download and copy always contain it

Output as

Delimiter

Character set

Preview

More for text: Sort and count lines · Compare texts

Your table stays on this device. Nothing is uploaded or saved.

How it works

01Choose a CSV file or paste text. Delimiter (semicolon, comma, tab, vertical bar) and character set are detected; if something does not fit, you change it.
02Check the table: a tap on a heading sorts the column, and below number columns you see the total and the average. Clean up as needed, leave out or reorder columns.
03Download or copy as CSV, Markdown table or JSON. For Excel in Germany, semicolon plus UTF-8 with BOM is already set.

Reading follows the CSV standard (RFC 4180): Values in quotation marks may contain delimiters and line breaks, and a doubled quotation mark stands for a single one. The first 200 rows are shown, and the first 36 characters of each cell; everything is always calculated, downloaded and copied. Numbers are read the German way (1.250,50), also with euro or percent signs; “1,250” is therefore read as 1.25. Anything that starts with a zero before more digits (01.2024, 01067) counts as a code, not a number. Columns whose name sounds like a number or an identifier (No., ID, postal code, phone, IBAN, account, year) deliberately get no total. Up to 20 MB per file. What is in a cell is never changed, unless you switch it on under “Clean up”.