Tools

CSV Viewer

Visualize CSV data in table format.

Input
Ln:1 Col:1
Output
Enter CSV and click the Convert button.
Rows: 0

About CSV Viewer

CSV (Comma-Separated Values) is the most widely used format for tabular data exchange. From Excel spreadsheets and database exports to data science datasets and financial records, CSV is the lingua franca of data. A proper CSV viewer helps you validate structure, check row and column counts, identify encoding issues, and preview data without opening a full spreadsheet application.

CSV Format Quick Reference

The CSV format has no single universal standard, which leads to common variations: comma (,), tab (\t), semicolon (;), or pipe (|) delimiters; different line endings (CRLF vs LF); optional quoting for fields containing the delimiter character. RFC 4180 defines the most widely accepted CSV specification, but real-world files often deviate from it.

When working with CSV data from different sources, watch for: encoding issues (UTF-8 vs UTF-16 BOM — Excel adds a BOM by default on Windows), Excel's use of semicolons in European regional settings, quoted fields that span multiple lines, and empty trailing rows. When exporting data for wide compatibility, use comma delimiters, UTF-8 encoding without BOM, and follow RFC 4180 quoting rules.

FAQ

Why does CSV encoding break?
Excel saves CSV in the system's default encoding (CP949/EUC-KR on Windows). Save as UTF-8 with BOM, or specify UTF-8 encoding when opening.
What if the CSV delimiter is not a comma?
TSV (tab), SSV (semicolon), and other delimiters are common. In Europe, where commas are used as decimal separators, semicolons often serve as delimiters. This tool supports auto-detection.
Why do leading zeros disappear when opening in Excel?
Excel automatically applies number formatting. To prevent this, use Excel's Import Wizard and set the column format to "Text".