CSV Viewer
Open a CSV file and see it as a clean table you can sort, search, and expand to fullscreen. Values are shown exactly as they are in the file, so leading zeros and long numbers stay intact. Everything runs in your browser, so your file is never uploaded.
Paste a CSV above or open a file, and it shows up here as a table.
What the CSV viewer does
A CSV file is easy for programs to read but hard for people, since it is a wall of text and commas. This viewer turns it into a table with a header row that stays in place while you scroll and row numbers down the side. You can sort by any column, search for rows, and click a cell to read its full value. Fullscreen gives the table the whole screen when a file has many columns. It only reads the file. Nothing in it is changed unless you download a new copy.
Why use our CSV viewer
- ·No upload. Files are read on your device, so private data stays private.
- ·Values shown as written. Unlike Excel, it does not drop leading zeros, round long numbers, or turn text into dates.
- ·Big files stay fast. Files up to 50 MB open, and only the rows on screen are drawn.
- ·Fullscreen view. Give wide tables the whole screen, with search and sort still working.
- ·Free. No signup and nothing to install.
How to open a CSV file online
- 1
Open or paste your CSV
Click the folder button to open a .csv, .tsv, or .txt file, drag the file onto the box, or paste CSV text. The file is read on your device and never uploaded.
- 2
Browse, sort, and search
The rows show up as a table right away. Click a column name to sort, type in the search box to find rows, and click any cell to read its full value.
- 3
Go fullscreen for a bigger view
Click the fullscreen button to give the table the whole screen. Press Esc or click Exit fullscreen to go back. Download the rows you found as a new CSV if you need them.
What is a CSV file?
CSV stands for comma separated values. It is a plain text file that holds a table: each line is a row, and commas split the row into columns. The first line usually holds the column names. Almost every spreadsheet, database, and online service can export and import CSV, which is why it is so common. Here is a small one as plain text:
name,city,zip "Hopper, Grace",New York,10001 Ada Lovelace,London,01234
A value that contains a comma, a quote, or a line break is wrapped in double quotes, like "Hopper, Grace", so the comma inside it does not start a new column. A quote inside a quoted value is written twice (""). The viewer follows these rules (from RFC 4180) and shows the file above as a table:
| name | city | zip |
|---|---|---|
| Hopper, Grace | New York | 10001 |
| Ada Lovelace | London | 01234 |
Some files use a tab (TSV), a semicolon, or a pipe instead of a comma. The viewer detects those too.
CSV viewer options
- Delimiter
- Auto detect looks at the first row and picks comma, tab, semicolon, or pipe, whichever splits it into the most fields. The detected delimiter is shown under the input. Set it by hand if the columns look wrong.
- First row is a header
- On by default, so the first row becomes the column names. Turn it off when the file has no header row, and the columns are named Column 1, Column 2, and so on.
- Search
- Shows only the rows that contain your text, with the match marked in each cell. It ignores upper and lower case and matches part of a cell, so lon finds London. Pick a column next to the box to search only that column.
- Sort
- Click a column name once to sort A to Z (or smallest to largest), again for Z to A, and a third time to go back to the file's order. Columns where every value is a plain number sort by value, and other columns sort as text with numbers in order, so item 2 comes before item 10. Empty cells always go to the bottom.
- Cell details
- Cells show one line and cut off long text. Click a cell to see its full value, including line breaks, below the table, and copy it with one click.
- Fullscreen
- Gives the table the whole screen, with search, sort, and cell details still working. Where the browser allows it, the page goes fully fullscreen. On phones and in browsers that do not allow it, the table fills the browser window instead. Press Esc to leave.
- Download
- Saves the header and the rows in the table as a CSV file, in the order shown. After a search or sort, only the matching rows are saved, in that order, so you can use the viewer to pull a smaller file out of a big one.
Why a CSV file looks wrong in Excel
When you double click a CSV, Excel guesses what each value is and changes some of them on screen. If you then save the file, the changes become permanent. These are the most common ones:
- ·Leading zeros are missing. Excel reads 01234 as the number 1234 and drops the zero, which breaks zip codes, phone numbers, and ids. The file itself still has the zero. This viewer shows every value exactly as it is written in the file.
- ·Long numbers show as 1.23457E+11. Excel shows numbers with 12 or more digits in scientific notation, and only keeps 15 significant digits. If you save the file again, a 16 digit card or order number can end in zeros. Here, long numbers are shown in full.
- ·Values turned into dates. Excel changes text like 1-2 or MAR1 into dates when it opens a CSV. The CSV still has the original text, which you can check here before anyone saves over it.
- ·Everything is in one column. In many European countries, Excel expects semicolons instead of commas, so a comma separated file opens with every row squeezed into column A (and the other way around). This viewer detects the delimiter for you.
- ·Accented letters look garbled. When Excel opens a UTF-8 CSV with a double click, it often reads it in the older Windows encoding, so é shows up as é. This viewer reads UTF-8 correctly, and falls back to Windows-1252 for files Excel saved that way, with a note so you can check.
To open a CSV in Excel without these changes, use Data, then From Text/CSV, instead of double clicking. It lets you choose the file encoding and delimiter, and you can set columns like zip codes to Text before the data loads.
Other ways to open a CSV file
| App | How | Good to know |
|---|---|---|
| Microsoft Excel | Data, then From Text/CSV | Up to 1,048,576 rows. Double clicking the file can change values (see above). |
| Google Sheets | File, then Import, then Upload | Up to 10 million cells. The file is uploaded to Google Drive. |
| LibreOffice Calc | Open the file and pick options in the Text Import window | Free. Lets you set the delimiter and column types first. |
| Apple Numbers | Open the file in Numbers | Free on Mac. |
| A text editor | Notepad, TextEdit, or VS Code | Shows the raw text exactly, but not as a table, so columns are hard to follow. |
Use this viewer when you only need to look at the data, do not have a spreadsheet app, or do not want to upload the file anywhere.
Who uses a CSV viewer
- ·Anyone without Excel. Look at a CSV on a Chromebook, a work computer where you cannot install software, or a phone, with nothing to install.
- ·People checking an export. See what a bank statement, an online store's order export, or a CRM contact list really contains before you import it somewhere else.
- ·Developers and data teams. Check the output of a script or a database export, find a row by id, and see whether a column has blanks or odd values, without opening a spreadsheet that might change them.
- ·People with private data. Customer lists, payroll exports, and medical records should not go to an online converter. Here the file never leaves your device.
Frequently asked questions
- How do I open a CSV file online?
- Click the folder button above and pick your .csv file, or drag it onto the box. It opens as a table right away, with nothing uploaded. You can also paste CSV text into the box.
- How do I view a CSV file in fullscreen?
- Click the fullscreen button in the top right of the table. The table takes up the whole screen, and search, sort, and cell details keep working. Press Esc or click Exit fullscreen to go back to the page.
- Can it open large CSV files?
- Yes, files up to 50 MB. The table only draws the rows on screen, so scrolling stays smooth even with hundreds of thousands of rows. Files over 1 MB are shown in the table but not in the text box, to keep the page fast. How big a file you can open also depends on your device's memory.
- Can I open a CSV file that is too big for Excel?
- Excel stops at 1,048,576 rows, and Google Sheets at 10 million cells. This viewer has no row limit of its own, so a file under 50 MB with more rows than Excel allows still opens in full.
- Can I edit the CSV here?
- Not in the table. For files up to 1 MB, you can change the CSV text in the box above the table and the table updates as you type. To keep only some rows, search for them and download the result.
- Why are all my columns squeezed into one?
- The file uses a different delimiter than expected. Auto detect picks the one that splits the first row into the most fields, which works for almost every file. If it guesses wrong, choose comma, tab, semicolon, or pipe in the Delimiter menu.
- Why do some rows have empty cells at the end?
- Those rows have fewer fields than the header, and the viewer fills the gap with empty cells. A warning above the table tells you how many rows are affected. It usually means a missing delimiter or an unclosed quote in the file.
- Can it open TSV files?
- Yes. Tab separated files (.tsv) open the same way, and the tab delimiter is detected for you.
- Is my CSV uploaded anywhere?
- No. The file is read and shown in your browser, so your data never leaves your device. The tool is free with no signup.