Templates & Guide
Overview of data formatting rules and downloadable Excel template.
Single & Multiple Copies
Specify Number of Copies and Starting Barcode. For multiple copies, barcodes automatically increment sequentially (e.g. LIB1001, LIB1002).
Mandatory Fields
Author (100$a), Title (245$a), Class No. (082$a), Item Type (942$c), Home Lib (952$a), Current Lib (952$b), and Call Number (952$o) are strictly required.
Optional Metadata
ISBN (020$a), Edition (250$a), Place & Publisher (260$a/$b), Year (260$c), Pages (300$a), Price (952$v), and Accession Date (952$d) can be included as needed.
Empty Subfields Ignored
Optional fields left blank are intelligently omitted without generating empty subfields or invalidating MARC21 record structure.
Use the recommended template to ensure accurate MARC21 conversion.
Upload Excel File
Upload your catalog spreadsheet to generate standard binary MARC21 records.
Drag & Drop Excel File Here
Supports .xlsx and .xls formats (or .csv)
Specify "Number of Copies" and "Starting Barcode" in your Excel file. The converter will automatically replicate items and sequential barcodes.
Privacy Guaranteed: All files are converted securely. Your catalog data remains strictly confidential.
You May Also Need
Based on your current workflow, these tools might be helpful.