Skip to main content

Open Refine

Open Refine
Get the code

Language

default

Tool Type

Manual

License

The 3-Clause BSD License

Version

default

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.

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.

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