Welcome to the new OpenRefine site!
OpenRefine (ex-Google Refine) is a powerful tool for working with messy data, cleaning it, 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
The most recent 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.
Introductory to OpenRefine
1. Explore Data
OpenRefine can help you explore large data sets with ease. You can find out more about this functionality by watching the video below and going through these articles
2. Clean and Transform Transform Data
3. Reconcile / Match
OpenRefine can be used to link and extend your dataset with various webservices. 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 in learning more about OpenRefine? Check the documentationage) for more information. Please also read the Frequently Asked Questions (FAQ) for helpful troubleshooting hints.