Skip to content
NewAI dashboards.See how →
Open MammothTry free
Workflow · Clean · Opening soon

Remove blank rows

Use an Excel export when you need to remove blank rows. Keep every other row and column as they are.

Early access opens shortly. Check back soon.

Book a demo
Someone typed

“delete the rows that are completely empty or only have spaces in them, and keep every other row and column exactly as it is”

The agent read it as

Delete the rows that are completely empty or only have spaces in them from Invoice export, and keep every other row and column exactly as it is.

What the agent built

1 step, each one an ordinary Mammoth step you can open and change.

  1. File
    Invoice export
    CSV export · 25 rows
  2. Step
    Remove empty rows
    Step 1
  3. Result
    Remove Empty Rows
    25 rows · 12 flagged
  4. Schedule
    Runs when you say
    Proposed

Checked on the sample files: every step ran, 25 rows came out.

What you get back

The result of that run, the rows to look at first.

Remove Empty RowsSample data25 rows
13 paid12 open
Invoice NumberInvoice DateCustomerDue DateStatusAmountNotes
INV-104222026-10-03Bluebird Studio2026-10-17Open620Monthly design retainer
INV-104242026-10-05Metroline Fitness2026-10-19Open310Supplemental billing
INV-104272026-10-09Cedar & Co.2026-10-23Open975·
INV-104292026-10-11Atlas Manufacturing2026-10-25Open7,420Equipment service
INV-104312026-10-14Juniper Hotels2026-10-28Open5,150Event support
INV-104332026-10-17Apex Logistics2026-10-31Open1,675Fuel surcharge
INV-104352026-10-19Stonebridge Cafe2026-11-02Open285Small order
INV-104372026-10-22Silver Pine Media2026-11-05Open1,340Ad production
INV-104392026-10-24Willow Creek Law2026-11-07Open1,990Retainer balance
INV-104412026-10-26Sunset Foods2026-11-09Open760Delivery fee
INV-104432026-10-29Harbor Freight Works2026-11-12Open6,825Parts and labor
INV-104442026-10-30Northwind Events2026-11-13Open1,475November planning
25 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How do you remove blank rows in Excel?

Export the sheet from Excel, then run a step that removes rows that are completely empty or only contain spaces. The other rows and columns stay in place, and rows that do not match the rule are left unchanged.

How it works

How to use the Remove Empty Rows workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Remove Empty Rows: questions

What export should I use?
Use the Excel file export for the sheet you want to clean. If you need to work on a specific tab or range, export that data in the file you get from Excel.
What happens to rows that do not match the rule?
Rows that are not completely empty, or that contain any other values, are kept. Only rows that are blank or contain spaces are removed.
How do I change the rule in words?
Change the wording to match the rows you want removed. For example, say to remove rows where every cell is empty, or to keep rows with any text or number in them.

Get early access to this workflow

It will open already built and checked on the sample files. Swap in your own exports and see your result.

Early access opens shortly. Check back soon.

Book a demo

Workflows like this

Remove duplicate rows, catch invoices paid twice, match messy names to a master list, standardise spellings and turn wide tables long.

All cleaning templates →

Keep reading

Read nextAll workflowsDescribe yours, or start from one the agent already built.Take a lookProductData EngineConnected sources, cleaning and scheduled refresh.Take a lookConnectorsConnectorsBring the data in from the tools you already use.Take a look