CSV Viewer
Open a CSV file or paste CSV text and read it as a clean table. Sort any column, search and filter rows, page through large files, and export the filtered result as CSV, JSON or a Markdown table. The viewer never converts your values, so leading zeros and long numbers stay exactly as they are. Your file is read in your browser and is never uploaded.
or paste text below
Encoding applies to files. If you see characters like é instead of é, try Windows-1252.
Exports contain every row that matches your search, in the current sort order, not just the visible page.
What a CSV file is, and why it causes trouble
A CSV (comma-separated values) file is plain text in which each line is a row and a separator character divides the cells. The format is simple and universal, which is why it is the standard way to exchange tables between databases, survey tools, spreadsheets and statistics software. A common description of the format is RFC 4180 (Shafranovich, 2005), but in practice files vary: some use semicolons or tabs, some wrap fields in quotes, and some are saved in different text encodings.
Because the format is so loose, opening a CSV can go wrong in quiet ways. A viewer that shows the raw cells first lets you check what is really in the file before anything is converted or changed.
Problems you can spot by viewing first
| Problem | What it looks like | What to check here |
|---|---|---|
| Wrong separator | Everything lands in one column, or columns are split in odd places | Switch the separator, or use auto-detect. Many European exports use semicolons because the comma is their decimal mark. |
| Wrong encoding | Accented letters become strange pairs such as é | Try Windows-1252 or ISO-8859-1 instead of UTF-8. |
| Lost leading zeros | Postcode 05400 becomes 5400 in a spreadsheet | This viewer keeps the text exactly as stored. Check the original value here. |
| Long numbers rewritten | A 16-digit ID appears as 1.23457E+15 in a spreadsheet | The viewer shows the full digits. Keep such columns as text when you import elsewhere. |
| Names turned into dates | Gene names such as SEPT1 or MARCH1 become dates in Excel | This is a known problem in published gene lists (Ziemann et al., 2016). Check the raw values before importing. |
| Ragged rows | Some rows have more or fewer cells than the header | The warning above counts them. Usually an unquoted separator inside a text field. |
| Quoted fields | A cell such as “Smith, Anna” contains the separator | It is shown as one cell, as the quotes intend. |
How sorting works here
Click a column heading to sort ascending, again for descending, and a third time to return to the original order. Columns that are mostly numbers sort by value, so 9 comes before 10 and 100. Text columns sort alphabetically, ignoring case, where “10” would come before “9” because the character 1 comes before 9. Empty cells always go last. Columns whose values have leading zeros, like postcodes and codes, are treated as text so that their zeros are never dropped.
Worked example you can check by hand
The sample has six rows and five columns: id, name, city, zip and score. Two names are quoted because they contain a comma, for example “Smith, Anna”. The zip column holds values such as 05400 and 00012, and the last row has no score.
Sort score ascending. As numbers the order is 7, 9, 10, 85, 100 and the row without a score goes last. As text it would have been 10, 100, 7, 85, 9, which is why the viewer recognises numeric columns. Search “lahore” and only the first row remains, with its original row number 2 (the header is row 1). The zip column keeps its leading zeros throughout.
Opening CSV files safely
- Look before you convert. View the raw text, then decide how each column should be imported.
- Import as text where needed. Identifiers, postcodes, phone numbers and long codes should be text columns, not numbers.
- Prefer UTF-8. Save and share files as UTF-8 so names and symbols survive. Note the encoding in your documentation.
- Use quotes consistently. Wrap any field that contains the separator, a quote or a line break in double quotes, and double any quote inside it.
- Keep an untouched original. Re-saving a CSV from a spreadsheet can silently change values.
Frequently asked questions
Is my file uploaded anywhere?
No. The file is read in your browser with the standard File API, parsed with JavaScript on this page, and never sent to a server. You can confirm in the Network tab of your browser’s developer tools.
How large a file can it open?
Files up to about 30 MB are accepted, and several hundred thousand rows are fine on an ordinary laptop because only one page of rows is drawn at a time. Search and sort on very large files can take a moment. For bigger files, use a database or a command-line tool.
Can I edit the data?
No, this is a viewer. To change values, use a spreadsheet or text editor, or clean the file with the other data tools on this site, such as the Empty Column Remover and the Duplicate Rows Finder.
Why does one column sort strangely?
It probably contains a mix of numbers and text, so it is treated as text, or the numbers have leading zeros and are kept as text on purpose. Check the cells for notes or units typed into the column.
What does “Trim spaces around cells” do?
It removes spaces at the start and end of each cell when displaying and exporting. Turn it off to see the values exactly as stored, for example when hunting for stray spaces.
Which formats does the Markdown export produce?
A pipe table with a header row, ready to paste into GitHub, a wiki or a Markdown editor. Pipe characters inside cells are escaped, and the export is limited to the first 500 matching rows to keep it readable.
Further reading
- Shafranovich, Y. (2005). Common format and MIME type for comma-separated values (CSV) files. IETF RFC 4180.
- Ziemann, M., Eren, Y., & El-Osta, A. (2016). Gene name errors are widespread in the scientific literature. Genome Biology, 17, 177.
- Wickham, H. (2014). Tidy data. Journal of Statistical Software, 59(10), 1–23.