Skip to Main Content
It looks like you're using Internet Explorer 11 or older. This website works best with modern browsers such as the latest versions of Chrome, Firefox, Safari, and Edge. If you continue with this browser, you may see unexpected results.

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