OpenRefine

OpenRefine (formerly Google Refine) is a free, open-source tool for working with messy data. It enables users to clean data, transform it between a variety of formats, extend it with web services, and link it to databases. This tool is available for Windows, Mac and Linux.

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. OpenRefine is open source software and is licensed under the BSD license located in the LICENSE.txt. See the folders licenses under /main/webapp/ as well as within each /extensions 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-driven project. Since 2020, OpenRefine is fiscally sponsored by Code for Science and Society (CS&S).