1. Home
  2. Spreadsheets & Data
  3. CSV Table Viewer

CSV Table Viewer

Turn CSV or cells copied from Excel into a sortable, searchable table.

Runs in your browser · No upload

Delimiter used: comma

Choose columns (5/5)
#
1Jane DoeMarketing2021-03-0272000remote, 2 days
2John SmithEngineering2019-11-18118000
3Ann LeeSales2017-07-0196000Team lead (acting)
4Max KimEngineering2022-01-1084000"New" hire
5Sara ParkMarketing2020-09-2179000
Showing 5 of 5 rows
Rows
5
Columns
5
Export (visible columns, with the current sort and search)
Result
| 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<br>(acting) | | Max Kim | Engineering | 2022-01-10 | 84000 | "New" hire | | Sara Park | Marketing | 2020-09-21 | 79000 | |

Your text and files are processed in this browser and never uploaded.

How to use

  1. 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.
  2. 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.
  3. 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.
  4. 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.

Can't find the tool you need?

Tell us what you want to do. We build the most requested tools first.