LIS Links

First and Largest Academic Social Network of LIS Professionals in India

Latest Activity

Kapil Sunehria updated an event

UGC-MMTTP Online Two Week Refresher Course in Library and Information Science at RAMANUJAN COLLEGE, UNIVERSITY OF DELHI

August 31, 2026 at 10:30am to September 14, 2026 at 5:30pm
4 hours ago
Sourav Barman updated their profile
9 hours ago
Profile IconSourav Barman and Dr Chanchal Chaudhary joined LIS Links
10 hours ago
sangita mazumdar updated their profile
13 hours ago
Dr MANIKANDAN T posted a blog post
14 hours ago
Profile IconLIS Links now has job
16 hours ago
Murtuza Akhtar updated their profile
yesterday
chinnadurai.D and Dr MANIKANDAN T are now friends
yesterday
Profile IconPriyanka Beniwal, Khushi Jain, Meghna S and 10 more joined LIS Links
Monday
Dr MANIKANDAN T posted a blog post
Monday
Dr. A. Madhava Rao posted a blog post
Monday
Gopal Pandey posted an event
Monday
SHEIK MAIDEEN posted an event

Webinar on DELNET: Resources and Services at Online

September 9, 2026 from 3pm to 4pm
Monday
Kapil Sunehria posted an event

UGC-MMTTP Online Two Week Refresher Course in Library and Information Science at RAMANUJAN COLLEGE, UNIVERSITY OF DELHI

August 31, 2026 at 10:30pm to September 14, 2026 at 5:30pm
Monday
OSS Prasad posted an event

72nd ILA Annual Conference – International Conference on “Future Libraries: Advancing Research and Excellence (FLARE 2027)” at Indira Gandhi Memorial Library, University of Hyderabad, Gachibowli

January 7, 2027 to January 9, 2027
Monday
Shompa Das (Chaudhury) posted a discussion
Monday
Dr. Kalpana. T M updated their profile
Monday
sangeeta sharma is attending Sunita Pareek's event
Saturday
Dr MANIKANDAN T updated their profile
Friday
DHARITRI DEORI and vasudev tiwari are now friends
Friday

Can any one of my professional colleagues help to convert this attached Excel file to Marc format so that I can upload the file to koha software for a trial run of koha LMS in my Library. pls help.

Abdul Gafoor

Librarian, MESCE

Kerala

Views: 1214

Attachments:

Reply to This

Replies to This Forum

http://marcedit.reeset.net/ is the site which offer software for conversion to marc. But your intermediary steps to be in correct format. Otherwise it will not be converted. I am also trying. If you succeed kindly share with me also.

thanks and i will try

i am not comfortable with marc mapping or editing . any way i will try after reading the instructions well.

sir,

visit the following blog for step by step for data conversion from excel to koha.

http://lis-friends.blogspot.in/2015/07/excel-to-koha-data-conversio...

O.Seshaiah
Librarian
PBR VITS
Kavali
www.lis-friends.blogspot.in

Dear Mr. Abdul Gafoor, I have gone through your excel file. It is in good format, but it still lacks some essential MARC fields. These are :-

TITLE STATEMENT Statement of responsibility, etc --- 245 c

MAIN ENTRY Personal name ------ 100 a (this field should contain single author, but in yours some entries contain more than one author. And also personal name should contain comma between surname and forename.)

ADDED ENTRY Personal name ------ 700 a (Second and third author)

DEWEY DECIMAL CLASSIFICATION NUMBER Classification number ---- 082 a ( In yours it is call number. But it can be fixed. not a big problem)

Rest is fine. I can convert it into .mrc format but it is advised that first you fix above issues.

All the best.

Sir, whether it should be in excel format or in txt?

excel format.

thank you sir

i can do as directed

RSS

© 2026   Created by Dr. Badan Barman.   Powered by

Badges  |  Report an Issue  |  Terms of Service

LIS Links whatsApp