Welcome to the new OpenRefine site!
(former Google Refine) OpenRefine is a powerful tool for working with messy data, cleaning it up, transforming it from one format into another, extending it with web services, and linking it to databases like Freebase.
Please note that since October 2nd, 2012, Google is not supporting actively this project which have been rebranded to OpenRefine. Project development, documentation and promotion is now fully supported by volunteers. Find out more about the history of OpenRefine and how you can help the community.
Download OpenRefine
Currently the latest stable version of OpenRefine is Google Refine 2.5. The next release (OpenRefine 2.6) will carry the new branding.
- For Windows, Download, unzip, and double-click on google-refine.exe. If you’re having issues with the above, try double-clicking on refine.bat instead.
- For Mac, Download, open, drag icon into the Applications folder and double click on it.
- For Linux, Download, extract, then type ./refine to start.
The list of all previous releases is here.
Introduction to OpenRefine
Explore Data
OpenRefine can help you to explore large data set with ease. You can find out more about this functionality by going through those articles
Clean and Transform Transform Data
Reconcile
OpenRefine can be used to link and extend your dataset with various webservice. Some services like Freebase also allow OpenRefine to update your cleaned data to the central database. A (growing) list of extension and plugin with sources is available on the wiki.
Interested to learn more about OpenRefine? Check the documentation page to access to all resources. Alternatively your can also check the FAQ.