Skip to Main Content

University Library, University of Illinois at Urbana-Champaign

OpenRefine

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

Download OpenRefine

Before downloading, please read the complete installation instructions

NOTE: The system requirements are listed at the top of the installation instructions. If your computer does not meet the system requirements, please install the correct version of Java before downloading OpenRefine.

Click here to download OpenRefine. Select the download link for your computer's operating system.

NOTE: OpenRefine runs in a browser, like a web app, but does not require an internet connection to run. It works best on browsers based on Webkit such as Chrome, Opera, Chromium, and MS Edge, and automatically runs on your default browser. OpenRefine is unstable when run on Firefox or Internet Explorer, so it is best to choose another default browser.

When selecting a version to download, keep in mind that this guide includes information relevant to OpenRefine.

Create or Open a Project

  1. Open OpenRefine.
  2. To create a new project, select "Create Project."
  3. Data can be imported from a number of locations and in a number of formats. Select where you would like to get your data from, choose the files, and click "Next."

  1. This screen shows a preview of your data. Before creating the project, change the settings based on the file format (e.g. CSV, TSV, xls, JSON).
    1. For CSV or TSV data, set the character encoding to match the original file, identify how columns are separated, and choose options for  parsing the data.
    2. When you are done, click "Create Project."

  1. Once you've created a project, you can return at any time by using the "Open Project" tab on the home screen. Select the "Open Project" tab and choose the project you want to work on from the list.

  1. You are now ready to work with your data.

Language Preference

OpenRefine 3.3 includes a language function which allows you to set a preferred language. To change languages:

  1. Navigate to the "Language Settings" tab.
  2. Select your preferred language from the drop-down.
  3. Click "Change Language."

OpenRegine 3.3 currently supports:

English, Cebuano, Deutsch, Español, Filipino, Français, Hebrew, Italiano, Magyar, Nederlands, Norsk (bokmål), Português (Brasil), Română, Svenska, Tagalog, 日本語, Русский, 한국어, 简体中文, and الإنجليزية.

 

8/17/2018 - Brinna Michael