Skip to Main Content

University Library, University of Illinois at Urbana-Champaign


A free, open source, powerful tool for working with messy data.

What is OpenRefine?

OpenRefine, previously known as GoogleRefine, is a powerful, open source software which visualizes and manipulates large quantities of data all at once. OpenRefine looks like a spreadsheet, but operates like a database, allowing for increased discovery capabilities beyond programs like Microsoft Excel.

What can OpenRefine do?

OpenRefine can be used to explore, clean, and link data on a large scale. Functions include:

  • Data Normalization
  • Column Reorganization
  • Faceting and Clustering
  • Tracking Operations
  • Exporting Data

8/22/2018 - Brinna Michael