Template gallery

Ready-made spreadsheet recipes

Copy a plain-language instruction, open the Workspace, and run it on your own file. Every recipe uses operations Sumio already supports — the AI proposes the plan, trusted code performs it.

Clean-up

Deduplicate a mailing list

One row per person, tidy names, sorted alphabetically.

Remove duplicate rows on Email, then trim spaces in every text column and sort by Name

Try it in Sumio

Clean-up

Fix blank cells

No more gaps where a value is required.

Fill blank cells in Region with "Unknown" and drop rows that are missing an Email

Try it in Sumio

Clean-up

Standardize a status column

Messy variants collapsed into one clean label.

In Status, replace "in progress" and "WIP" with "In Progress", then sort by Status

Try it in Sumio

Finance

Add an invoice line total

A currency-formatted Total column, computed with a live formula.

Add a column Total = {Quantity} * {Unit Price} and format it as currency

Try it in Sumio

Finance

Flag missing tax IDs

Rows that need a GST number surfaced to the top.

Flag rows where GST Number is blank, then sort those rows to the top

Try it in Sumio

Sales

Top accounts by revenue

Your 20 biggest accounts, highest first.

Sort by Revenue descending and keep the top 20 rows

Try it in Sumio

Sales

Pipeline by region

Deal value and deal count rolled up per region.

Group by Region, sum Deal Value and count the deals

Try it in Sumio

Reporting

Combine monthly sheets

Every sheet stacked into one table, with its source labeled.

Merge all sheets into one table and add a Source column with each sheet's name

Try it in Sumio

Reporting

Look up prices from another sheet

Prices pulled in by SKU — no manual VLOOKUP.

Look up Unit Price from the Products sheet by SKU and add it as a column

Try it in Sumio

Have a file to clean up right now?

Open the Workspace and load the sample data — no upload needed to try it.

Start free