MARCEdit free software can convert Excel files to MARC and back. I've used MARCEdit to do other stuff, but not this particular task.
Here is a tutorial from the University of Illinois on how to do it. https://guides.library.illinois.edu/c.php?g=463460&p=3168299 Here is the link to download MARCEdit. https://marcedit.reeset.net/downloads Best wishes, Faye Leibowitz University of Pittsburgh frle...@pitt.edu ________________________________ From: Hasafran <hasafran-bounces+frleibo+=pitt....@lists.osu.edu> on behalf of AMK Judaica via Hasafran <hasafran@lists.osu.edu> Sent: Sunday, August 23, 2020 2:16 PM To: Hasafran <hasafran@lists.osu.edu> Subject: [ha-Safran] Basic cataloging program for small collections? (Librarything.com?) Hello safranim, 1) I'm looking for suggestions/recommendations/advice for the easiest/quickest way to catalogue some smaller private collections for basic record keeping (so no need for any features for circulation tracking, online public browsing of records, etc.). I just need a website/program/app that will let me input a call number, ISBN or title/author/etc. and will then populate for me all the basic bibliographic information (title, creators, imprint data, collation, etc.) into a spreadsheet or database that can be stored (online or locally) and at various points transferred/converted easily to Excel or (preferably) Filemaker. Hebrew character recognition (for transfer also) and a scanning function (rather than manual input) would be big pluses. 2) Is there a way for non-professional/institutional librarians to copy Marc records into Excel or Filemaker (either directly or through some software? 3) I've been playing with Librarything.com to see if it might work for me and it is ok so far. A) Is there a way to scan (not type) ISBN, call number, title, etc. rather than the bar code (most books I'm working with don't have bar codes)? B) How can I create new custom fields? C) Is there a way to search for a book across all the sources (Amazon, Library of Congress, etc) without having to search each separately one by one? Thank you? Kol tuv, Ari Kinsberg **************** Ari Kinsberg M.A., Pharm.D. Brooklyn, New York 347-244-9747 (US cell) Consultant for Rare Books and Manuscripts Registered Pharmacist (NYS, Ohio) Certified Immunizer (NYS)
__ Messages and opinions expressed on Hasafran are those of the individual author and are not necessarily endorsed by the Association of Jewish Libraries (AJL) ================================== Submissions for Ha-Safran, send to: hasaf...@lists.service.ohio-state.edu To join Ha-Safran, update or change your subscription, etc. - click here: https://lists.service.ohio-state.edu/mailman/listinfo/hasafran Questions, problems, complaints, compliments send to: galro...@osu.edu Ha-Safran Archives: Current: http://www.mail-archive.com/hasafran%40lists.service.ohio-state.edu/maillist.html Earlier Listserver: http://www.mail-archive.com/hasafran%40lists.acs.ohio-state.edu/maillist.html AJL HomePage http://www.JewishLibraries.org -- Hasafran mailing list Hasafran@lists.osu.edu https://lists.osu.edu/mailman/listinfo/hasafran