Revealing La Revolution: The Environmental Scan & Microsoft Excel, Part 2

As you now know I began my tenure as the interim Curator for Literature and Rare Books by trying to get more familiar with cataloged items in Rare Books and Special Collections by creating a spreadsheet that would give me an overview of the collection as a whole. Technical Services provided me with a MARC file containing the complete MARC records for every item in these collections and pointed me to MARCedit to be able to create a customized report about the collections. Previously I explained how I used MARCedit in Revealing La Revolution: The EnvironmentalScan & MARCedit, Part 1 . Now I’m going to share how I imported and set up my data in Microsoft Excel so that it revealed the contents of Rare Books and Special Collections to me. I began by opening a new workbook in Microsoft Excel and went to the “Data” Menu Ribbon. Excel Data Menu - Import from Text File In the furthest left column I choose to import my data “from text” and directed the request box to the corr...