Skip to content
CSV Viewer
3 / 3 rows
namecityscore
AdaLondon10
AlanParis2
GraceLondon100

CSV Viewer

Open CSV files, sort columns, filter rows, and export CSV or JSON — free, private and running entirely in your browser

CSV Viewer opens on name,city,score with Ada, Alan, and Grace. Delimiter is Auto-detect and First row is header is on. File info: 3 rows, 3 columns, 59 B, delimiter ,.

Last updated: 15 October 2026

Guide, examples, and FAQ

About CSV Viewer

What it does

A built-in parser reads the text. A quote starts quoted mode, "" is one quote character, and a break inside quotes stays in the field. A blank line is dropped. Auto-detect counts commas, semicolons, and tabs in the first 10 lines, including inside quotes. The highest count wins; a tie keeps comma, then semicolon, then tab.

Who it is for

Someone opening one delimited text file to sort rows, filter them, or download that view.

When to use it

When the file is .csv, .tsv, or .txt. An .xlsx file is not opened here.

Key features

  • Delimiter

    Auto-detect shows the character it chose. Comma, Semicolon, and Tab force that character.

  • Header

    First row is header starts on. Off, the labels are Column 1, Column 2, and so on. An empty header cell is shown as Column N.

  • Filter and sort

    Filter rows… keeps a whole row if any cell contains the text, ignoring case. A header click cycles ascending, descending, off. Both numeric cells use parseFloat; otherwise the text is compared.

  • Four downloads

    All-rows CSV is the parsed file, named from the load or data.csv. Current-view CSV is the header plus the filtered, sorted rows. Both JSON buttons save data.json. Cells are strings. Copy copies the raw text.

How to use CSV Viewer

  1. 1Leave the sample, use Load file…, or turn Raw text on and paste. The table waits 100 milliseconds. The byte size does not.
  2. 2Leave Auto-detect, or choose Comma, Semicolon, or Tab.
  3. 3Type in Filter rows…. Click a header to sort. The corner shows shown rows, a slash, then data rows. No rows. appears when nothing matches.
  4. 4Download all rows or the current view. Cells cannot be edited.

Example

Before

name,city,score
Ada,London,10
Bo,Paris,2
Grace,London,100
Alan,London,20

After

Filter london, score descending: Grace,London,100 then Alan,London,20 then Ada,London,10. Current-view CSV is that header plus those three lines. All-rows CSV still has Bo,Paris,2 in file order.

Both JSON files are data.json. score is the string "100", "20", or "10", not a number. Bo is only in the all-rows JSON.

Benefits

  • Filter without changing the file

    Filter rows… hides rows on screen only. Download all rows still has every line; Download current view has the filtered, sorted list.

  • Sort by clicking a header

    One click cycles ascending, descending, then off. Numbers that look like numbers sort as numbers; other cells sort as text.

  • Four ways to take data out

    All-rows CSV, current-view CSV, all-rows JSON, and current-view JSON. JSON values stay text. Copy takes the raw source, not the sorted table.

  • Quoted commas stay in one cell

    A field like "Ada, Lovelace" stays one cell. Two quotes in a row inside quotes become one quote character.

Common use cases

  • Scan a large export

    Load the CSV, leave Auto-detect on, and scroll the table before you decide what to keep.

  • Find rows that mention a city

    Type london in Filter rows…. Paris drops out. Sort score descending to put 100 above 20 and 10.

  • Share only the filtered list

    After filtering and sorting, use Download current view. Download all rows still has every original line.

  • Open a semicolon export

    A European sheet that uses ; between columns: leave Auto-detect on, or pick Semicolon if the columns look wrong.

  • Check raw text next to the table

    Turn Raw text on to paste or edit the source, then turn it off to see the table again. Cells in the table are not editable.

Tips & best practices

  • Spaces alone in Filter rows… do nothing. The box is trimmed first.
  • A field that contains the delimiter, a quote, or a newline is quoted on export, and each quote is doubled.
  • Clear empties the source text and the loaded file name. Filter, sort, and delimiter settings stay as they are.

Common mistakes to avoid

  • Opening a semicolon file with Comma selected. Use Auto-detect or Semicolon. name;city is one cell per row if the delimiter is a comma.
  • Expecting Filter rows… to hide a column. It keeps or drops whole rows.
  • Downloading all rows and expecting the London-only list. All-rows CSV still contains Bo,Paris,2.
  • Opening an .xlsx file here. The chooser accepts .csv, .tsv, .txt, and text/csv.

Frequently asked questions

What does ascending score do to the sample?

Alan, then Ada, then Grace. File info stays 3 rows, 3 columns, 59 B, delimiter ,.

How is name;city with Ada; and Bo;London read?

Auto-detect chooses semicolon. The body rows are Ada with an empty city, and Bo with London.

What do the London downloads contain?

Current-view CSV follows Grace, Alan, Ada. All-rows CSV still has Bo in file order. Both JSON files are data.json, and score is a string.

Does the filter hide columns, and can I edit a cell?

No. A row stays if any cell contains the text. The table cells are not editable. Raw text shows the source, with placeholder Paste CSV….

Is there a row limit, and is the file sent?

There is no fixed row or file-size cap. Nothing is sent over the network. The text stays in this tab until you leave or clear it. A reload brings the sample back.

Can I choose an encoding?

No. Load file… reads the file as text in the browser. There is no encoding menu.

What does Copy output copy?

The raw source, including rows the filter hid. It does not copy the sorted table.

When another tool fits better

  • JSON Formatter. data.json is already indented and every value is a string. Open it there to minify that text or check it as JSON.
  • Excel Diff. The file is .xlsx or .xls, or two spreadsheets need the cells that differ. This page does not open .xlsx.
  • Text Diff. Two raw CSV texts need the line and word changes.

Conclusion

All-rows downloads skip the filter. Current-view downloads follow it.

Ready to try CSV Viewer?

Scroll back up to start now, or continue with another free developer tool.

Guides and glossary

Learn and reference material connected to CSV Viewer.