Skip to main content

Open Refine

Open Refine
Get the code

Language

Java, Javascript

Tool Type

Manual

License

The 3-Clause BSD License

Version

3.9.2003

About the tool Responsible

OpenRefine

Open Refine
What is it?

Open Refine is a powerful tool for working with messy data. It allows you to clean, transform, and enrich data sets using web services and external data, all from a browser and in the privacy of your computer. With features such as facets for exploring large volumes of data, clustering to correct inconsistencies, and reconciliation with external databases, Open Refine facilitates efficient information management. It also offers a history of operations with undo and redo options, ensuring complete control over your data.

What problems does it solve?

OpenRefine solves the problem of working with messy data by offering a free and open-source tool that cleans, transforms, and enriches data. It facilitates the correction of inconsistencies and integration with external databases, improving the quality and usefulness of data for decision-making.

How does the tool work?

OpenRefine is an open source tool that allows you to load, understand, cleanse, reconcile, and enrich data from a web browser. It runs on your computer, guaranteeing privacy, and offers features such as faceting, clustering, and reconciliation to improve data quality and consistency.

Open standards

OpenRefine uses open standards such as the JSON data format for data import and export, and the Data Reconciliation Protocol for connecting to external databases. Furthermore, its source code is available under the BSD license, promoting transparency and collaboration in its development.

Sector
Science and Technology
Functionality
Data collection analysis and visualization
Data interoperability
Content management
Sustainable development goals
Quality education
Industry innovation and infrastructure
Partnership for the goals
Toolkits
Country - Colombia
hands
Get the code for this project
Get the code

Connect with the Development Code team and discover how our carefully curated open source tools can support your institution in Latin America and the Caribbean. Contact us to explore solutions, resolve implementation issues, share reuse successes or present a new tool. Write to [email protected]

Contact us
Exploration view in OpenRefine Exploration view in OpenRefine

Displays a table of the 100 most populous cities and allows filtering by country using facets.

Facet panel in OpenRefine Facet panel in OpenRefine

Interface for filtering data by country, population, or city name using facets and adjustable ranges.

Transformation history in OpenRefine Transformation history in OpenRefine

Displays the sequence of steps applied to the project, including text transformations and column creation.

Official site

What it is and what it is used for (use cases).

See more
Cases/Uses

Uses in journalism and GLAM.

See more
User Manual

Complete guide to functions and flow.

See more
OpenRefine Blog

Community news and articles.

See more
Pavimentados
Optimizing road maintenance and signaling with computer vision.

Transport
Geolocation
Image processing
UrbanPy
Simplifying urban data collection and analysis for effective planning.

Urban Development and Housing
Geolocation
Database management
Víasegura
Improving road safety with automatic problem detection.

Transport
Simulators
Congestiómetro
Improving urban mobility with real-time traffic analysis.

Transport
Geolocation
Distancia2
Using AI to improve the management of social distancing in pandemics.

Reform or Modernization of the State
Image processing
see all tools
hands
Deepen your knowledge on the implementation of tools in the public sector with our courses, guides and many other resources.
Be part of the community
Jump back to top