openrefine alternative
An OpenRefine alternative that cleans the file itself
OpenRefine is powerful, and it asks a lot before the first fix: install it, start its local server, import your data into a project, and export a new file at the end. Trusty CSV opens the CSV in your browser, shows every row as a table you can read, finds what’s wrong for you, and saves the same file with only your changes.
freenothing to installnothing uploaded
why switch
What changes when you clean in Trusty CSV
- Nothing to set up. No Java, no server, no project to create. Open the page, drop the file in, and start.
- The file stays the file. Same delimiter, quotes, encoding and line breaks. Fix one value, and a diff shows one line, not a new export.
- Every row in view. The whole file, each column in its colour and lined up, scrolled like a document instead of read 50 rows at a time.
- Problems found for you. Quality Check reads the whole file and lists 32 kinds of problems in the order to fix them, most with a one-click fix. No facets to set up first.
- Hand edits at the speed of a code editor. Multiple cursors, a whole column at once, find and replace inside a column, rows and columns moved with a key.
side by side
Trusty CSV and OpenRefine
| aspect | Trusty CSV | OpenRefine |
|---|---|---|
| to start | Open the page and drop the file in. | Install it, start its local server (Java), open it in the browser, create a project and import the file. |
| what you edit | The file itself. Saving keeps its delimiter, quotes, encoding and line breaks. | A copy in its workspace. You export a new file at the end. |
| what you see | Every row of the file, coloured and lined up. | A grid, 5 to 50 rows at a time by default. |
| titles above the table | Found when the file opens and removed with one click; a header written on several rows joined into one. | You set how many lines to ignore and how many to read as column headers when you import. |
| finding problems | 32 kinds found for you, most with a one-click fix. | Facets and filters that you set up, column by column. |
| editing by hand | Type anywhere, multiple cursors, a whole column at once. | One cell at a time; whole columns with transforms. |
| similar values | Yes: same words, same letters, similar spelling, same sound. | Yes: several clustering methods, phonetic ones too. |
| filters and profiles | Yes: by value, condition or date, and a column profile with a histogram. | Yes: text, numeric, timeline and scatterplot facets. |
| reshaping | Columns to rows and back, swap rows and columns, summarize, split values into rows and back. | Transpose columns into rows, rows into columns or key/value columns; split and join multi-valued cells. |
| joining files | Append rows and join two files, from a menu. | Through expressions that look up another project. |
| seeing what changed | View › Compare With: the file before the last change, on disk, a previous version or another tab, each changed cell marked in its place. | The History tab lists each operation; clicking one takes the data back to that step. |
| other formats | Opens Excel and ODS sheets, JSON, and files inside .gz or .zip. Saves a copy as Excel, ODS, JSON, SQL, Markdown or an HTML page. | Imports more: XML, fixed width, RDF and others, also from archives. Exports Excel, ODS, an HTML table, SQL and templates. |
| your data | Stays on your computer. | Stays on your computer. |
| price | Free in the browser. | Free and open source. |
vocabulary
What you do in OpenRefine, in Trusty CSV
Most of what you do in OpenRefine has its place in Trusty CSV, in the menu named after what it changes.
| in OpenRefine | in Trusty CSV |
|---|---|
| Ignore first lines, Parse next lines as column headers | Remove Them, in the notice when the file opens; Rows › Delete Rows Above the Cursor; Columns › Header Names › Join Header Rows… |
| Text facet | View › Column Profile (values and their counts), or Columns › Filter… |
| Numeric facet | The histogram of the Column Profile |
| Cluster and edit | Cells › Group Similar Values… |
| Common transforms › Trim, Collapse whitespace | Cells › Whitespace › Trim, Collapse |
| Common transforms › To uppercase, lowercase, titlecase | Cells › Change Case |
| Fill down, Blank down | Cells › Fill and Clear › Fill Down, Clear Consecutive Repeats |
| Split multi-valued cells | Rows › Split Values into Rows… |
| Join multi-valued cells | Rows › Combine Rows… |
| Transpose cells across columns into rows | Table › Columns to Rows… |
| Columnize by key/value columns | Table › Rows to Columns… |
| Split into several columns | Columns › Split Column… |
| Join columns | Columns › Join Columns… |
| Remove matching rows | Rows › Remove Rows Shown by Filter |
| Export | File › Save As or Download as, in CSV, TSV, Excel, ODS, JSON, SQL, Markdown or HTML |
| Undo / Redo | Ctrl+Z / Ctrl+Y, one step per operation, kept after a reload, and in Chrome and Edge after closing and reopening the file |
fair to say
When OpenRefine is still the tool
Trusty CSV is for the CSV files that come and go: exports, downloads, files from colleagues, cleaned and handed back in the same shape. OpenRefine goes further in four directions, and if your work depends on them, it’s still the one to use:
- Replaying the same steps on next month’s file. OpenRefine applies a project’s history to another one. Trusty CSV can’t repeat a list of steps yet.
- Formulas. GREL builds a column from others, parses JSON or fetches URLs. Trusty CSV’s operations are commands with options.
- Reconciliation with Wikidata or another service. Trusty CSV keeps everything on your computer.
- Data that isn’t a table yet. OpenRefine reads XML, and lets you choose which part of a JSON or XML file becomes the rows. Trusty CSV opens JSON as a table, but finds the rows by itself, and doesn’t read XML.
For the rest, taking a CSV, finding what’s wrong, fixing it and saving it, Trusty CSV is the shorter way.
Compared on 13 November 2026 with OpenRefine 3.10.1, from its manual: Installing, Running (the local server, the rows per page, the history), Starting a project (the formats, archives and lines to ignore), Facets, Cell editing, Transposing, Expressions, Reconciling and Exporting.
OpenRefine changes, and so does Trusty CSV. If something here is out of date, write to hello@calmly.studio and we’ll correct it. See also Trusty CSV and Tableau Prep.