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.

Result

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

Verification of calculation criteria: · Calculation·verification principles · Report errors