Remove empty rows and columns
Upload your file and download it without the blank rows and columns that break pivot tables and imports.
Where blank rows come from
Nearly always the same causes: pasting a range larger than needed, exporting from another system, or clearing the contents of some rows without deleting the rows.
The problem is not cosmetic. A blank row in the middle cuts Excel's automatic range, so a pivot table built from it only picks up half the data. And most importers stop or fail when they reach one.
The case Excel does not solve
If you try "Go To Special → Blanks" and nothing gets selected, it is because those cells are not empty: they contain spaces. A space is a character, and to Excel that is content.
That is why "treat cells containing only spaces as empty" is on by default. It is the difference between the tool working and the tool appearing to do nothing.
Columns with a title but no data
These are kept on purpose. A titled but empty column is usually waiting to be filled in, not rubbish. What gets removed are the columns with neither a title nor a single value.
Frequently asked questions
Is the row order lost?
No. The remaining rows keep exactly the order they had.
Can I remove only rows and keep the columns?
Yes, each has its own checkbox. You can do one, the other, or both.
What about formulas returning an empty string?
Reading the file takes the computed value. A formula returning "" is seen as an
empty cell and its row is removed if the rest is empty too.
What if the whole sheet is empty?
The tool detects it and tells you, instead of handing you back an empty file.