How to use
- Copy a table from Excel or Google Sheets (Ctrl+C) and paste it into the box. You can also drop a CSV or TSV file. Markdown tables are read too.
- The delimiter (comma, tab, semicolon or pipe) is detected automatically. Pick one yourself if it guesses wrong. Whether the first row is a header is also detected, and you can override it.
- Click a column header to sort, use the search box to filter rows, and Choose columns to hide columns. Switch to Column stats for a per-column summary.
- Pick Markdown, HTML, JSON, CSV or TSV, then copy or download. Hidden columns are left out, and the current sort and search are applied.
What the column stats show
| Item | Meaning |
|---|---|
| Type | Number, Text or Empty |
| Filled, Blank | Cells with a value and cells without (whitespace only counts as blank) |
| Unique | Number of distinct values |
| Min, Max, Mean, Median, Sum | Only for number columns |
| Most common | The three most frequent values and their counts |
A column counts as a number column when at least 90% of its non-empty cells are numbers. Cells that are not numbers are left out of the math, and the count of ignored cells is shown. Numbers with thousands separators such as 1,234.5 are read as numbers.
Example
name,department,start_date,salary,note
Jane Doe,Marketing,2021-03-02,72000,"remote, 2 days"
John Smith,Engineering,2019-11-18,118000,
Ann Lee,Sales,2017-07-01,96000,"Team lead
(acting)"
Max Kim,Engineering,2022-01-10,84000,"""New"" hire"
Sara Park,Marketing,2020-09-21,79000,
Even with a cell holding a comma, a cell holding a line break and a cell holding quotes, the five people are read as five rows. The first three rows exported as Markdown look like this.
| name | department | start_date | salary | note |
|---|---|---|---|---|
| Jane Doe | Marketing | 2021-03-02 | 72000 | remote, 2 days |
| John Smith | Engineering | 2019-11-18 | 118000 | |
| Ann Lee | Sales | 2017-07-01 | 96000 | Team lead (acting) |
In the column stats of the same data, salary is a number column with min 72,000, max 118,000, sum 449,000, mean 89,800 and median 84,000. department has 3 unique values, with Engineering and Marketing twice each.
How CSV is read
The file is read according to the CSV standard (RFC 4180).
- A cell containing a comma or line break is wrapped in double quotes, and a quote inside a cell is written twice as
"". - Line endings may be CRLF, LF or CR, a leading BOM is removed, and blank lines are skipped.
- A line with a different number of fields than the first line is reported with its line number, for example
Line 4: 1 fields (the first line has 2). Missing cells were filled with blanks.Line numbers follow the real lines of the file, even when a quoted cell contains line breaks. - A quote that is never closed stops the read with an error naming the line where the quote began.
- If the file is not valid UTF-8 it is read again as EUC-KR, the usual case for Korean files saved from Excel as “CSV (comma delimited)”. Files with a UTF-16 BOM are read too.
- Limits are 50,000 rows, 500 columns and 20 MB. If there are more rows, only the beginning is processed and you are told so.
FAQ
Can it open an .xlsx file?
This tool reads CSV, TSV and pasted tables. For xlsx, copy the cells from Excel and paste them, or open the file in Excel & CSV Workbench.
How do I turn a CSV into a Markdown table?
Choose Markdown table in the export section. Column widths are padded to line up (wide CJK characters count as two), and number columns are right-aligned. You can change the alignment.
Will a leading zero in a ZIP code disappear?
The table shows values as plain text, so it stays. When exporting JSON with “Numbers and true/false as values” turned on, values like 04524 that start with 0, and values longer than 15 digits, are still kept as text.
The text looks garbled.
Files that are not UTF-8 are read as EUC-KR automatically. If it is still garbled, save the original again from Excel as “CSV UTF-8” and reload it.
I only want counts and sums per column.
The Column stats view is for that. If you also need rule-based validation to find bad rows, use Column Statistics.
Related tools: JSON to Table, Transpose, Dedupe & Sort Table, Markdown Table Generator, Excel to HTML Table
Your text and files are processed in this browser and never sent to a server.