Skip to content
EntityQ5583871· pop 21· linked from 598 articles

OpenRefine

Sign in to save

Also known as Google Refine, Freebase Gridworks, Gridworks, #openrefine

OpenRefine is an open-source desktop application for data cleanup and transformation to other formats, an activity commonly known as data wrangling. It is similar to spreadsheet applications, and can handle spreadsheet file formats such as CSV, but it behaves more like a database.

Key facts

Software.name
OpenRefine
Software.title
OpenRefine
Software.logo
OpenRefine favicon (2018-present).svg
Software.logo size
200px
Software.developer
Freebase, then Google, now open source community
Software.programming language
Java
Software.platform
Microsoft Windows, Linux, macOS
Software.language
English, Italian, Chinese, Japanese, French, German
Software.license
BSD License

via Wikipedia infobox

Described at

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.

Excerpt from a page describing this subject · 2,538 chars · not written by Vinony

Source code

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).

Excerpt from the source-code README · 4,241 chars · not written by Vinony

Wikidata facts

Official website
openrefine.org
Image
06 match with wikidata screenshot slides.png
Motto
A power tool for working with messy data.
Show 13 more facts
source code repository URL
github.com/OpenRefine/OpenRefine
software version identifier
3.10.1
Commons category
OpenRefine
official forum URL
forum.openrefine.org
social media followers
373
user manual URL
openrefine.org/docs
hashtag
OpenRefine
official shop URL
store.openrefine.org
official donation page URL
openrefine.org/donate
Sources (14)

via Wikidata · CC0

~4 min read

Article

5 sections
Contents
  • Uses
  • Supported formats
  • Development
  • References
  • External links

OpenRefine is an open-source desktop application for data cleanup and transformation to other formats, an activity commonly known as data wrangling. It is similar to spreadsheet applications, and can handle spreadsheet file formats such as CSV, but it behaves more like a database.

It operates on rows of data which have cells under columns, similar to the manner in which relational database tables operate. OpenRefine projects consist of one table, whose rows can be filtered using facets that define criteria (for example, showing rows where a given column is not empty).

Connections

Categories