I recently did a conversion of an Excel file, but not quite directly. Based on what had been described by several others in some previous posts:
I set up a template in WORD mail merge that would be loadable into the Marcedit program.
then fed the Excel file into WORD mail merge (the Excel file was for music CDs from the Music Library here) and created the file for Marcedit.
I then opened the file in Marcedit (which is extremely easy to use), did some find/replace for some cleanups, then saved it as a MARC file.
then went into Innopac and used FTS to get the file from the PC, ran it through the pre-process function, then it was ready to load.
I had done a few records first to test the process and make sure the records turned out the way we wanted and that they would load properly.
P.S. For the template, I found the info I needed in a post from 4/6/2001 from P. Matthew Polcyn at Otterbein College [Thank you Matt!] - it is in the list archives. That showed me a sample format so I could set up my own for the CDs.
California State University, Los Angeles
From: Rey Racelis [mailto:RRacelis@xxxxxxxxxx]
Sent: Tuesday, July 03, 2001 2:59 PM
Subject: xls to marc to innopac records
If there is anybody out there that uses excel to create bib
records (SERIALS SPECIFICALLY) and then convert the data into marc
format before innopac load, I will be much interested in hearing
from you. I know that in some ways, it can probably work by
converting excel files into txt or word files and then convert
into marc. (CF Jiras and Fatig presentation last IUG on txt to
marc).I am curious if it can be done directly from xls to marc. If
you are applying this to create serials records I will be doubly
interested. If you know of any sites with lists produced this way,
Pace University Library
Rey P. Racelis
Asst. University Librarian
Concurrent: Innopac Systems Administrator
Pace University Library System
NetMeeting IP (Intranet)
Sent via the Pace University Mail system at fsmail.pace.edu
This message was distributed through the Innovative Users Group INNOPAC list.
Private replies: "Rey Racelis" <RRacelis@xxxxxxxxxx>
Public replies: INNOPAC@xxxxxxxxxx