CSV Viewer
View, sort, filter, and analyze CSV/TSV files online. Paste or upload data to explore in an interactive table with column statistics and type detection.
Updated
CSV Viewer
View, sort, filter, and analyze CSV and TSV files online. Paste data or upload a file to explore your data in a powerful interactive table.
CSV Input
Drag & drop a .csv or .tsv file here, or click to browse
Paste CSV data or upload a file to get started.
Related Tools
Frequently Asked Questions
What is the CSV Viewer?
The CSV Viewer is a free online tool that view, sort, filter, and analyze csv/tsv files online. paste or upload data to explore in an interactive table with column statistics and type detection.. It runs entirely in your browser with no installation or sign-up needed.
What delimiters?
Auto-detects comma, semicolon, tab, and pipe. Manual override available if auto-detection does not match.
Can I filter and sort?
Yes — click column headers to sort (asc/desc), use per-column text filters, and a global search bar. Pagination at 25/50/100/all rows.
Can I export filtered data?
Yes. Download the current filtered/sorted view as CSV, or copy as TSV for pasting into spreadsheets.
Is the CSV Viewer free to use?
Yes, the CSV Viewer is 100% free with no registration, no hidden fees, and no usage limits. All processing happens locally in your browser, ensuring complete privacy.
Does the CSV Viewer work on mobile devices?
Yes, the CSV Viewer is fully responsive and works on smartphones and tablets. You can use it on any device with a modern web browser -- no app download required.
Do I need to create an account to use this tool?
No account or registration is needed. Simply open the CSV Viewer in your browser and start using it immediately. There are no sign-up walls or usage restrictions.
How do I use the CSV Viewer?
Simply enter your input in the provided field, adjust any settings to your preference, and the tool will process it instantly. You can then copy the result to your clipboard or download it.
Which browsers are supported?
The CSV Viewer works in all modern browsers including Chrome, Firefox, Safari, Edge, and Opera. For the best experience, use the latest version of your preferred browser.
What is the difference between a CSV and a TSV file?
CSV (comma-separated values) and TSV (tab-separated values) are both plain-text formats that store a table as rows of fields, but they differ in the character used to separate columns. CSV uses a comma, which is convenient until your data itself contains commas — like addresses or prices — forcing fields to be wrapped in quotes. TSV uses a tab, which rarely appears inside real values, so it often needs no quoting and pastes cleanly into spreadsheets. Semicolons and pipes are common alternatives, especially in regions where the comma is a decimal separator. This viewer auto-detects comma, semicolon, tab, and pipe delimiters by sampling the first lines, and lets you lock the delimiter manually if the guess is wrong. Drop either format above to open it instantly.
How does the CSV viewer handle commas and line breaks inside a field?
Properly formatted CSV escapes tricky values by wrapping them in double quotes, so a field like "Boston, MA" stays in one column even though it contains a comma. The same applies to line breaks inside a cell and to literal double quotes, which are written as two quotes ("") inside the quoted field. This viewer uses a state-machine parser that follows those rules, so addresses, free-text notes, and multi-line comments land in the correct column instead of splitting and shifting every value after them. That is the most common reason a CSV looks misaligned in a basic text editor. If your export uses quoting correctly, the table will render cleanly here. Paste or upload your file above to see whether your quoted fields parse the way you expect.
How does the tool detect whether a column is a number, date, or text?
Each column is profiled by checking its non-empty values against number, date, and boolean patterns, then classified as whichever type at least 80% of those values match. Anything that does not reach that threshold is treated as text, and a column with no values at all is marked empty. The 80% rule matters because real exports are messy — one stray label or a "N/A" placeholder in an otherwise numeric column should not change the column's type. Type detection also drives smarter behaviour: numeric columns sort by value, so 9 correctly comes before 100 instead of being ordered like words. Each header shows a small badge for its detected type, giving you a quick read on the data's shape. Load your file above and check the badges to confirm columns are typed as you expect.
What statistics can I see for each column?
The Statistics tab profiles every column without writing a single formula. For all columns it reports the non-empty count and the number of unique values, which is a fast way to spot missing data or confirm that an ID column has no duplicates. For columns detected as numeric, it additionally calculates the minimum, maximum, and average. That is usually enough to sanity-check an export at a glance: confirm a price column has no negatives, see the date range covered by a log, or catch a field that is unexpectedly mostly blank before you trust the file. Because the stats are computed in your browser from the parsed data, they update with your file and never leave your device. Open the Statistics tab after loading your data to get an instant profile of each column.
Why are my CSV columns misaligned when I open the file?
Misaligned columns almost always mean the parser split a row on the wrong character. The usual causes are a delimiter mismatch — your file uses semicolons or tabs but is being read as comma-separated — or unquoted values that contain the delimiter, so one field bleeds into the next and pushes every later value over by a column. Inconsistent row lengths, a missing header, or stray quote characters can produce the same symptom. This viewer reduces those problems by auto-detecting the delimiter and correctly handling quoted fields, but if a row still looks off you can manually lock the correct delimiter from the dropdown or toggle the header row. Try switching the delimiter above; if the columns snap into place, that was the issue, and you can then export a cleanly quoted CSV.
Related Tools
Free Secure Password Generator
Generate secure, random passwords with customizable options. Free, fast, and works entirely in your browser with no sign-up required.
Free UUID/GUID Generator
Generate universally unique identifiers (UUIDs/GUIDs). Free, fast, and works entirely in your browser with no sign-up required.
Free QR Code Generator Online
Create QR codes for URLs, text, WiFi, and contacts. Customize colors, size, and error correction. Free, private — runs in your browser, no sign-up.
Free JSON Formatter & Validator
Format, validate, and beautify JSON data with syntax highlighting and error detection. Free, fast, and works entirely in your browser with no sign-up required.
About the CSV Viewer
The CSV Viewer is a free online tool for opening, exploring, and making sense of delimited data files without a spreadsheet program. Paste your data or drag a .csv or .tsv file onto the page and it renders an interactive table you can sort, filter, search, and analyze in seconds. It is built for anyone who receives raw exports — analysts checking a database dump, developers inspecting an API export, marketers reviewing a contact list, or anyone who just needs to peek inside a file before deciding what to do with it.
Everything happens locally in your browser. Your file is read with the browser's FileReader and parsed in memory, so its contents are never uploaded to a server. That makes the CSV Viewer safe for sensitive exports such as customer lists, sales figures, or internal reports. There is no sign-up, no row limit, and nothing to install.
What it parses and detects
The viewer reads standard delimited text and figures out the structure for you:
- Delimiter auto-detection — it samples the first lines and recognizes comma, semicolon, tab, and pipe (
|) delimiters automatically. If the guess is wrong, you can lock the delimiter manually from a dropdown. - Quoted fields — the parser correctly handles values wrapped in double quotes, including delimiters and line breaks inside a field and escaped quotes written as
"", so addresses and free-text notes don't split into the wrong columns. - Header row — by default the first row becomes the column headers; toggle this off and the tool labels columns
Column 1,Column 2, and so on. - Column types — each column is classified as number, date, boolean, text, or empty. A column is typed when at least 80% of its non-empty values match, so a stray label in a numeric column won't throw off the detection.
Sorting, filtering, and searching
Once your data loads, you can interrogate it directly:
- Sort by clicking any column header; clicks cycle through ascending, descending, and back to the original order. Numeric columns sort by value rather than alphabetically, so
9correctly comes before100. - Per-column filters let you narrow each column with a text match, and they stack — combine several to drill into a subset.
- Global search scans every cell at once for a keyword.
- Pagination shows 25, 50, or 100 rows per page, or all of them, with a running count of how many rows match your current filters.
Column statistics and exporting
A Statistics tab gives a quick profile of every column without writing a single formula. For all columns it reports the non-empty count and the number of unique values — a fast way to spot missing data or check whether an ID column is truly unique. For numeric columns it also calculates the minimum, maximum, and average. This is enough to sanity-check an export at a glance: confirm a price column has no negatives, see the date range of an event log, or catch a column that is unexpectedly mostly empty.
When you're done, the export respects what you see. Download CSV saves the current filtered and sorted view as a properly quoted CSV file, and Copy TSV puts a tab-separated version on your clipboard so it pastes cleanly into Excel, Google Sheets, or Numbers. Because filtering and sorting are applied before export, you can trim a large file down to just the rows you care about and hand off a smaller, tidier dataset.
A built-in sample dataset lets you try every feature before loading your own file. Paste or drop your data above to start exploring it right away.