CleanMySheet guide
Drop empty rows and columns from a spreadsheet
Drop empty rows/columns removes records where every cell is blank and columns where every value is blank. Run Unify empty values first so N/A counts as empty.
Empty rows and columns are Safe to apply.
Drop CSV or Excel here
Tap to choose a file. Parsing stays on this device.
Parsing stays on this device. Optional: drop a .cleanmysheet.json recipe with it.
Steps
- Unify empty values
- Apply Drop empty rows/columns
- Check row counts in the toolbar
Not the same as filtering
This is structural cleanup of raw exports, not a data filter on a category column.
Related searches this page answers
- delete empty rows excel
- remove blank columns csv