Remove the blank rows Excel leaves behind, plus any empty columns that crept in. You can also skip a preamble, treat the first line as data, or shuffle rows before splitting a dataset.
No uploadNo sign-upBlank rows and columns
Process your CSVRuns on your device
Drop a CSV here
or click to choose · Shift_JIS / UTF-8 detected
How to use
Drop a CSV or paste the table.
Tick what should go — blank rows, empty columns.
Press Run, check how many rows were removed, then download.
What this tool does not do
Cell values are not rewritten here — use the normalizing tool for that. A row counts as blank only when every cell is empty or whitespace.
FAQ
What counts as a blank row?
A row where every cell is empty or contains only spaces. One non-empty cell keeps the row.
Can I skip the preamble?
Yes — set “skip the first N lines”. Handy for CSVs that start with a title or an export timestamp.
What if there is no header row?
Turn on “treat the first line as data” and line one is exported as a data row instead of becoming the header.
Why shuffle rows?
Useful for breaking an ordered export, or before splitting a dataset for training and testing.