OpenRefine is a free, open source power tool for working with messy data and improving it - GREL String Functions · OpenRefine/OpenRefine Wiki

OpenRefine is a free, open source power tool for working with messy data and improving it - Recipes · OpenRefine/OpenRefine Wiki

I think you can get the XML mapping straight from OR without resorting to Excel.

Using OpenRefine and stable, publicly available APIs, the process automatically searches the Virtual International Authority File (VIAF) for matches to personal and corporate names, looks for a Lib...

OpenRefine, formerly Google Refine, bills itself as “a free, open source, powerful tool for working with messy data.”  As someone who works with messy data almost every day, I can’t recommend it enough.  While Open Refine is a great tool for cleaning up “grid-shaped data” (spreadsheets), it’s a bit more challenging to use when your source data is … Continue reading Adventures in metadata hygiene: using Open Refine, XSLT, and Excel to dedup and reconcile name and subject headings in EAD →

This video introduces Google Refine, a free, power tool for working with messy data.

Presentation Material for OLA 2015 Super Conference session on OpenRefine (http://www.olasuperconference.ca/sessions/803h/) - GitHub - elibtronic/OLA_2015: Presentation Material for OLA 2015 Super ...

List of reconciliation services.

Build over time, the RefinePro knowledge base list tutorials, how to and tips for OpenRefine (formerly Google Refine)

In an earlier post  I discussed using Open Refine  (formerly Google Refine ) to clean and reconcile taxon names. I've added an additional se...

This is the third part of a series of articles that shows how to use several really nice tools to play with open data. In the first article we saw how to take our comma-separated list of google con…

Here’s a quick walkthrough of how to use OpenRefine to prepare a simple data file. The original data can be found on a web page that looks like this (h/t/ The Gravesend Reporter): Take a minu…

Until I began my current research project earlier this year, my work has focused primarily on small, geographically circumscribed groups of scientists, philosophers, and other intellectuals. Consequently, I've never had much use for databases in my research. Now that I'm beginning my dissertation research in earnest, I am being forced to deal with a very new challenge: collecting and organizing information on hundreds of individuals, publications, and organizations from all over the world. Now, if you're like me, you find the prospect of having to collect birth, death, education, and employment records for the subjects of your research to be an exceedingly dull exercise, but one you need to have finished before you can actually begin to sit down and write. Fortunately, with OpenRefine (formerly GoogleRefine) and Freebase you can automate most of this initial data collection process.

The world's largest data journalism learning community. Featuring free video courses, long reads, resources and a discussion platform.