Challenge view
Back to ProjectOpenRefine
A free, open source power tool for working with messy data and improving it
OpenRefine (previously Google Refine) is a powerful tool for working with messy data: cleaning it; transforming it from one format into another; and extending it with web services and external data. OpenRefine always keeps your data private on your own computer until YOU want to share or collaborate. Your private data never leaves your computer unless you want it to. (It works by running a small server on your computer and you use your web browser to interact with it). People in the open data and data journalism fields around the world use it regularly - and so should you!
OpenRefine's packaging for MacOS and Windows could be improved in many ways, and we are looking for help in this front. We are looking for proposals from prospective contractors to improve the install experience of OpenRefine on MacOS and/or Windows. After a similar effort on Ubuntu/Debian packaging, this initiative is meant to improve the user experience on other platforms, to lower the install barrier for a broader audience. This project is funded by an EOSS Diversity and Inclusion grant from CZI. (See detailed links in the Pro section below)
{ hacknight challenges }
Download OpenRefine and start it on your computer. Download some open data and explore this powerful data wrangling tool.
Check out the results of the 2022 Community Survey. Clean up, analyse, or prepare a new dataset using OpenRefine, and share your results with the community here or at forum.opendata.ch. Help to translate OpenRefine.
Compile the OpenRefine code from source. As detailed in the latest OpenRefine blog post, we are hoping that proposals could solve some of the following issues:
- (MacOS) Provide an Applications shortcut in the DMG distribution, with a suitable background (#5205)
- (MacOS) Sign and notarize our DMG distribution (#2191)
- (Windows) Offer a proper installer / uninstaller on Windows (#3224)
- (Windows) Give an easier way to start and stop OpenRefine with a system tray integration and log viewer (#3221)
- (Windows) Configuration for OpenRefine on Windows should use only 1 config file (.ini) (#3057)
- (Windows) Sign openrefine.exe to eliminate extra security warnings (#3003)
OpenRefine
OpenRefine is a Java-based power tool that allows you to load data, understand it, clean it up, reconcile it, and augment it with data coming from the web. All from a web browser and the comfort and privacy of your own computer.
Download
Snapshot releases
Latest development version, packaged for: * Linux * MacOS * Windows without embedded JRE * Windows with embedded JRE
Run from source
If you have cloned this repository to your computer, you can run OpenRefine with:
./refine
on Mac OS and Linuxrefine.bat
on Windows
This requires JDK 11, Apache Maven and NPM.
Documentation and Videos
Contributing to the project
Contact us
Licensing and legal issues
OpenRefine is open source software and is licensed under the BSD license
located in the LICENSE.txt. See the folder licenses
for information on open source
libraries that OpenRefine depends on.
Credits
This software was created by Metaweb Technologies, Inc. and originally written and conceived by David Huynh dfhuynh@google.com. Metaweb Technologies, Inc. was acquired by Google, Inc. in July 2010 and the product was renamed Google Refine. In October 2012, it was renamed OpenRefine as it transitioned to a community-supported product.
See CONTRIBUTING.md for instructions on how to contribute yourself.