[MCN-L] MARC record conversion into Excel or CSV?

Deborah Lenert DLenert at getty.edu
Wed Mar 21 20:35:56 UTC 2007

We have done this using MARConvert when we needed to import records for our archival and special collections into TMS.  The application is configurable to allow you to parse or suppress subfields in different ways so that the resulting data is much easier to work with.  If your source format is Word, I'm not quite sure how/if the records could be ingested without first transforming them somehow, but Stephen Toney at Systems Planning might have some ideas for you.

Good luck,

Deborah Lenert
Digital Projects Specialist
Getty Research Institute
Standards & Digital Resource Mgt. Dept.
phone: (310) 440-7351/ fax: (310) 440-7780
dlenert at getty.edu

>>> "Perian Sully" <psully at magnes.org> 3/21/2007 1:13 PM >>>
Hi all:

So the pressure is on to import a bunch of MARC records (in Word) into our
shiny new CMS (EMu). I need to convert the MARC Word document into some
format that I can then use to recode the MARC tags into EMu-speak. I've done
this with our old records using Excel, and would like to use Excel again to
work with the MARC records (yes, I recognize that this may mean that I'll
have potentially 1000 or so columns to deal with). And our archivist is
quite against Excel, and says that he can only get the MARC records in Word.
I don't know if this is true or not, but I'm pressuring the powers that be
to see if I can at least get the records in CSV or delimited text. However,
I'm working with the assumption that Word is what I've got to work with.

Unfortunately, all of our MARC records are in Word, and I can't get Word to
break out the columns correctly (it wants to create a lot of rows instead of
columns). I did find this older program, which makes me hopeful that this
process won't be as complicated as I anticipate: MARC RTP

But I'm wondering if anyone else here has had to deal with this problem and
what you did to solve it. Did you have a software package that helped you?

Thanks in advance everyone!

Perian Sully
Collection Database & Records Administrator
Judah L. Magnes Museum
2911 Russell St.
Berkeley, CA 94705
510-549-6950 x 335
Contributor, http://www.musematic.org 

You are currently subscribed to mcn-l, the listserv of the Museum Computer Network (http://www.mcn.edu)

To post to this list, send messages to: mcn-l at mcn.edu 

To unsubscribe or change mcn-l delivery options visit:

More information about the mcn-l mailing list