OpenRefine user manual

This manual is designed to comprehensively walk through every aspect of setting up and using OpenRefine, including every interface function and feature.

This user manual starts with instructions for installing or upgrading OpenRefine on Windows, Mac, and Linux computers. It then walks you through the interface and how to run OpenRefine from a program or command line, with or without setting custom preferences and modifications.

The manual then teaches you how to start a project by importing an existing dataset. We work through how to view and learn about your data using facets, filters, and sorting.

Then we launch into transforming that data permanently through common and custom transformations, clustering, pulling data from the web, reconciling, and writing expressions.

Finally we discuss what to do with your improved dataset, whether exporting it to a file or uploading statements to Wikidata, Wikimedia Commons, or another Wikibase instance.

If you're stuck on any aspect and can't find an answer in the manual, try the Troubleshooting page for links to various places to find help.

If you are new and want to learn how to use OpenRefine using an example dataset, you may wish to start with a user-contributed tutorial from our recommendations list.