OpenRefine - a open source tool for working with data
summary
OpenRefine is an open‑source, browser‑based data cleaning tool (born from Freebase in 2006, with Wikidata launched 2012) that runs offline or connected, imports CSV/Excel/Google Sheets/APIs, and exports CSV/JSON/Excel. It performs clustering and deduplication with methods like key collision and nearest neighbor, supports JS/Python transforms, and reconciles records against Wikidata or a local Wikibase instance. Used to update COVID infoboxes across ~300 languages and to prep election and mapping datasets; shows upload errors and can push cleaned data to Wikidata and Wikimedia Commons (>10M media).
AI-written summary · about
chapters (10)
- 0:00OpenRefine introduction
- 1:09What is OpenRefine
- 2:56Key features
- 5:45Interface and import
- 8:15Cleaning data with filters
- 9:39Transforming data
- 10:23Reconciliation with databases
- 12:56Uploading to Wikidata
- 14:19Contributing to Wikimedia Commons
- 15:02Real-world use cases
related talks
40mMigrating Freebase to Wikidata
36mOpenbytes Builds Open Dataset Standards and Schema Aiming to Bring Transformational Changes to AI by Making Open Datasets More Available and Accessible
01h 03mMicrosoft Data Explorer for Excel: Data Discovery & Transformation
15mSharing Connects People
37mOPEN DATA - THE NEW GOLD WITHOUT THE RUSH
04mLook before you Link: Privacy Risk Inspection of Open Data through...
38mUsing OpenDataKit with OpenStreetMap
27mUsing Wikidata and OpenStreetMap