Work with MARC files, privately.

Choose a tool, load ISO 2709 .mrc files or a ZIP, make your changes, then download a new MARC or MARCXML file. MARC and ZIP files stay in this browser and are never uploaded. A SQL Server .mdf file is the exception: it is uploaded so it can be read, then deleted.

Run this on your Koha server

Download the plugin and upload it in the staff interface under Administration → Manage plugins, then enable MARC Utilities. Open it from Cataloging, from More → MARC utilities, or from Tools → Tool plugins. Staff who will use it need the Use tool plugins permission.

Download Koha plugin

Merge MARC records

Records are kept in their original order. Duplicate records are retained.

No files loaded

↑Choose MARC files or a ZIPDrop files here, or click to browse. Every file inside a ZIP is treated as a MARC file, regardless of its filename extension.

Duplicate handling

Choose what happens when more than one source file describes the same title.

Remove duplicate bibliographic records

SQL Server database

This file is uploaded to koha.pro so SQL Server can attach or restore it. It is deleted after you download the MARC file, or after 30 minutes. SQL Server Express can attach a database up to 10 GB. One row becomes one bibliographic record, and item columns on that row become one 952 field.

SQL Server backup (.bak) — recommended

ℹ SQL Server Database Upload Requirements

Recommended maximum: 5 GB database upload.
Current upload limit: 10 GB per file.
SQL Server Express: Database size limitations apply.
Large uploads: Processing may take several minutes after the upload reaches 100%.
Privacy: Database files are temporarily stored and subject to session cleanup.

For best results, use a stable internet connection and keep this browser tab open until processing completes.

↑Or choose a SQL Server .mdf fileThe primary data file only. Add the log file below if you have one. Optional log file for MDF (.ldf)

Download format

Load one or more MARC files to begin.

Designed for practical Koha cleanup

Use 952$a for home branch, 952$b for holding branch, 952$y for item type, and 952$p for barcode.
Custom fields are supported: enter a three-character MARC tag and a one-character subfield code.
Use a copy of your source file and test the resulting MARC before importing it into production.
Large MARC files are processed in this browser, not on the koha.pro server. A very large MARC file can slow down or crash the tab if the computer does not have enough memory.
A SQL Server .mdf upload leaves this browser. koha.pro deletes that file after the MARC download or after 30 minutes.