CSV Stats Dashboard

Does this CSV Stats Dashboard upload my CSV data to any server?

No. All parsing, statistics, charts, and previews happen entirely in your browser using JavaScript. Your CSV file, text, and analysis results never leave your device, ensuring complete privacy and security.

How does the tool detect numeric vs categorical columns?

Each column is scanned to determine if most values are valid numbers. If at least 80% of non-empty cells can be parsed as numbers, the column is treated as numeric. Otherwise, it is classified as categorical. This allows the dashboard to compute the right statistics and charts for each column type.

What statistics are shown for numeric columns?

For numeric columns, the tool calculates minimum, maximum, mean, median, 25th percentile, 75th percentile, standard deviation, unique count, and sample values. These stats are computed directly from parsed numeric values and exclude empty or invalid entries.

What statistics are shown for categorical columns?

Categorical columns display unique count, missing values, non-null count, and top categories with their frequency and percentage share. This helps identify distribution patterns and dominant categories in the dataset.

How does the auto-detected delimiter work?

The tool scans the first few lines of your CSV and checks which delimiter (comma, semicolon, tab, or pipe) appears most consistently. This auto-detect system ensures correct parsing even for non-standard CSV files.

Why does the dashboard analyze only the first portion of very large CSV files?

To keep the browser responsive, the tool uses efficient parsing and processes only necessary portions for statistics, search, and chart rendering. Large datasets can contain hundreds of thousands of rows, and full scanning could freeze slower devices. Limiting analysis ensures performance and stability.

Why are the charts different for each column?

The dashboard intelligently selects the best chart type based on column content. Numeric columns show histograms, box plots, discrete bar charts, or scatter plots. Categorical columns use horizontal bar charts to show category frequencies.

Why do I see missing value counts even though my CSV looks complete?

The tool treats empty strings, blank cells, and whitespace-only cells as missing values. Additionally, if header mode is enabled and a row has fewer columns than expected, the missing cells are counted as empty.

Why does the data viewer show pagination?

To maintain smooth performance, the data tab displays 100 rows at a time. You can navigate using Previous and Next buttons. This prevents UI lag when browsing extremely large datasets.

Can I paste CSV text instead of uploading a file?

Yes. You can paste raw CSV content into the text box and analyze it immediately. This is useful for quick checks, API responses, or when working with snippets from logs or exports.