Kramata vs OpenRefine
OpenRefine (formerly Google Refine) is one of the most respected data cleaning tools ever made — free, open source, and trusted by librarians, journalists, and researchers for over a decade. Like Kramata, it runs entirely on your computer. If you're deciding between the two, here's an honest breakdown: they're built for genuinely different jobs.
The short version
- OpenRefine is a deep-cleaning power tool for exploring and fixing one dataset: faceting, fuzzy clustering of near-duplicate values, reconciliation against external databases like Wikidata, and an optional expression language (GREL). It runs as a local server you use from your browser, and it expects some technical comfort.
- Kramata is built for the recurring export ritual: the same messy CSV or Excel file arrives every week, and you want it cleaned the same way in one click. Plain-language steps, live preview, built-in folder batching. Free for single files; batch is a one-time $29.
Side by side
| OpenRefine | Kramata | |
|---|---|---|
| Price | Free, open source | Free; Pro $29 one-time (batch) |
| Runs fully local, nothing uploaded | Yes (local server + browser) | Yes (desktop app) |
| Interface | Browser tab: facets, menus, expressions | Linear recipe (list of steps, live preview) |
| Fuzzy clustering of similar values ("NYC" / "New York") | Yes — a standout feature | No — exact matching after trim & fix-case |
| Reconcile against Wikidata & other services | Yes | No |
| Repeatable steps | Operation history, exportable as JSON | Recipe file, re-applied in one click |
| Batch a folder of files | Not built in (third-party command-line scripts) | Built in — separate cleaned files or one merged file |
| Big CSVs | Java memory (2 GB default, adjustable) | In-process database (DuckDB) |
| Invalid values | Find them yourself with facets | Flagged to a review list automatically |
| File formats | Many (CSV, TSV, Excel, JSON, XML, ODS…) | CSV & Excel |
| Expression language | GREL (optional, needed for custom work) | None — every step is plain language |
| Platforms | Windows, Mac & Linux | Windows |
Pick OpenRefine if…
- Your data has near-duplicate text values — "IBM", "I.B.M.", "International Business Machines" — that need fuzzy clustering to merge. Nothing else does this as well.
- You need to reconcile names against Wikidata or another external database.
- It's a one-off deep clean of a single dataset, and you want to explore it with facets as you go.
- You work with JSON, XML, or other formats beyond CSV and Excel — or you're on Mac or Linux.
Pick Kramata if…
- The same file arrives on a schedule and you want this month's cleanup to be one click, not a repeat of last month's session.
- You want batch processing built in: point at a folder, get every file back cleaned — or merged into one. In OpenRefine that requires third-party command-line tooling.
- You'd rather read "Remove duplicates, fix dates, flag bad rows" than learn facets and GREL.
- You want invalid rows flagged for review automatically, not hunted down by hand.
- You prefer a normal desktop app over a local server running in a browser tab.
Related
Kramata vs Easy Data Transform · A simple Power Query alternative · Clean a messy CSV the same way every time · Batch process hundreds of CSV & Excel files
FAQ
Is OpenRefine free? Yes — fully free and open source. Kramata is also free for single files; batch processing is a one-time $29.
Can OpenRefine repeat cleaning steps like a recipe? Yes — you can extract a project's operation history as JSON and apply it to another project. It works, but it's a manual extract-and-paste flow and it's sensitive to column names. Kramata makes the recipe the whole product: save once, apply to next month's file in one click.
Which handles bigger files? OpenRefine loads projects into Java memory (2 GB by default) — big files need the memory setting raised and can get slow. Kramata uses DuckDB, an in-process analytical database, so large CSVs load and scroll smoothly without tuning.
Does either tool upload my data? No. Both run entirely on your computer — OpenRefine as a local server in your browser, Kramata as a normal desktop app.