SJSU Research Guides: Statistical Software: OpenRefine

Getting Started with OpenRefine

OpenRefine is an application that allows one to clean, process and/or transform data via Graphical User Interface (GUI), which means that little programming is required.

TSV, CSV, Excel (.xls and .xlsx), JSON, XML, RDF as XML, and Google Data documents are all supported. Support for other formats can be added with OpenRefine extensions.

OpenRefine Homepage
Access the OpenRefine development community, as well as an archive of project blog posts. Download OpenRefine software here.
OpenRefine Documentation
The official OpenRefine documentation wiki. Includes installation instructions, screencasts and recipes for achieving certain tasks.

Using OpenRefine by Ruben Verborgh; Max De Wilde
ISBN: 9781783289097
Publication Date: 2013-09-10
The book is styled on a Cookbook, containing recipes - combined with free datasets - which will turn readers into proficient OpenRefine users in the fastest possible way. This book is targeted at anyone who works on or handles a large amount of data. No prior knowledge of OpenRefine is required, as we start from the very beginning and gradually reveal more advanced features. You don't even need your own dataset, as we provide example data to try out the book's recipes.