How to View a CSV File Online Without Excel (Even a Huge One)
Open a CSV as a table on a phone or computer, with no Excel. Search, sort, filter, fix garbled accents and read files past Excel's 1,048,576-row limit.
Updated November 7, 20269 min read
You can open a CSV file without Excel by dropping it onto the CSV Viewer. It shows the file as a scrollable table, and it works the same on a phone, a laptop or a work computer where you cannot install anything. It also handles files that Excel refuses to open in full: a worksheet stops at 1,048,576 rows, and anything past that is silently left out. The viewer has no row limit, so a file with millions of lines is still readable from the first record to the last. Everything runs on your device, not our servers.
Why you might not want to use Excel for a CSV
A CSV is a plain text file, and a spreadsheet is a heavy way to read one. Excel has to import it, guess what each column holds, and then it may change what it finds: long numbers are shortened, leading zeros disappear and some codes turn into dates. If you only want to look, that is a lot of risk. Why CSV files open wrong in Excel covers those problems in detail, so this guide stays on the other half: reading the file without Excel at all.
There are also plain practical reasons. You may be on a phone, on a Chromebook, on a locked-down work machine, or on a computer with no Office licence. Or the file may be too big. Excel's limits are fixed, and a CSV export from a shop, an analytics tool or a database can pass them without warning.
| Situation | Excel | CSV Viewer |
|---|---|---|
| More than 1,048,576 rows | Stops at row 1,048,576 and drops the rest | Every row is reachable; no row limit |
| More than 16,384 columns | Stops at column XFD | No column limit |
| Need to see the file untouched | Converts values while importing | Shows the text as it is written |
| On a phone or tablet | Needs an app and a licence for full use | Opens in the page, pick a file with Browse files |
| Just checking a file before use | Slow to open when the file is large | Readable grid in a moment |
How to open a CSV file online, step by step
Open the viewer and add your file
Go to the CSV Viewer and drop the file onto the page, or tap Browse files and choose it. On a phone, pick it from your Files app or downloads. CSV, TSV, TXT and PSV files are accepted.
Check what was detected
Above the table you will see the delimiter, the character encoding and whether the first row was treated as a header. If the columns look wrong, change Delimiter, Character encoding or First row is a header. The file is re-read without you adding it again.
Scroll and look
The row and column counts are shown above the grid. Scroll to read, or use Go to to jump to a line number such as 42.
Narrow it down
Type in Search every column to find text anywhere in a row, or open the Column filter section to describe a condition such as a number above a threshold.
Sort, then export if you need to
Click a column header to sort. When the view shows what you want, download it as CSV, TSV, JSON or NDJSON, or copy it to the clipboard.
View a CSV as a table with search, sorting and filters. Free: files up to 250 MB with no row or column limit. Pro: file size limited only by your device, and several files open at once. It runs on your device, not our servers.
Open a CSV fileOpening a very large CSV file
Large files fail in two ways. Some tools send the file to a server, which is slow and means your data has left your computer. Others load every cell into memory and the tab stops responding. The viewer reads the file in the background, notes where each row begins, and draws only the rows currently on screen. Scrolling a file with a million rows therefore feels like scrolling a short one.
The free limit is 250 MB per file. As a rough guide, a CSV of about 70 MB holds around a million rows of ten short columns, so 250 MB covers most exports people actually receive. Row count depends on how wide each row is, not just file size, so a file with long text columns holds fewer rows in the same space. Pro lifts the size cap to whatever your device can handle. If a file is larger than your device copes with comfortably, the viewer shows a warning that it may be slow, rather than failing silently.
A phone has much less memory than a computer. A file of a few megabytes is easy on any phone, while a file near the 250 MB limit is better opened on a laptop.
Search, filter and sort what you opened
Reading a table is rarely the goal. You usually want one answer out of it. These are the controls that exist in the viewer, and they combine.
- Search every column finds text anywhere in a row. It has Regex and Match case options if you need them.
- Column filter applies a condition to one column: contains, does not contain, equals, does not equal, starts with, ends with, matches regex, is empty, is not empty, greater than, at least, less than, at most, or between two values.
- Several column filters can be active together, and the search applies on top of them. The count above the table says how many rows are shown.
- Click a header to sort a column. Numbers sort as numbers (9 before 10) and dates as dates, and blank cells always go to the bottom. Shift-click a second header to break ties with it.
- Column statistics gives rows, filled, blank, distinct, sum, mean, median, min and max for a column over the rows in view.
If you want to keep the result as a file rather than just read it, use the viewer's export, or use the dedicated Filter CSV and Sort CSV tools. An export contains what you see: the rows that passed your filters, in your sort order, without hidden columns.
For files with many columns, Show the selected row as a list lays a single record out as labelled lines, which is easier than scrolling sideways. You can also hide columns you do not need and use Freeze the first column so the identifying column stays visible.
Delimiters: when everything is in one column
CSV does not mean the same separator everywhere. Many European exports use a semicolon because the comma is the decimal mark. Others use a tab or a pipe. The viewer tests comma, semicolon, tab and pipe, and picks the one that gives the same number of columns on the first rows, ignoring anything inside quotes. If it picks wrongly, choose the right one under Delimiter; the table redraws at once.
Garbled accents and strange symbols
If a name like José appears as José, or you see black diamonds with question marks, the file was saved in one character encoding and read as another. The viewer detects UTF-8, UTF-16 (both byte orders), Windows-1252 and ISO-8859-1 from the start of the file and its byte pattern, and it removes the invisible UTF-8 marker that otherwise sticks to the first column name.
| What you see | Likely cause | Try this encoding |
|---|---|---|
| José, Müller | UTF-8 file read as a Windows encoding | UTF-8 |
| Jos�, M�ller (diamonds) | A Windows file read as UTF-8 | Windows-1252 |
| Letters with gaps, or a single column of odd characters | UTF-16 text read as single bytes | UTF-16 little endian or big endian |
| A strange symbol before the first column name | A UTF-8 marker left in the name | Handled automatically by the viewer |
Open the Character encoding list and try the likely candidate. Because the file is read again each time, you can compare choices in seconds and see which one makes the accents correct. Once it looks right in the table, any export from the viewer is written as UTF-8 text.
When a row looks wrong
Real exports are sometimes damaged. A row with an extra comma pushes every value one column to the right, and a quote that is never closed can swallow the rest of the file into one cell. The viewer counts rows whose number of fields does not match the header, tints them in the table and lists them with their line numbers. Clicking an entry jumps to that line. An unclosed quote is reported as well. Blank rows are kept, so line numbers match the file on disk.
To work with the file after viewing it, convert it to Excel with typed columns, or turn it into data for a program with CSV to JSON. A spreadsheet file can be read the same way in the Excel viewer.
What the viewer cannot do
- It is a reader. You cannot edit cells and save the changes back into the original file. Filter or sort, then export a new file.
- It reads CSV, TSV, TXT and PSV. A file saved as .xlsx should be opened in the Excel viewer, and a file with a .csv name that is really binary is rejected with a message.
- Free reads files up to 250 MB. A larger file needs Pro, or you can cut it into parts first.
- On Free, one file is open at a time. Pro allows several open files at once.
- A very large file on a phone can be slow, because the limit is the memory of the device.
Frequently asked questions
How do I open a CSV file online without Excel?
Open the CSV Viewer, drop your file on the page or tap Browse files, and it appears as a table. Search, sort and filter work straight away, and the file is read on your device and not uploaded.
How can I open a CSV file with more than a million rows?
Excel stops at 1,048,576 rows per worksheet. The CSV Viewer has no row limit, so every row is readable. Free handles files up to 250 MB, and Pro raises that to what your device can manage.
Can I open a CSV file on my phone?
Yes. Open the viewer in your phone's browser, tap Browse files and choose the CSV from your files. Small and medium files are fine. Very large ones are better opened on a computer, because a phone has less memory.
Why are the accents in my CSV garbled?
The file was saved in one encoding and read as another. Open the Character encoding list in the viewer and try UTF-8, Windows-1252 or UTF-16 until the letters look right.
Why is my whole CSV in one column?
The separator is probably a semicolon, tab or pipe instead of a comma. The viewer detects it automatically, and you can choose the right one under Delimiter if it guessed wrong.
Can I edit a CSV in the viewer?
No, it is for reading. You can filter, sort and hide columns, then export the view as CSV, TSV, JSON or NDJSON. To edit values, convert the file to a spreadsheet.