Keyboard shortcuts

Press ← or → to navigate between chapters

Press S or / to search in the book

Press ? to show this help

Press Esc to hide this help

Where everything is

OxRefine follows OpenRefine's layout: projects on a home screen, a grid of rows, facets and history in a side panel, and each column's operations in its menu. This page lists where each OpenRefine feature lives in OxRefine. Ctrl+K (⌘K on a Mac) opens a command palette that finds any action by name. The tools also have keys, shown next to them: F facet, C cluster, T transform and R reconcile on the column you last used, E export, I or Ctrl O import, Esc to close a view.

Projects

OpenRefineOxRefine
Create project → This computerFrom a file or folder on the home screen, or Import → File… in a project
Create project → Web addresses (URLs)From a web address on the home screen, or Import → Web address…
Create project → ClipboardPaste from clipboard on the home screen, or Import → Paste data…
Create project → DatabaseNot yet
Open projectHome screen, the project list
Import project (.openrefine.tar.gz)Open an OpenRefine project on the home screen, or Import → OpenRefine project…; it opens with its undo history
Export → OpenRefine project archiveExport → OpenRefine project; OpenRefine opens it with OxRefine's history
Rename and delete projectsHome screen, the project's buttons
Project tags and metadataAbout next to the project in the list: tags, description, creator and the rest; click a tag at the top to show only its projects. OpenRefine project archives carry them both ways
PreferencesThe gear at the top right: theme, the facet choice limit, reconciliation services, recent expressions, and every preference by name and value

Rows and records

OpenRefineOxRefine
Show as rows / recordsRows / Records at the right of the bar above the grid
Star and flag a rowThe star and flag in each row
All → Edit rows → Star / Flag / Remove matching rowsRows in the top bar
Keep only matching rowsRows → Keep only matching rows
SortSort rows by this column… in the column menu
Remove duplicate rowsRemove duplicate rows by this column in the column menu

Facets and filters

OpenRefineOxRefine (column menu → Filter)
Facet → Text facet / Numeric facet / Timeline facetSame names
Facet → Custom text facet… / Custom numeric facet…Same names
Facet → Customized facets → word, duplicates, text length, Unicode, blank, error, star, flagCustomized facets, same entries
Facet → Scatterplot facetNot yet
Text filterText filter
Reconcile → FacetsReconcile → Facets

In a list facet, click a choice to include it, and hover a choice and click the pencil to change that value in every row. Each filter shows as a chip above the grid; Clear all there clears every filter, and the × on a facet removes it.

Editing cells

OpenRefine (column menu → Edit cells)OxRefine (column menu → Edit cells)
Transform…Transform…: GREL with a live preview and expression history
Common transformsCommon transforms: trim, collapse whitespace, case, to number, date, text or blank
Fill down / Blank downSame names
Split multi-valued cells… / Join multi-valued cells…Same names
Cluster and edit…Cluster and edit…
Edit one cellClick the cell and press Enter (or double-click it, or use the pencil); it can also change every identical cell

Editing columns

OpenRefine (column menu → Edit column)OxRefine (column menu → Edit column)
Split into several columns…Same name
Add column based on this column…Add column based on this…
Add column by fetching URLs…Same name
Add columns from reconciled values…Same name
Rename / Remove / Move this columnRename…, Remove column, Move column
Transpose → Cells across columns into rows / Cells in rows into columns / Columnize by key/value columnsTranspose, same three entries

Reconciliation

OpenRefineOxRefine
Reconcile → Start reconciling…Reconcile → Start reconciling…: services, type guessing, columns as properties
Reconcile → Actions (match to best candidate, create new items, match all filtered cells, discard, clear, copy across columns, use values as identifiers, add entity identifiers column)Reconcile → Actions, same entries
Judging a cell: candidates, match this cell or all identical cells, new item, search for matchClick the mark after a reconciled cell
Add columns from reconciled values…Column menu → Edit column

History and recipes

OpenRefineOxRefine
Undo / Redo tabHistory tab in the side panel, undo and redo in the top bar, and Recipe for the full history beside its recipe
Undo / Redo → Extract…Recipe in the top bar: tick the steps, then copy or save the JSON; also History → Extract…
Undo / Redo → Apply…Recipe → Apply a recipe…

Export

OpenRefine (Export)OxRefine (Export)
Tab-separated / Comma-separated valuesTSV… / CSV…
HTML table / Excel (.xlsx) / ODF spreadsheetHTML table… / Excel (.xlsx)… / OpenDocument (.ods)…
Excel 97 (.xls)Export → Excel 97
Custom tabular / SQL / TemplatingCustom tabular… / SQL… / Templating…
Export projectOpenRefine project…

Expressions

OpenRefineOxRefine
GRELGREL, every function except wikibaseIssues; see the reference
Python / Jython, ClojureNot yet
Expression history and starred expressionsHistory of recent expressions in the editor

Server and API

OpenRefineOxRefine
refine -i 0.0.0.0ox serve --host 0.0.0.0, behind an access token
HTTP API (/command/core/...)OxRefine's own JSON API; OpenRefine's API is not implemented yet
Batch use through the API or client librariesox apply recipe.json input -o output