By Lynn Whittenberger, Metadata Librarian, Raynor Memorial Library, Marquette University
Abstract: Describes the steps taken to extract Author/Corporate names from our local catalog (III-Sierra), the initial data cleanup work done in Microsoft Excel, and the final data cleanup work and Name reconciliation against the Virtual International Authority File (VIAF) and Library of Congress Name Authority file (LCNAF) using OpenRefine. Familiarity with extracting data from the local catalog and basic knowledge of how to use Excel is assumed. How to use OpenRefine for data cleanup and reconciliation is covered in depth (and with many screenshots).