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 forinstalling or upgrading OpenRefine on Windows, Mac, and Linux computers. It then walks you throughthe 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 tostart a project by importing an existing dataset. We work through how toview and learn about your data using facets, filters, and sorting.

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

Finally we discuss what to do with your improved dataset, whetherexporting it to a file oruploading 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 theTroubleshooting 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 ourrecommendations list.