What counts as empty
A row is empty when every cell is blank or contains only spaces. A row with a single value is kept. Columns are removed only when no row has a value in them.
Partly empty rows are never removed unless you ask for it with required columns, because missing values are often legitimate: not every customer has a phone number.
Where blank rows come from
Spreadsheets exported to CSV keep the spacer rows people add between sections, many systems write an empty line at the end, and templates often export a column for every field, even unused ones. Excel files can also contain cells that were formatted but never filled. Trailing blank rows and columns in Excel files are trimmed automatically, and the rest are counted in the quality summary.
Header rows that are not on row 1
If your sheet starts with a title, a date line or blank rows, the header row is detected automatically. You can pick a different row from the Header row menu, or tell the tool the file has no header at all.