Processing notes for MARC Open Access files downloaded from: https://www.loc.gov/cds/products/marcDist.php Guide to MARC fields: http://folgerpedia.folger.edu/Interpreting_MARC_records MARC files were converted to csv using MarcEdit. Download and install MarcEdit from: http://marcedit.reeset.net Download and unzip UTF-8 format Note: After file is uncompressed the .gz extension remains. Remove .gz from the uncompressed file Change file extension to mrc Open xx.mrc file in MarcEdit Use the MarcSplit utility to split the file into a smaller segment. Choose 1000 records per file. Split into 1 file. Open split file using MarcEditor. Choose Reports — Field Count to determine which MARC fields are being used. Generate Report. Use report results to generate text load file. Clean text file and keep only field (and subfield if want subfield in separate columns) and remove column names. Save as a txt file. Keep fields and subfields in one column, then load file will contain only the MARC field number, e.g., 050,100,245, etc. Next, Convert MARC to CSV so that MARC fields (and subfields) are the column headers: MarcEdit Tools — Export Records — Export Tab Delimited Records Load the split MARC (.mrc) file. Choose comma as the delimiter Make sure the Normalize box is unchecked. Select Settings — Load Settings to load the text file of MARC fields and subfields you created. Comma separated file is generated and ready. Open in OpenRefine. Choose UTF-8 character encoding. Uncheck “Parse cell text into numbers, dates…”