How to use
- Drop an
.xlsx,.csvor.tsvfile, or paste cells copied from Excel. This page opens with the Blank rows/columns & space cleanup step already added. - The default is remove blank rows. Turn on blank columns, space cleanup or fill-down if you need them.
- Check the number of removed rows and the step report (
Removed 1 blank row) in the result preview. - Download as xlsx, csv or json.
Options
| Option | What it does |
|---|---|
| Remove blank rows | Deletes rows where every cell is empty |
| Remove blank columns | Deletes columns that are empty in every row, header included |
| Whitespace counts as blank | Treats cells holding only spaces or tabs as empty (on by default) |
| Space cleanup | None / trim leading and trailing spaces / trim and collapse runs of spaces to one |
| Fill down | Fills empty cells in the chosen columns with the value above |
Worked example
A table with the headers Dept, Name, Note:
| Dept | Name | Note |
|---|---|---|
| Sales | ␠Kim␠␠Cheolsu␠ | (empty) |
| (empty) | ␠␠ | (empty) |
| (empty) | Lee Younghee | (empty) |
| Dev | Park Minsu | ␠ |
| (empty) | Choi Jia | (empty) |
- Default (blank rows): row 2 holds only spaces, so it is removed (
Removed 1 blank row). Four rows remain. - Whitespace-is-blank turned off: the space-only cells count as values, nothing is removed and the report says
No changes. - Blank columns on: the Note column is empty or spaces-only everywhere, so it goes and Dept and Name remain.
- Space cleanup, collapse:
␠Kim␠␠Cheolsu␠becomesKim Cheolsu; the space-only cell in row 2 and the single space in Park Minsu’s note become empty strings, 3 cells in total (Cleaned spaces in 3 cells). Plain trim would leave the double space inside the name. - Fill down on Dept: blank rows are removed first, then Dept becomes
Sales, Sales, Dev, Dev(2 cells filled).
Fill down after unmerging cells
A merged cell in Excel is read from the file as a value in the first cell only, with the rest empty. Sorting, filtering or pivoting that as-is leaves rows without a value, so pick the formerly merged column under “fill down”: Sales, , , Dev, becomes Sales, Sales, Sales, Dev, Dev. The tool does not restore merge formatting; it fills in values only.
Fill-down always runs last. Doing it earlier would turn blank rows into rows with content, so the order is: trim, remove blank rows, remove blank columns, fill down. If the topmost cell is empty there is nothing to fill from, so it stays empty.
Why clean up spaces
Invisible leading, trailing and repeated spaces create values that look equal but are not, which breaks duplicate removal, find and VLOOKUP. Only text cells are cleaned; numbers and dates are left alone. Tabs and line breaks count as whitespace too, so a line break inside a cell becomes a single space under “collapse”. Stack Remove Duplicate Rows after the cleanup and save once.
Related tools
- Several steps at once: Excel & CSV Workbench
- Whitespace in a block of text: Trim Whitespace
- Replacing text: Find & Replace in Excel
Your file is processed only in your browser and is never sent to a server.