Every modern automated library relies on standardized bibliographic metadata to power its online public access catalog (OPAC), circulation desk, and interlibrary exchanges. At the heart of open-source library systems like KOHA ILMS lies MARC21 (Machine-Readable Cataloging). For many practicing librarians and cataloging staff, navigating hundreds of numeric tags, indicators, and subfield delimiters can feel overwhelming. This practical guide cuts through theoretical jargon to provide an operational, field-by-field reference and workflow for creating clean MARC21 records and importing spreadsheet data into KOHA without data corruption.
1. What is MARC21 and Why Is It Essential in KOHA?
MARC stands for MAchine-Readable Cataloging. Developed by the Library of Congress in the 1960s and refined into the MARC21 standard, it provides a standardized electronic data structure enabling computers to interpret, index, search, and exchange bibliographic information consistently across disparate library systems.
In KOHA, MARC21 serves as the foundational data model for both bibliographic description (the work/title level) and holdings management (the specific physical copies/items in your library). Using standard MARC21 ensures:
- Interoperability & Z39.50 Copy Cataloging: Direct record retrieval from national libraries (Library of Congress, British Library, OCLC) into your local KOHA database.
- Precision Indexing & Discovery: Granular search facets in OPAC allowing patrons to filter specifically by title, primary author, editor, subject heading, or publisher.
- Future-Proof Migration: Standardized data that can be exported or upgraded across any compliant Integrated Library System (ILS) without data loss.
2. Core MARC21 Bibliographic Tags Every Librarian Must Know
While the complete MARC21 standard contains hundreds of tags, over 95% of standard academic book cataloging relies on these essential fields:
| Tag | Field Name | Essential Subfields | Example / Usage |
|---|---|---|---|
| 020 | ISBN | $a (10 or 13-digit ISBN), $c (Price/terms) | 020 $$a 9780132350884 $$c Rs. 850.00 |
| 082 | Dewey Decimal Classification (DDC) | $a (Classification Number), $2 (Edition) | 082 04 $$a 025.04 $$2 23 |
| 100 | Main Entry — Personal Name (Author) | $a (Surname, First Name), $d (Dates), $e (Relator term) | 100 1# $$a Ranganathan, S. R. $$d 1892-1972 $$e author |
| 245 | Title Statement | $a (Title proper), $b (Remainder of title/subtitle), $c (Statement of responsibility) | 245 10 $$a Colon classification $$b basic classification $$c by S.R. Ranganathan |
| 250 | Edition Statement | $a (Edition text) | 250 ## $$a 6th ed., repr. with amendments |
| 260 / 264 | Publication / Distribution | $a (Place of publication), $b (Publisher name), $c (Date/Year) | 264 #1 $$a New Delhi $$b Ess Ess Publications $$c 2024 |
| 300 | Physical Description | $a (Extent / Pagination), $b (Illustrations), $c (Dimensions) | 300 ## $$a xxiv, 450 p. $$b ill. $$c 24 cm. |
| 650 | Subject Added Entry — Topical Term | $a (Topical term), $x (General subdivision), $z (Geographic) | 650 #0 $$a Classification, Colon $$x Rules |
| 700 | Added Entry — Joint Author / Editor | $a (Personal name), $e (Relator term, e.g. editor) | 700 1# $$a Kumar, Girja $$e joint author |
3. The Crucial KOHA Item Tag (952): Holding Level Data
While standard MARC tags (001–899) describe the title, tag 952 in KOHA is the dedicated field that stores physical copy details (accession numbers, barcodes, shelving location, branches, and price). A record imported into KOHA without tag 952 will create a bibliographic record with zero items attached.
Mandatory Subfields in 952
- $a : Permanent Holding Library / Branch Code (e.g. MAIN)
- $b : Current Owning Library Branch Code (e.g. MAIN)
- $p : Barcode / Unique Accession Number (e.g. ACC10492)
- $y : Item Type Code (e.g. BK for Book, REF for Reference)
Recommended Administrative Subfields
- $c : Shelving Location / Collection Code (e.g. GEN)
- $o : Full Call Number / Class + Book Number (e.g. 025.04 TYAG)
- $g : Cost / Replacement Price (e.g. 650.00)
- $7 : Not For Loan Status (0 = Can borrow, 1 = Reference Only)
4. Step-by-Step Workflow: Converting Spreadsheet Lists to MARC21 (.mrc)
Most libraries receive acquisition lists in Excel format (.xlsx / .csv). Here is the verified workflow for bulk converting Excel data into ISO 2709 standard MARC21 binary files using LISWALA's Excel to MARC21 utility:
Step 1 Standardize Spreadsheet Column Headers
Ensure your spreadsheet contains clean columns: Accession No, Title, Author, Edition, Publisher, Year, ISBN, Call No, and Price.
Step 2 Convert Using LISWALA Excel to MARC21 Tool
Upload your spreadsheet into the LISWALA Excel to MARC21 Converter. Set your Branch Code (e.g. MAIN) and Item Type (e.g. BK). The tool automatically maps title to 245$a, author to 100$a, publisher to 264, and injects complete 952 item holdings for every copy.
Step 3 Stage and Import into KOHA ILMS
Log in to KOHA Staff Client > Tools > Stage MARC records for import. Upload the downloaded .mrc file. Configure duplicate match rules (e.g. match on 020$a ISBN or 952$p Barcode) and click Stage for import.
Step 4 Review Staged Batch and Commit into Catalog
Open Manage staged MARC records. Verify record count and match diagnostics. Click Import into catalog. KOHA Zebra indexer will process the new records and make them immediately searchable in OPAC.
5. Common MARC21 Errors and How to Prevent Them
- Missing Tag 952: Importing bibliographic records without item tags results in ghost records with no physical copies for circulation.
- Invalid Indicators in Tag 245: Setting first indicator incorrectly (e.g., non-filing characters for titles beginning with "The", "A", or "An"). Use second indicator
4for "The " so OPAC searches ignore the article during alphabetical sorting. - Character Encoding Mismatches: Using ANSI/ASCII instead of UTF-8 encoding causes accented characters, diacritics, and Indian language scripts (Devanagari, Tamil, Bengali) to render as distorted symbols. Always ensure UTF-8 encoding in Leader byte 09.
- Duplicate Barcodes in 952$p: Ensure every physical item copy has a distinct barcode to prevent circulation check-out collision.
Key Takeaways for Practicing Librarians
Standardized MARC21 cataloging is the cornerstone of effective library management. By mastering key bibliographic fields (020, 100, 245, 260/264, 300, 650) and configuring accurate KOHA 952 item holdings, catalogers ensure flawless OPAC discovery, seamless circulation desk transactions, and audit-ready collection data.