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 Libraries
See Updates and FAQs for the latest library services updates. Subject Librarians are available for online appointments, and Virtual Reference has extended hours.

Text Analysis Tools

A companion to our Text and Data Mining Sources infoguide, this guide will take you through how to use several text analysis tools

About OpenRefine

Previously called Google Refine, OpenRefine is a tool used to clean messy data, transform data from one format to another, and extend data. Features of this tool include importing, filtering/faceting, editing, and exporting data. Users are also able to fetch additional data with Wikidata, use web services to extend data, and add more features to OpenRefine through installing extensions. OpenRefine keeps data private on your own computer until you're ready to share it. 

OpenRefine Resources

OpenRefine resources:

OpenRefine tutorials: 

Blog posts showing how to use OpenRefine:

Getting Started with OpenRefine

1. Download OpenRefine from their website. OpenRefine runs as a small web server on your own computer and you point your web browser at the web server in order to use OpenRefine. It works best on Chrome, Chromium, Opera, and MS Edge. For more information on this, see their installation instructions.

2. Once OpenRefine is running in one of your browsers, create a project by importing data. OpenRefine supports TSV, CSV, *SV, Excel, JSON, XML, RDF as XML, and Google Data documents. You can import data from your computer, a URL, clipboard, database, or Google Data. 

3. Your data will load. You can parse your data, create a project name, and add tags. Click create project when done. 

4. You are able to perform several different functions to your data, including filtering and faceting; editing cells, columns, and rows; undoing and redoing changes to you've made to your data; reconciling your data; and increasing the functionality of OpenRefine through extensions. For more information on these various functions, see OpenRefine's documentation. 

5. Export your data by clicking on the export button in the upper right hand corner. You are able to export your data in multiple formats: TSV, CSV, Excel, and an HTML table.