From Library Automation to Digital Repositories: A 5-Day Hands-on Workshop on Koha & DSpace for LIS Professionals at Online
November 1, 2026 at 7pm to November 5, 2026 at 7pm
LIS Links
First and Largest Academic Social Network of LIS Professionals in India
Top Content
Birthdays
Birthdays Today
Latest Activity
Mastering Scholarly Literature Discovery: Indexing, Open Access & Full Text Databases at Online
November 13, 2026 at 7:30pm to November 15, 2026 at 8:30pm
Mastering Scholarly Literature Discovery: Indexing, Open Access & Full Text Databases at Online
November 13, 2026 at 7:30pm to November 15, 2026 at 8:30pm
Two-Day National Seminar on “Smart Libraries: Integrating AI, IoT, and Intelligent Systems for Next-Generation Knowledge Services at Chitkara University, Himachal Pradesh (Pinjore-Nalagarh National Highway (NH-21A), kalujhinda, Baddi, Himachal Pradesh
February 19, 2027 to February 20, 2027
Importing Excel Data to Koha Software
I want to import Bibliographic data in MS Excel (.xsl) to Koha on Ubuntu platform.
What should be the Date format for date fields (e.g., 952$d), so that MarcEdit will read it properly? (MarcEdit is reading only MM field properly and putting in .mrk file). Tried many date formats in Excel all of which did not work.
Thanks in advance.
Regards
Views: 1373
Replies to This Forum
-
Permalink Reply by PRAVEEN KUMAR DEWANGAN on
-
Hello
Mukhedkar M. V
Whatever Excel format you are using that Date format Cell is protected sheet .....first you go to Excel file....format the particular date cell>>>>>uncheck the Protectiom box>>>>>save.
after that you entry all books date and after all complete data dont forger to protect the sheet thats it.
MM/DD/YYYY or DD/MM/YYYY all format works nicely.
-
Permalink Reply by Mukhedkar M. V. on
-
Thank you sir.
© 2026 Created by Dr. Badan Barman.
Powered by
