Cataloging and Metadata Commons^™

Identifying Potential Headings For Authority Work Using Iii Sierra, Ms Excel And Openrefine, Lynn K. Whittenberger

Library Faculty Research and Publications

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