1. Home
  2. Spreadsheets & Data
  3. Remove Blank Rows & Columns

Remove Blank Rows & Columns

Delete empty rows and columns from Excel or CSV files in one step.

For every format and option in one place, use Excel & CSV Workbench →

Runs in your browser · No upload
Open a file and blank rows are removed first. Turn on blank columns, space cleanup or fill-down in the settings.

Operations

Delete blank rows/columns, trim spaces, and fill down the blanks left by merged cells.
Columns to fill down (after unmerging cells)
Files are processed in your browser and never sent to a server.

How to use

  1. Drop an .xlsx, .csv or .tsv file, or paste cells copied from Excel. This page opens with the Blank rows/columns & space cleanup step already added.
  2. The default is remove blank rows. Turn on blank columns, space cleanup or fill-down if you need them.
  3. Check the number of removed rows and the step report (Removed 1 blank row) in the result preview.
  4. 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␠ becomes Kim 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.

Your file is processed only in your browser and is never sent to a server.

Can't find the tool you need?

Tell us what you want to do. We build the most requested tools first.