Excel to MARC Converter Online

Transform your Excel spreadsheets into standard MARC format. Developed by Shivam Moradia, College Librarian, St. Xavier's College (Autonomous), Ahmedabad, under the guidance of project mentor Dr. Meghna Vyas, Associate Professor, PG Department of Library and Information Science, Sardar Patel University, Vallabh Vidyanagar.

Here is the link.

https://excel-to-marc-convetor-online.netlify.app

Import MARC records into Koha using graphical interface

Prepare MARC file. 

Check item information (tag number 952); branch code, accession number, item type etc. If number of MARC records goes beyond 1000, split into small batches (1000 records per batch). Otherwise, it will take a long time to import records and chance for time out and can't know the progress. Command line method is good for importing bulk records.

A sample MAR record

Bulk marc import using command line

Load environmental variables

sudo su
export PERL5LIB="/usr/share/koha/lib"
export KOHA_CONF="/etc/koha/sites/library/koha-conf.xml"

Move marc file to the folder where bulkmarcimport.pl is located.

e.g. Move a marc file from your home folder to following folder,