Hello Ankit I don’t know if you’ve already had a better solution, but one route for the books data would be to create a text file that can be read by MARCmaker. (See http://www.loc.gov/marc/makrbrkr.html for examples of what is required.) We do this for our library catalogue which is in a SQL Server database. I use the ColdFusion programming language but another route might be to read the Excel file into Access and write a report that creates the right text format. Once you put it through MARCmaker you have a MARC file which can easily be read by Koha. Andrew Buxton IDS, Brighton, UK From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Ankit Gupta Sent: 12 November 2009 07:51 To: koha@lists.katipo.co.nz Subject: [Koha] Import Data from excel Hello Can somebody guide me towards a beginner tutorial for importing books and patrons data from excel to Koha. Regards Ankit Gupta three60 A 360º view of your school This message is for the addressee only and may contain privileged or confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any views or opinions expressed are solely those of the author and do not necessarily represent those of IDS. Institute of Development Studies at the University of Sussex, Brighton BN1 9RE Tel: +44 (0)1273 606261; Fax: +44 (0)1273 621202 IDS, a charitable company limited by guarantee: Registered Charity No. 306371; Registered in England 877338; VAT No. GB 350 899914