CSV data profiler
Report missing values, distinct counts, numeric values and formula-like cells.
Sida loo isticmaalo CSV data profiler
The CSV data profiler reports a quality summary for every column in a CSV or XLSX file. For each column it counts missing cells, distinct values, numeric values and formula-like cells, which start with characters such as =, +, - or @. The table helps spot empty fields, unexpected text in numeric columns and possible spreadsheet formula injection before importing data.
- Choose a source file. If the tool accepts multiple files, arrange them in the order you want.
- Check the source format before running the operation.
- Run csv data profiler, review the output, then use the available copy or download controls.
Waxa qalabkani taageero
Report missing values, distinct counts, numeric values and formula-like cells.
Xadka iyo habaynta
CSV/XLSX inputs are capped at 10 MB each, 200 columns and 20,000 rows; joined output is capped at 20,000 rows. JSONPath script/filter evaluation is disabled. Other operations apply their visible controls and text limits.
Su’aalaha badanaa la isweydiiyo
What counts as a missing value in the CSV profiler?
A cell is counted as missing when it is empty or contains only whitespace. The Missing column shows how many such cells each column has across all data rows.
What are formula-like cells and why do they matter?
These are cells beginning with =, +, -, @, a tab or a carriage return. Spreadsheet apps may treat them as formulas when opened, which can be a security risk, so the profiler counts them per column.
How can I check whether a column is fully numeric?
Compare the Numeric values count with the number of nonempty cells. Numbers with decimals, signs or exponents count as numeric; values with currency symbols or thousands separators do not.
Where is my input processed?
This operation processes its source in your browser. Copy and download are explicit actions; source input is not saved in an account or history.
What are the input limits?
CSV/XLSX inputs are capped at 10 MB each, 200 columns and 20,000 rows; joined output is capped at 20,000 rows. JSONPath script/filter evaluation is disabled. Other operations apply their visible controls and text limits.