Document Type

Unpublished Paper



Publication Date


Source Publication

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).


Unpublished paper. © 2015 The Author. Used with permission.

Creative Commons License

Creative Commons Attribution-Share Alike 4.0 International License
This work is licensed under a Creative Commons Attribution-Share Alike 4.0 International License.