CSV Viewer

• Renders CSV as a table with headers and a search filter.
• Auto-detects delimiter (comma, semicolon, tab, pipe) and quoting style.
• Handles quoted values with embedded commas, newlines, and escaped quotes (RFC 4180).
• Supports UTF-8; renders emoji and accented characters correctly.
• Cleanup actions: trim whitespace, remove empty rows, remove empty columns.
• Infers column types, scores data quality, and drafts a CREATE TABLE statement.
• Send to the CSV ↔ JSON Converter, CSV Compare, or SQL IN Builder.

• Inspect a database export, BI dump, or analytics CSV without launching Excel.
• Validate test data exports for QA scenarios.
• Clean a CSV before bulk-import into a database or CRM.
• Look up a specific row or value in a large CSV using search.
• Convert a CSV column into a SQL IN list or a JSON array of values.
• Inspect a vendor data drop for column types and outliers.

1. Paste your CSV or load a .csv file.
2. The delimiter is auto-detected; change it manually if the table looks wrong (e.g., semicolon-separated European exports).
3. Type in the search box to filter rows to those that contain your term.
4. Use Trim cells, Remove empty rows, and Remove empty columns to clean the data.
5. Open the Column profile tab for inferred types, a data-quality score, and a CREATE TABLE draft.
6. Copy the table, or hand off to a related tool for conversion or comparison.

• European CSV exports often use semicolons as the field separator — set the delimiter manually if the table appears as one column.
• Excel-on-Windows reads UTF-8 best via Data → From Text/CSV — use that if accented characters render incorrectly.
• Quotes inside fields must be doubled ("") per RFC 4180; the viewer handles this automatically.
• Very large CSVs are previewed up to a row cap for speed; the verdict always reports the true row and column totals.
• Beware of leading zeros in IDs (007) — copy as text rather than re-importing through Excel, which strips them.

FAQ

• How do I view a CSV file online? Paste it or drop the file in. The CSV Viewer renders it as a searchable table instantly.
• Does it support semicolon or tab delimiters? Yes — comma, semicolon, tab, and pipe are supported with auto-detection.
• Is my CSV uploaded? No. Parsing and rendering run entirely in your browser.
• How do I clean a CSV? Use the trim, remove-empty-rows, and remove-empty-columns options, then copy the table.
• Can I convert CSV to JSON? Yes — send the CSV to the CSV ↔ JSON Converter for typed JSON output.
• What is the row limit? The table preview is capped for speed; the verdict reports the true totals. For multi-million-row files, split or load into a database.

• Inspect and clean a large CSV file

Runs locally in your browser. No uploads. Share links use an encrypted URL fragment.