Open a CSV or TSV file as a table, up to 50MB: sort by any column, search every row, and scroll through a million rows without Excel. Comma, semicolon, tab and pipe files are detected for you.
Nothing is uploaded. The file is opened in your browser and never sent anywhere.
This CSV viewer online opens a .csv, .tsv or .txt file as a table in your browser and shows every value exactly as the file has it, so you can sort, search and scroll a million rows without Excel reformatting anything. It's for the export you need to check before you trust it: a German bank statement that arrives semicolon-separated with amounts like 1.234,50, or a customer list where you want to know whether the ZIP column really says 02134 before an import runs.
The file is read in your browser, in a background worker so the page doesn't freeze, and nothing is uploaded. There's nothing to download either: the viewer is for reading.
The viewer doesn't convert anything. There are no number formats, no date guessing and no formulas, so the table is the file.
| In the file | In the viewer |
|---|---|
02134 in a ZIP column | 02134 |
| An 18-digit order ID | All 18 digits |
"Smith, John" in quotes | One cell: Smith, John |
"" inside a quoted field | One literal quote |
| An address with line breaks inside quotes | One cell, the breaks shown as ↵; click it to read the lines in full |
| A short row with fewer fields than the rest | Padded with blank cells, so nothing shifts left |
| Blank lines | Skipped |
| A number such as 1,250.00 | Right-aligned; text is left-aligned |
| UTF-8 (with or without a byte-order mark), UTF-16 with a byte-order mark | Read as such, and the encoding is named under the table |
| An older Excel export that isn't valid UTF-8 | Read as Windows-1252, so Müller shows as Müller |
| An .xlsx file renamed to .csv | A message saying it is an Excel workbook, not a CSV file, with a link to the Excel Viewer |
Headings and row numbers stay in view while you scroll, and column widths fit the headings and the first 1,000 rows. The parser is the same one the CSV to Excel converter uses, so a file that splits correctly here on Auto splits the same way there.
A CSV has no types. Every value is text, and when Excel opens one it guesses what each value is meant to be. With the default settings in Excel for Microsoft 365, several of those guesses destroy data:
None of that is in the file. It happens as Excel opens it, and if you save over the CSV afterwards, the zeros and digits are gone for good. A viewer that shows the text as written is how you find out which side is wrong: if the viewer shows 02134, the export is fine and Excel dropped the zero.
Excel for Microsoft 365 lets you switch some of this off under File > Options > Data > Automatic data conversion. Clearing those boxes keeps leading zeros and long numbers as text, but it doesn't stop every conversion, and it applies only to your copy of Excel. The colleague you send the file to still gets the defaults.
Sorting starts from Excel's rules. Going up, numbers come before text (going down, text comes first), blanks go last in both directions, and rows that tie keep their file order. Text is where it parts company with Excel: the viewer sorts it in natural order, ignoring case, so item2 comes before item10, where Excel's A to Z would put item10 first. Numbers with thousands separators, a leading $, €, £ or ¥, or a trailing % sort by value, and so do amounts written 1.234,50 in a semicolon file. That's the German bank statement from the opening, sorted by amount rather than alphabetically.
Search matches text anywhere in a row, ignoring case, but within one cell at a time. It never matches the heading row. The line under the table counts what's left, as in "2 rows of 5 match", and if you've sorted, the matches come out sorted by that column.
The row numbers are each row's place in the file, with the heading row as row 1, which is how Excel numbers a CSV it opens. They stay attached when you sort or search. Sort a payouts export by Amount, and the largest payment still shows that it was row 3,417 of the file.
Size is the hard part for a table in a web page. The viewer draws only the cells in view, a few hundred at a time, and fetches rows 200 at a time as you scroll. In a test on the production build in Chrome, a 1,000,000-row, 6-column, 50MB file opened in 1.3 to 2 seconds, sorted by a text column in about 1.5 seconds and filtered by a search in about 1 second, and scrolling reached the last row.
The only size limit is the 50MB file cap, not a row count, so a CSV longer than Excel's 1,048,576-row sheet opens too. A 1,200,000-row, 3-column, 21MB file opened in about 0.9 seconds, and scrolling reached row 1,200,000. Excel's sheet would stop 151,424 rows short.
When you need the data in Excel rather than a viewer, import it instead of double-clicking it. Go to Data > From Text/CSV and pick the file. In the preview window, set File Origin to 65001: Unicode (UTF-8) if the accents look wrong, check the Delimiter box, and set Data Type Detection to Do not detect data types. Click Load.
Every column arrives as text, so ZIP codes, long IDs and dates stay exactly as written. The cost is that numbers you want to add up are text too, and SUM ignores them until you convert those columns. For a file with more than Excel's 1,048,576 rows, the same dialog can load it to the Data Model through Load To, where a PivotTable can summarise it without the rows ever landing on a sheet.
If the file turns out to be an Excel workbook rather than a CSV, the Excel Viewer opens .xlsx, .xls, .xlsb and .ods files as a grid in your browser, without uploading them. Going the other direction, Excel to CSV writes a sheet out as a UTF-8 CSV that opens here and in Excel with its accents intact.
Drop the file on the CSV viewer at the top of this page, or paste the text and click View as table. It opens .csv, .tsv and .txt files up to 50MB as a table in your browser, with the delimiter detected for you. Nothing is uploaded and there's no sign-up.
Open it in a CSV viewer, which shows the rows as a table without converting anything, or in a text editor such as Notepad, which shows the raw text. A text editor doesn't line the columns up, and a quoted address with a line break in it looks like two rows. The viewer lines them up, keeps that address in one cell and shows every value as written, so leading zeros and long IDs stay intact.
The file is UTF-8 and was read as Windows-1252, which turns each accented letter into two odd characters. Excel does this when you double-click a UTF-8 CSV that has no byte-order mark. This viewer reads UTF-8 with or without the mark and names the encoding under the table; in Excel, import through Data > From Text/CSV with File Origin set to 65001: Unicode (UTF-8).
No. The viewer is read-only: cells can't be edited and there's no download. To get the data into a workbook you can edit, run the file through the CSV to Excel converter on this site.
If it's under 50MB, open it in this viewer, which has no row limit apart from the file size: a 1,200,000-row, 21MB test file opened in about 0.9 seconds, and scrolling reached the last row. The viewer is read-only, though. To work with the data in Excel, use Data > From Text/CSV, choose Load To, then Only Create Connection with Add this data to the Data Model ticked, and summarise it with a PivotTable.
Drop it on this viewer: it reads .tsv files and detects the tab delimiter, and the Delimiter menu shows Auto (Tab) so you can confirm it. In Excel, Data > From Text/CSV reads tab-separated files too, with Tab chosen in the Delimiter box.
Yes, with no usage limit and no sign-up. Files can be up to 50MB, and they are read in your browser, never uploaded.