Question 1

What does the CSV profiler do?

Accepted Answer

It parses your CSV, auto-detects the delimiter (comma, tab, semicolon, pipe), identifies the header row, then computes row count, column count, missing value counts per column, inferred types (number, string, boolean, date) and basic statistics — min, max, mean, median and unique count for numeric columns.

Question 2

How does it detect the delimiter?

Accepted Answer

The tool counts occurrences of each candidate delimiter (',', '	', ';', '|') in the first few non-empty lines and picks the one that produces the most consistent column count. You can override the choice in the dropdown.

Question 3

Can it handle large CSV files?

Accepted Answer

Yes. Parsing happens line-by-line with no DOM allocation, so the tool can comfortably analyze CSV files up to several megabytes in your browser. For very large files, paste a representative sample (first 1000–5000 rows) for a quick profile.

Question 4

Is my CSV data sent anywhere?

Accepted Answer

No. Parsing and analysis happen 100% in your browser. Nothing is uploaded or stored.