Identifying potential headings for Authority work using III Sierra, MS Excel and OpenRefine
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).
Creative Commons License
This work is licensed under a Creative Commons Attribution-Share Alike 4.0 International License.
Whittenberger, Lynn K., "Identifying potential headings for Authority work using III Sierra, MS Excel and OpenRefine" (2015). Library Faculty Research and Publications. 81.
Unpublished paper. © 2015 The Author. Used with permission.