Remove Blank Rows in Excel
Delete every empty row - and optionally empty columns - in one click, then download a clean workbook. No Go To Special, no upload.
Drop your file here or click to upload
Supports .xlsx, .xls, .xlsm, .xlsb, .csv · up to 50MB
Remove Blank Rows Online
- Upload your file - .xlsx, .xls, .xlsm, .xlsb, or .csv.
- Review the count - see how many blank rows and columns were found.
- Optionally remove blank columns - tick the box to drop empty columns too.
- Download - get the cleaned workbook.
Safer Than Go To Special
The usual manual method - Go To Special > Blanks > Delete Rows - can delete rows that merely have a blank in one column, quietly destroying data. This tool only removes rows where every cell is empty, so partial records are always kept. For the manual steps and the caveats, see our guide to removing blank rows in Excel.