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 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:

This content is a preview from an external site.


DOI Join the chat at Java CI Coverage Status Translation progress

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.


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 Linux
  • refine.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.


This software was created by Metaweb Technologies, Inc. and originally written and conceived by David Huynh 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 for instructions on how to contribute yourself.

Event finished

30.11.2022 14:00

Event started

23.11.2022 13:00

Edited content version 5

20.11.2022 22:40 ~ loleg

Repository updated

20.11.2022 22:36 ~ loleg

Challenge posted

20.11.2022 22:36 ~ loleg
All attendees, sponsors, partners, volunteers and staff at our hackathon are required to agree with the Hack Code of Conduct. Organisers will enforce this code throughout the event. We expect cooperation from all participants to ensure a safe environment for everybody.

Creative Commons LicenceThe contents of this website, unless otherwise stated, are licensed under a Creative Commons Attribution 4.0 International License.

DINAcon HACKnights