How to Book Bibliography Data Convert Excel to MARC format

1. Save As the Excel file, to 'Unicode Text (*.txt)' format.
2. Download and install MARCEdit software.

Old Version 

Latest Version

3. Open the MARCEdit Software.

4. Use MARCEdit Click the 'Delimited Text Translator' to convert Text format to MRK format.
5. Use MARCEdit Click the 'MARC Tools › MarcMaker' to convert MRK format to MRC format.

Koha MARC Tag

SL. No	ITEM TYPES	MARC  TAG
1	AUTHOR	100$a
2	TITLE	245$a
3	BARCODE  / ACC  NO	952$p
4	BARCODE SERIES	490$a
5	DDC (Call Number)	082$a & 952$0
6	BILL  NO	300$c
7	PAGE	300$a
8	EDITION	250$a
9	YEAR OF PUBLICATION	260$c
10	PRICE	952$g
11	OPAC PRICE	300$b
12	PUBLISHER	260$b
13	PLACE OF PUBLICATION	260$a
14	SUBJECT	650$a
15	COLLECTION CODE (Type of Collection and Relevant Department)	952$8
16	SHELVING  LOCATION (Department Full Name )	952$c
17	ELECTRONIC  LOCATION (Online book Link)	856&u
18	DATA ACQUIRED (Book Data Entry date)	952$d
19	ISBN	020$a
20	NOTES (Remark / Book Purchase from)	500$a
21	LOST STATUS (Missing  Lost)	952$1
22	ITEM TYPE CODE (Book, CD, Book  Bank)	942$c
23	ITEM TYPE CODE (Reference (or) Transfer)	952$y
24	BRANCH CODE  (Current Location )	952$a
25	BRANCH CODE ( Home Library)	952$b

Book Data Convert to MARC Process

Go to: Tools > Stage MARC records for import

• You can enter a name for this import. It may be useful, when creating a record, to remember where the suggested MARC data comes from!

Stage records into the reservoir

1. Select the file to stage: