OpenRefine is compatible with data in CSV, TSV, *SV, Excel (.xls .xlsx), JSON, XML, RDF as XML, Google Sheets. Support for other formats can be added with Google Refine extensions.
To upload your data:
OpenRefine will display a preview of your data, along with some options found within the lower section. To begin using OpenRefine, click the Create Project button found on the top right of the screen.
OpenRefine will automatically save changes you make to your date as well as your operational history. To resume working on a project, select open project to access a list of your active projects.
View Options
Transformation/Edit Options
Single Cell Edits
Any change that you make to your data in OpenRefine can be undone, and is documented and numbered from when you first create your project.
Use the Undo/Redo option to change any action, or to change a group of actions you have performed on this data.
Your operational history is saved along with your data as part of your project. Quitting OpenRefine and reopening your project does not disturb the operational history.
Operational history can also be extracted and applied to additional datasets.
Note, edits modifying the contents of a specific, single cell are not captured in the operational history.
GREL (General Refine Expression Language) allows you to build custom facets, filters and transformations beyond what is offered through OpenRefine menu options.