CSV Viewer (Table and Column Statistics)

Double-clicking a CSV often opens it in a spreadsheet that mangles leading zeros, long ID numbers and Korean text. This viewer shows the file exactly as it is: the delimiter is detected, the text encoding can be switched (UTF-8, EUC-KR from Korean Excel, Shift_JIS, GB18030 and more), and the first 400 rows appear as a table you can filter and sort. A statistics table guesses each column's type and counts empty and unique values, with min, max and mean for numbers. Excel files (.xlsx, .xls, .ods) open too. Files never leave your device.

How to use this tool

1. Choose a CSV, TSV or Excel file — or paste CSV text and press Calculate.
2. If letters look garbled, switch the encoding (EUC-KR for files saved by Korean Excel).
3. Leave the delimiter on Detect unless the columns come out wrong.
4. Type in the filter box to show matching rows, or give a column to sort by.
5. Read the column statistics under the table.

Formula

mean = sum of the numeric cells ÷ number of filled cells · unique = number of distinct non-empty values

A column counts as integer or number only if every filled cell is numeric (thousands separators like 1,234 allowed), as date if every cell looks like a date, and as boolean for true/false/yes/no; otherwise it is text. Empty cells are counted separately and left out of min, max and mean. Statistics use all rows, not just the filtered ones.

Example

The file name,age / Ada,36 / Lin,29 has 2 rows and 2 columns. name is text with 2 unique values; age is integer with min 29, max 36 and mean (36 + 29) ÷ 2 = 32.5.