A Simple Power Query Alternative for Non-Technical Analysts
Power Query is genuinely powerful — it's the right answer for repeatable data prep inside Excel. But for a lot of analysts and ops folks it's also fiddly: the Query Editor is a maze, applied-steps break in confusing ways, the M language leaks through the moment you do anything custom, and sharing a query with a teammate is awkward.
If you mostly need to clean the same messy export the same way every time, you may want something simpler and more focused.
What people actually struggle with in Power Query
- Steps that silently break when columns are renamed or reordered.
- The jump from the friendly buttons to hand-editing M code.
- It lives inside a workbook — not a portable thing you can hand to a colleague.
- For non-technical users, the whole editor is intimidating.
Kramata: the same idea, in plain language
Kramata is a free, local desktop app built around one idea: define your cleaning steps once (a recipe), then re-apply them to any new version of the file in one click. Every step is plain language — no formulas, no M.
| Power Query | Kramata | |
|---|---|---|
| Repeatable steps | Yes | Yes |
| Merge / lookup, pivot, unpivot | Yes | Yes |
| Plain language (no M code) | Partly | Yes |
| Portable recipe file to share | No | Yes (.json) |
| Flags bad rows for review | No | Yes |
| Folder of files → one merged table | Yes (From Folder) | Yes |
| Folder of files → separate cleaned files back | No | Yes |
| Fully local, nothing uploaded | Yes | Yes |
The one thing Power Query truly can’t do
Power Query can stack a folder of files into one table inside a workbook. It can’t hand you back thirty clean files. If your job is “clean each of these exports and send them back out”, Kramata’s batch mode does exactly that — point it at the folder, get every file back cleaned, or merged into one. Your choice.
What it does
- Merge from another file (a reproducible VLOOKUP), group & summarize (pivot), unpivot.
- Remove duplicates, standardize dates, trim & fix case, find & replace, fill blanks, convert types.
- Calculated columns, split/merge columns, filter rows, and flag invalid rows to a separate list.
When Power Query is still the right call
This isn't "Power Query is bad." If you live inside Excel, need bespoke M transformations, or pull from dozens of database and web connectors, Power Query is the right tool. Kramata is for the other, far more common case: the same messy export, cleaned the same way, every week — by someone who doesn't want to learn a query language to do it.
Moving a Power Query habit to Kramata
- Open one sample of the file you clean on a schedule.
- Add the steps you'd normally apply — merge, dedupe, fix dates, split columns — each in plain language.
- Watch the table update live as you go, so you can trust the result before you commit.
- Save it as a recipe — a portable
.jsonfile. - Next month: open the new file, apply the recipe, click once. Identical output, every time.
Related guides
Merge two spreadsheets without VLOOKUP · Merge multiple CSV files into one · Clean a messy CSV the same way every time
FAQ
Is Kramata a full Power Query replacement? For repeatable cleaning of recurring files, yes — merge, pivot, unpivot, dedupe, fix dates, and more. For deep custom M transformations or dozens of live data connectors, Power Query still wins.
Do I need to write M code? No. Every step is plain language — no formulas, no M.
Can I share my steps with a colleague? Yes. A recipe is a portable .json file you send them; they apply it in one click.
Does it work offline? Yes. Kramata is a local desktop app — your files never leave your computer.