Format Code Now
/

CSV Viewer

FV-59

Paste CSV or open a .csv file to read it as a table. Click a column header to sort by it; click again to reverse, and a third time to get the file order back.

Runs in your browser. Nothing is uploaded.

CSV

Table

How to use it

  1. Paste CSV, or open or drop a .csv file.
  2. Leave Delimiter on Auto, or pick comma, semicolon, tab or pipe.
  3. Untick First row is header if your file has no header row.
  4. Click a column header to sort the rows.

How the file is read

Fields follow the RFC 4180 rules: a quoted field can contain the delimiter, a line break or a doubled quote, as in "Margaret ""Maggie"" H.". Auto picks the comma, tab, semicolon or pipe that appears most in the first line. Values are shown as text exactly as they are in the file, without number or date conversion. Rows with fewer fields than the widest row get empty cells, and the status line counts them.

Sorting

Each header is a button. The first click sorts ascending, the second descending and the third puts the rows back in file order. Numbers sort by value, whole numbers of any length are compared exactly, text sorts in natural order without regard to case, and empty cells always go last. Sorting only changes the view; Copy and Download give your CSV back unchanged.

Limits

The table shows up to 5,000 rows and 300 columns. Larger files are read in full, but only the first rows and columns are drawn, and the status line says so. It is a viewer: you cannot edit cells, filter rows or export the sorted order.

Error messages and what to do

MessageWhat it meansFix
There are no rows to show.The input has no data rows, only blank lines.Paste CSV text or open a file that has at least one row.

Questions people ask

How do I open a CSV file without Excel?

Open the file with the Open file button, drop it on the input box or paste its text. The table appears straight away, with the header row as column names. Nothing is installed and no spreadsheet program is needed.

Why are my columns not split correctly?

The delimiter guess looks at the first line only. If that line has more of another character, such as commas inside a semicolon file, pick the delimiter by hand. Fields that contain the delimiter must be wrapped in double quotes.

Does the viewer change my numbers or dates?

No. Every cell is shown as the exact text in the file. Leading zeros stay, long numbers are not turned into scientific notation and dates keep their format. Sorting compares numbers by value, but the cells still show the original text.

Can I sort by more than one column?

Not at the same time. Each click sorts by one column, and ties keep their file order. You can sort by one column, then another, but the second sort replaces the first.

Is my CSV file uploaded?

No. The file is read and drawn as a table in your browser. Nothing is sent to a server, so it is safe for exports that hold customer or financial data.

About this tool

Reads CSV by the RFC 4180 rules: quoted fields can hold the delimiter, doubled quotes and line breaks. Auto picks the comma, tab, semicolon or pipe that appears most in the first line. Click a header to sort ascending, again for descending, and a third time to go back to the file order; numbers sort by value, big whole numbers are compared exactly, and empty cells go last. Values are shown as text exactly as read, without type changes. Rows with too few fields get empty cells. Up to 5,000 rows and 300 columns are shown; Copy and Download give your CSV back unchanged.

Format Code Now: free, no ads, no accounts. Your input stays in your browser.