CSV Viewer
Paste or upload any CSV and view it as a real table — sortable columns, searchable rows, and quick column-by-column statistics. Auto-detects the delimiter (comma, tab, semicolon, pipe), respects quoted fields containing commas, and handles UTF-8 with or without a byte-order mark. Everything renders in your browser; the file never uploads.
Why a Dedicated Viewer Beats Excel for Quick Looks
Opening a CSV in Excel triggers a chain of auto-conversions that frequently damage the data. Strings that look like dates get reformatted into Excel's local date format. Long numeric IDs get truncated to scientific notation and lose precision past the 15th digit. Leading zeros on ZIP codes vanish. None of this is malicious — Excel is just trying to be helpful — but for a quick read of an export to verify a row count or a column's contents, it's the wrong tool.
A viewer that displays the file exactly as it sits on disk is faster than Excel for the read case and safer for the verify case. For actual analysis — pivots, formulas, charts — Excel is still the right tool, and saving the file from this viewer into Excel after the verification step works fine.
How It Works
The tool reads the file via the browser's FileReader API. The first line gets analyzed for a likely delimiter by counting candidates (,, \t, ;, |) and picking the one with the highest occurrence that produces consistent column counts on the first ten rows. RFC 4180 quoting rules are followed: a field starting with \" extends to the matching closing quote, with doubled quotes inside (\"\") representing a literal quote character. UTF-8 byte-order marks are stripped from the first cell. Empty trailing rows are ignored.
Need to narrow the file to a subset of rows? The CSV Row Filter applies one or more predicates with AND/OR composition and downloads only the matching rows.
For pasting tabular data into a README or doc site, the CSV to Markdown Table converter produces clean GitHub-flavored output with padded source and optional column alignment.
When the file is ready to load into a database, the CSV to SQL converter emits a CREATE TABLE plus INSERT statements with inferred column types for PostgreSQL, MySQL, or SQLite.
If the file you're inspecting needs cleanup before downstream use, the CSV Cleaner de-duplicates, trims, and normalizes null markers in one pass.
The rendered table uses windowed rendering for files with more than a few thousand rows — only the visible rows are in the DOM at any given time, which keeps scrolling fluid even on multi-megabyte CSVs. Click a column header to sort by that column; click again to reverse; click a third time to clear the sort. The search box filters across all columns case-insensitively.
Common Use Cases
Verifying that an export contains what you expected before importing it into a database. Inspecting a customer-submitted CSV before mapping its columns to your schema. Diffing two CSVs row-by-row — export each as text and pipe through the text diff tool. Picking a few sample rows for a manual QA pass. Confirming the row count on a multi-million-line export without waiting for Excel to load the whole thing. Converting between delimiters by changing the detected delimiter manually and re-exporting.
How We Compare
Excel and Google Sheets are full spreadsheet applications and overkill for read-only verification. Modal CSV utilities like CSV Lint and Tad open faster but require installation. Online CSV viewers from many SaaS analytics platforms upload your file and often persist it on their servers — fine for public-data CSVs, a problem for anything sensitive. This viewer matches the open-and-look workflow without persisting anything, and it pairs naturally with the rest of the UDT data-format tools for downstream conversion or cleanup.
Frequently Asked Questions
Built by Derek Giordano · Part of Ultimate Design Tools