Many academic institutions used library management software for the access, dissemination, store and use of information or store of bibliographic record or store member data, administrative works. These libraries used different types of automation software as like SOUL, Libsys, Koha, e-grantahalaya etc. In this paper I tried to explain the data migration from excel sheet to library automation software database. Our college library ware stored a huge numbers of bibliographic data on excel sheet. I tried to convert theses data to our database and reduced effort, time and monotony of jobs.