CSV Viewer | Open and View CSV Files as a Table (Free, No Upload)
Open and instantly view any CSV file as a formatted table right in your browser — no upload, no installation, no sign-up. Choose the character encoding and delimiter, and your file never leaves your device.
| Delimiter |
|
|---|---|
| Use first line as header | |
| Encoding |
|
| CSV File |
What a CSV viewer does
A CSV file is just text with commas in it, so opening it raw makes it hard to see which value belongs to which column. A spreadsheet will turn it into a table, but it takes a while to launch, the Japanese text may come out garbled, and numbers can be converted into dates behind your back. This tool narrows itself down to one job: showing a CSV as a table in your browser so you can look at what is inside.
You can set both the character encoding and the delimiter, so Japanese CSVs saved as Shift-JIS and tab-separated TSV files are handled as well. The contents of the file are processed inside your browser alone and are never sent to a server, which means you can use it to check data that contains personal information.
How to use the CSV viewer
- Choose a file Point it at the CSV or TSV file you want to look at. Its contents are not sent anywhere outside your browser.
- Set the delimiter Comma is usually the right choice and you can leave it alone. Switch to tab if you have a TSV file.
- Match the encoding If the text is garbled, change it to Shift-JIS. Japanese CSVs saved out of Excel are often in that format.
- Decide about the header row If the first row holds the column names, turn on the option that treats it as a header and it will be shown as the table heading.
Tips for getting more out of it
- CSVs saved by Excel may use Shift-JIS (CP932) encoding, commonly used in Japanese/legacy Excel files. If you see garbled characters, select "Shift JIS".
- Enable "Use first line as header" to display the first row as a table header.
- To view TSV (tab-separated) files, change the delimiter to "Tab".
- File contents are processed entirely in the browser and are never sent to the server. CSVs containing sensitive data can be used safely.
When the CSV viewer comes in handy
Checking a file someone sent you
See straight away what columns it has and how many rows it holds, without waiting for a spreadsheet to start up. It suits getting a sense of a file before you open it properly.
Identifying the character encoding
When text comes out garbled, switching the setting and trying again tells you which encoding the file was actually saved in.
Avoiding reformatted numbers
Spreadsheets drop leading zeros and turn digits into dates. Use this when you want to see the original values exactly as they were written.
Viewing data that has to stay private
Because everything happens inside the browser, you can also inspect customer data and other files you are not allowed to upload anywhere.
CSV terms explained
- CSV
- A text format that lists values separated by commas. Every language and tool can read it, which is why it is so widely used for exchanging data.
- TSV
- A format that uses tabs as the separator. Its advantage is that it copes easily with data whose values contain commas.
- Shift-JIS
- A character encoding for Japanese. Excel often uses it when saving a CSV, and it is the main cause of garbled text.
- UTF-8
- The current standard encoding, able to represent the characters of every language. Most web services output in this format.
- BOM
- A marker placed at the start of a file to indicate its encoding. It is used to get Excel to open a UTF-8 CSV correctly.
- Header row
- The first row, which states what each column represents. Whether you treat it as a heading changes how the table is displayed.
FAQ
Side Note — The Surprising History of CSV: 40 Years Without a Standard
CSV (Comma-Separated Values) looks simple, but for many years there was no official standard specification. The formal RFC, "RFC 4180", was published in 2005 — more than 30 years after CSV came into widespread use. Until then, implementation differences between tools and languages caused issues like "whether to wrap fields in double quotes" and "whether to use CRLF or LF for line endings".
Excel's behavior of saving CSVs in Shift-JIS encoding in Japanese-locale environments has been a classic pain point for engineers for decades. Google Sheets exports in UTF-8, so opening that CSV directly in Excel causes garbled characters. To avoid this, save from Excel as UTF-8 (with BOM), or specify the encoding when importing.
In the world of data science, the vast majority of datasets published on Kaggle (the machine learning competition platform) are in CSV format. Its simplicity and universal compatibility with any programming language is CSV's greatest strength.