Latest Activity

Krishna kumar yadav left a comment for Anil Singh Yadav
17 hours ago
Dr Rajiv Vij updated their profile
23 hours ago
Mr. K. Kanipriyan is attending MD KAIYUM SHAIKH's event
yesterday
Vikash Kumar Dwivedi updated their profile
May 13
NAVEEN KUMAR SRIVASTAVA posted a status
"Please share deputation jobs"
May 10
NAVEEN KUMAR SRIVASTAVA updated their profile
May 10
Rakesh Sehrawat posted a status
"Anyone, in the journey of JRF this session?"
May 5
AYYAPPAN .Z updated their profile
May 3
Sanjana saini and Pritam Kumar Gupta are now friends
May 3
AYYAPPAN .Z left a comment for Balesh Kumar
May 3
AYYAPPAN .Z replied to SUNNY JOSEPH's discussion Academic Status to Librarian: UGC Letter and Court Order
May 3
Rahul kumar updated their profile
May 2
Rafeeque Ansari updated their profile
May 1
AYYAPPAN .Z replied to SUNNY JOSEPH's discussion Academic Status to Librarian: UGC Letter and Court Order
Apr 30
Suresh Vyas shared a profile on Facebook
Apr 29
Suresh Vyas shared a profile on Facebook
Apr 29
NADIM AHAMAD KHAN posted an event

hort Term Course on Koha and DSpace at Central Library deen dayal upadhyaya Gorakhpur University

April 30, 2026 to May 6, 2026
Apr 28
Dr. Sandip Pathak posted an event
Thumbnail

13th Convention Planner 2026 at Gauhati University,  Guwahati, Assam.

September 18, 2026 at 9am to September 20, 2026 at 7pm
Apr 28
Profile IconKannan G, Otturu pedapapaiah, Ardas Singh and 6 more joined LIS Links
Apr 28
Sanjana saini and Akshay Subhash Gadade are now friends
Apr 24

How to Migrate the Data from MS Excel to Koha

Sir/Madam,
I am looking for someone help to migrate the data from excel to koha. We have 50000 volumes in our college library and all the details of that are in excel that has been made before of koha installation. Now what I want is can I migrate all the data into koha and even if i can migrate the data, can it be accommodated effectively. I would like to inform you that I have installed the koha in ubuntu platform.

Views: 3103

Reply to This

Replies to This Forum

Dear sir,

Thank u very much for ur valuable reply. As per your instructions i had gone to the related site and i downloaded the marceditexcel setup file. while i am trying to install it on my computer it is asking me to install .net framework and if click yes it took me to the concern website to download .net framework. evenafter the download of .net if iam trying to install it on my computer again its asking me to install .net framework 3.1 for windows. i could not find the particular version. where i can download it. pls help me to trace or what are the supported software needed to be installed on my sytem prior to the installation of marceditexcel.

It's possible to migrate excel data to koha including holdings and circulation data. Before that it is imp to know, how the data is organized in the excel file. Importing of bibliographic details is almost easy. But holding is very difficult. At first we should organize koha parameters and excel file  according to the needs.

Dear sir,

Your suggestions are indeed helpful. Thanking you

If u want to use e-granthalaya, then use the utility tool available bellow link

http://egranthalaya.nic.in/EG3_MigrationTool_Excel.zip

sir,

  how  can it use in linux or ubndu. its only work in dos/ windows .please tell me the solution.

 

Marc edit is the suitable solution for converting excel data into koha. In Marc edit there is a component available Delimited text translator. Using that tool we can map excel columns into Marc fields.

thank you sir

if your problem is not solved send me your contact details on koustubh@cameoml.com

RSS

© 2026   Created by Dr. Badan Barman.   Powered by

Badges  |  Report an Issue  |  Terms of Service

LIS Links whatsApp