OpenRefine alternative: clean CSV files in your browser — Trusty CSV

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.

Clean a file now

or try it with

world-cities.csv

free nothing to install nothing 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

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.

openrefine-to-trusty-csv.csv

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.

Clean a file now

What else Trusty CSV does

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 .

Clean a file now

or try it with world-cities.csv

What else Trusty CSV does

Installing

Running

Starting a project

Facets

Cell editing

Transposing

Expressions

Reconciling

Exporting

Trusty CSV and Tableau Prep