How to use CSV Viewer
- 1Paste your CSV text into the box
- 2The first line is treated as the header row
- 3Remaining lines render as table rows
- 4Scroll sideways if the table is wider than the screen
- 5Read the data without opening a spreadsheet
What CSV Viewer does
CSV is the most widely supported data format there is and one of the least standardised. Everyone agrees that rows are lines and fields are separated by commas; almost nothing beyond that is settled. Whether fields are quoted, what a quote inside a field looks like, whether the separator is really a comma — all of it varies by producer and by locale.
This viewer takes the simple reading: split on newlines, split on commas, treat the first row as headers, and strip one pair of surrounding quotes from each cell. That covers the great majority of exports and is instant. Where it does not fit, the limitation is stated plainly below rather than producing a table that is subtly wrong.
When to use it
- Checking an export before importing it
- Seeing whether the columns line up and the headers are what you expected takes seconds, and catches a mis-delimited export before it corrupts a database import.
- Reading data on a device without a spreadsheet
- A phone or a locked-down work machine often cannot open a CSV usefully. Pasting it into a page renders it readable without installing anything.
- Inspecting a fragment from a log or an API
- A few CSV lines pulled from somewhere else become legible immediately, without saving them as a file first.
- Confirming a file is CSV at all
- A download that will not open is sometimes tab-separated, semicolon-separated or actually HTML. Pasting it in shows immediately what you really have.
CSV Viewer settings explained
- Header row
- The first line is always treated as column headings and rendered separately. A file with no header will have its first data row displayed as headings, which is the trade-off for needing no configuration.
- Comma delimiter
- Fields are split on commas only. Semicolon-separated exports — common in locales where the comma is the decimal separator — need their separators replaced with commas first.
- Quote stripping
- One leading and one trailing double quote is removed from each cell, so quoted fields display without them. Quotes inside a field are left as they are.
- Cell trimming
- Leading and trailing whitespace is removed from every cell, so a file exported with a space after each comma still lines up correctly.
- Horizontal scrolling
- A wide table scrolls inside its own container rather than making the page scroll sideways, so a file with forty columns stays readable on a phone.
What this viewer handles
| Input | Handled? | Why |
|---|---|---|
| Plain comma-separated rows | Yes | The standard case |
| Quoted fields | Yes | Surrounding quotes are stripped |
| Spaces after commas | Yes | Cells are trimmed |
| Commas inside a quoted field | No | Splitting happens before quotes are considered |
| Newlines inside a quoted field | No | Rows are split on newlines first |
| Semicolon or tab separated | No | Only commas are treated as separators |
Limits and what to expect
- A comma inside a quoted field splits the row incorrectly, adding a column.
- A newline inside a quoted field starts a new row.
- Only commas separate fields — semicolon and tab-separated files are not recognised.
- The first row is always the header; there is no option to turn that off.
- This is a viewer, not an editor — cells cannot be changed, sorted or filtered.
Troubleshooting
- One row has more columns than the others
- A field in that row contains a comma inside quotes — an address or a description is the usual culprit. The parser splits on commas before it considers quoting, so the field is broken in two. A spreadsheet handles this correctly.
- Everything is in one column
- The file is not comma-separated. Semicolons are standard in locales where the comma is a decimal separator, and tabs are common in database exports. Replace the separators with commas and paste again.
- My data starts in the header row
- The file has no header line, and the first row is always rendered as headings. Add a line of column names above the data before pasting.
- A row is split across two table rows
- A field contains a line break inside quotes — usually a multi-line address or a comment. Rows are split on newlines before quoting is considered, so it becomes two rows. A spreadsheet is the right tool for that file.
Your files and your privacy
The text is parsed and rendered in your browser with no request to a server, and nothing is stored. This is the reason to use it over a hosted CSV viewer: exports are usually customer lists, order histories or financial records, and pasting those into someone else's service is a disclosure whether or not anything is retained.
What to use next
FAQ
Why is my CSV all in one column?
It is not comma-separated. Semicolons are the standard separator in locales that use the comma as a decimal mark, and tabs are common in database exports. Replace the separators with commas before pasting — this viewer only splits on commas.
Why does one row have an extra column?
A field in that row contains a comma inside quotes, typically an address or a free-text description. The parser splits on commas before it considers quoting, so that field is broken into two. A spreadsheet parses quoting properly and is the right tool for such a file.
Can I edit or sort the data?
No, this displays only. Nothing can be changed, sorted or filtered. It exists to make a CSV readable quickly, not to replace a spreadsheet.
What if my file has no header row?
The first line is always rendered as headings, so your first record would be displayed as column names. Add a line of column names above the data before pasting.
Is there a size limit?
No limit is enforced, but the whole table is rendered at once, so a file with tens of thousands of rows will make the page sluggish. Paste a sample if you only need to check the structure.
Is my data uploaded?
No. Parsing and rendering happen in your browser with no network request, and nothing persists after the tab closes.