Remove empty spreadsheet rows

Remove spreadsheet rows whose cells are all empty.

Local processing · Nothing is uploaded · 10 MB per file / 25 MB total

Input & settings

Choose source files

Drop files here. One file per operation.

No files selected

Result

Choose source files to begin.

How to use

Choose the source file, review settings, process, then inspect and download the result.

Limits and behavior

Whitespace-only strings count as nonempty. Header retained; formulas are rejected to avoid stale references. Local processing. Maximum 10 MB per file, 25 MB total; expanded ZIP contents at most 50 MB and 2,000 entries. Spreadsheet limit: 10,000 cells and 2,000 rows per sheet. Macros are never executed. Originals are unchanged. Cancellation stops active PDF renders and discards stale results; a synchronous library step finishes before the browser can handle cancellation.

Clean empty rows from an Excel spreadsheet

Delete completely empty worksheet rows to tidy imported or irregularly formatted tables.

Does it remove rows containing spaces or formulas?

Rows containing stored values may not count as empty; review the result if formulas or whitespace are present.

Related tools: remove duplicate spreadsheet rows · filter spreadsheet rows

Built on Hatchable