CSV column profile
Inspect missing-cell locations, unique counts, duplicate rows and numeric candidates per CSV column.
The example value has been entered. Check it immediately or change the value.
Input is processed in the browser. Refreshing returns a sample value.
Instructions and example
No. Only numeric candidacy is counted; source strings and leading 0s remain. Unique counts also include the empty string as a value.
The sample amount column is blank at row 3 including the header and has 1 numeric candidate. The id value 002 repeats at rows 3 and 4.
Missing means a zero-length value; spaces are distinct values. Row numbers include the header and source values are not converted.
Frequently asked questions
Does numeric-looking 001 become a number?
No. Only numeric candidacy is counted; source strings and leading 0s remain. Unique counts also include the empty string as a value.
Are whitespace cells counted as empty cells?
Missing means a zero-length value; spaces are distinct values. Row numbers include the header and source values are not converted.
Calculation criteria and reference materials
- RFC 4180 — CSV Format
Missing means a zero-length value; spaces are distinct values. Row numbers include the header and source values are not converted.
Verification of calculation criteria: · Calculation·verification principles · Report errors