Hi All, I importing books data from excel to koha. book data includes both records and items. Using marc editor, we can convert excel to marc file. My problem is that during migration of items. koha import multiple records of same recode according to no of items. the format of mark file is: =LDR 00000nam a2200000Ia 45e0 =008 090519s9999\\\\xx\\\\\\\\\\\\000\0\und\d =100 \\$av100a =245 \\$av245a$cv245c =250 \\$av250a =260 \\$av260a$bv260b$cv260c =300 \\$av300a =350 \\$av350a =650 \\$iv650i =700 \\$av700a =952 \\$av952a$ov952o$pv952p$tv952t =LDR 00000nam a2200000Ia 45e0 =008 090519s9999\\\\xx\\\\\\\\\\\\000\0\und\d =100 \\$a"Radhakrishnan, P." =245 \\$aCAD/CAM/CIM$c"Radhakrishnan, P.,Subramanyan, S.,Raju, V." =250 \\$a2nd ed. =260 \\$aNew Delhi$bNew Age International$c2000 =300 \\$a672p.% =700 \\$a"Subramanyan, S.%Raju, V.%" =952 \\$aCL$o620.042502854 RAD$p0001$t1$yBK =LDR 00000nam a2200000Ia 45e0 =008 090519s9999\\\\xx\\\\\\\\\\\\000\0\und\d =100 \\$a"Radhakrishnan, P." =245 \\$aCAD/CAM/CIM$c"Radhakrishnan, P.,Subramanyan, S.,Raju, V." =250 \\$a2nd ed. =260 \\$aNew Delhi$bNew Age International$c2000 =300 \\$a672p.% =700 \\$a"Subramanyan, S.%Raju, V.%" =952 \\$aCL$o620.042502854 RAD$p0002$t2$yBK =LDR 00000nam a2200000Ia 45e0 =008 090519s9999\\\\xx\\\\\\\\\\\\000\0\und\d =100 \\$a"Radhakrishnan, P." =245 \\$aCAD/CAM/CIM$c"Radhakrishnan, P.,Subramanyan, S.,Raju, V." =250 \\$a2nd ed. =260 \\$aNew Delhi$bNew Age International$c2000 =300 \\$a672p.% =700 \\$a"Subramanyan, S.%Raju, V.%" =952 \\$aCL$o620.042502854 RAD$p0003$t3$yBK =LDR 00000nam a2200000Ia 45e0 =008 090519s9999\\\\xx\\\\\\\\\\\\000\0\und\d =100 \\$a"Radhakrishnan, P." =245 \\$aCAD/CAM/CIM$c"Radhakrishnan, P.,Subramanyan, S.,Raju, V." =250 \\$a2nd ed. =260 \\$aNew Delhi$bNew Age International$c2000 =300 \\$a672p.% =700 \\$a"Subramanyan, S.%Raju, V.%" =952 \\$aCL$o620.042502854 RAD$p0004$t4$yBK 952 tages are used for item fileds. Expected solution (single record with multiple items) can be obtained by using following format. =LDR 00000nam a2200000Ia 45e0 =008 090519s9999\\\\xx\\\\\\\\\\\\000\0\und\d =100 \\$a"Radhakrishnan, P." =245 \\$aCAD/CAM/CIM$c"Radhakrishnan, P.,Subramanyan, S.,Raju, V." =250 \\$a2nd ed. =260 \\$aNew Delhi$bNew Age International$c2000 =300 \\$a672p.% =700 \\$a"Subramanyan, S.%Raju, V.%" =952 \\$aCL$o620.042502854 RAD$p0001$t1$yBK =952 \\$aCL$o620.042502854 RAD$p0002$t2$yBK =952 \\$aCL$o620.042502854 RAD$p0003$t3$yBK =952 \\$aCL$o620.042502854 RAD$p0004$t4$yBK with multiple item 952 tags. for this format, how we can convert excel file in this format. may be it is a join of two excel files, please tell the "how to" solution for data migration for multiple items. Thanks and regards -- Er. Amandeep Kansal B.Tech, RHCE Network Engineer Chitkara Educational Trust Plot No.11-12,Ground Floor, Dainik Bhasker Building ,Sector 25-D, Chandigarh- 160014. http://linuxtosavemoney.blogspot.com/