Spreadsheet Recipes: Build the Cleanup Once, Reuse It Forever

Most spreadsheet work isn't one-off. The same export lands every week or every month — the same messy headers, the same duplicate rows, the same dates in three formats — and you clean it the same way, by hand, every single time. A spreadsheet recipe is the fix: you describe the cleanup once, save it, and re-run it on each new file in a single click.

What is a spreadsheet recipe?

A recipe is an ordered list of steps — remove duplicates, fix dates, trim spaces, split a column, merge in a lookup, filter bad rows — written in plain language, not formulas or code. It's saved as a small portable file. Point it at next month's export and it replays every step in order, exactly as you defined them.

Think of it as the difference between doing the cleanup and recording it. Once it's recorded, the doing is free.

Why a recipe beats formulas, macros, and one-off cleanups

• It's repeatable. A manual cleanup has to be redone from scratch every time. A recipe runs again in one click.
• It doesn't break when columns move. Steps reference columns by name and intent, not by a fragile cell address or column index.
• It's plain language. No VBA, no M code, no formula soup — so the person who inherits the file can actually run it.
• It's portable. A recipe is a file you can hand to a teammate. They get your exact process, instantly.
• It's non-destructive. Your source file is never overwritten; you always get a clean copy out.

What you can put in a recipe

• Remove duplicates, standardize dates, trim and fix case, find & replace, fill blanks, convert types.
• Merge in columns from another file (a reproducible VLOOKUP), group & summarize (pivot), unpivot wide columns into tidy rows.
• Calculated columns, split/merge columns, filter rows, and flag invalid rows to a separate list for review.

How to build and reuse one

1. Open a single sample of the file you clean on a schedule.
2. Add the steps it needs, in plain language, watching the table update live as you go.
3. Save the sequence as a recipe — a portable .json file.
4. Next time the file arrives: open it, apply the recipe, click once. Done.
5. Need to clean a whole folder of them? Run the recipe in batch across every file at once.

Share the recipe, not the instructions

The hardest part of a "cleaning process" is usually that it lives in one person's head. A recipe makes it a file. Send it to a colleague and they run your exact steps on their own files — no walkthrough, no screen-share, no "wait, which columns do I delete first?" The process becomes an asset the team owns, not tribal knowledge.

Kramata is a free, local desktop app built entirely around recipes. Build the cleanup once; every future file is one click. Your files never leave your computer.

Related guides

Excel workflow automation without VBA · Automate monthly Excel reports · Clean a messy CSV the same way every time

FAQ

What is a spreadsheet recipe? An ordered list of cleaning and transform steps — in plain language — that you save once and re-apply to any new version of a file in one click. Same input plus same recipe gives identical output every time.

How is a recipe different from a macro or formula? A recipe is plain language, not VBA or M code. It's a portable file you can share, it doesn't break when columns move, and it's non-destructive — your source file is never overwritten.

Can I share a recipe with my team? Yes. A recipe is a portable .json file. Send it to a colleague and they apply the exact same steps to their files in one click — no setup.

Is the result reproducible? Yes. The same file run through the same recipe produces byte-identical output. That's the whole point — build it once, trust it forever.