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

trusty-csv-and-openrefine.csv
aspectTrusty CSVOpenRefine
to startOpen 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 editThe 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 seeEvery row of the file, coloured and lined up.A grid, 5 to 50 rows at a time by default.
titles above the tableFound 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 problems32 kinds found for you, most with a one-click fix.Facets and filters that you set up, column by column.
editing by handType anywhere, multiple cursors, a whole column at once.One cell at a time; whole columns with transforms.
similar valuesYes: same words, same letters, similar spelling, same sound.Yes: several clustering methods, phonetic ones too.
filters and profilesYes: by value, condition or date, and a column profile with a histogram.Yes: text, numeric, timeline and scatterplot facets.
reshapingColumns 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 filesAppend rows and join two files, from a menu.Through expressions that look up another project.
seeing what changedView › 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 formatsOpens 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 dataStays on your computer.Stays on your computer.
priceFree 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.

openrefine-to-trusty-csv.csv
in OpenRefinein Trusty CSV
Ignore first lines, Parse next lines as column headersRemove Them, in the notice when the file opens; Rows › Delete Rows Above the Cursor; Columns › Header Names › Join Header Rows…
Text facetView › Column Profile (values and their counts), or Columns › Filter…
Numeric facetThe histogram of the Column Profile
Cluster and editCells › Group Similar Values…
Common transforms › Trim, Collapse whitespaceCells › Whitespace › Trim, Collapse
Common transforms › To uppercase, lowercase, titlecaseCells › Change Case
Fill down, Blank downCells › Fill and Clear › Fill Down, Clear Consecutive Repeats
Split multi-valued cellsRows › Split Values into Rows…
Join multi-valued cellsRows › Combine Rows…
Transpose cells across columns into rowsTable › Columns to Rows…
Columnize by key/value columnsTable › Rows to Columns…
Split into several columnsColumns › Split Column…
Join columnsColumns › Join Columns…
Remove matching rowsRows › Remove Rows Shown by Filter
ExportFile › Save As or Download as, in CSV, TSV, Excel, ODS, JSON, SQL, Markdown or HTML
Undo / RedoCtrl+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.