Hello Marsha

The question I would have is why you can't just encode you data in a structured way to begin with (i.e. XML)?  I can't imagine that would be any less complex than trying to establish complex relationships and having to create delimiters for multiple values in a single cell (and verify that they are all correct).  I realize that Excel is more "user-friendly" to those that don't understand cataloging, series/subseries or hierarchies, but my experience is that those type of people are not going to be able to create anything other than a simple flat container list anyways.


On 11/29/2013 4:15 PM, Marsha Maguire wrote:
[log in to unmask]" type="cite">
Greetings, all. If I may, I wanted to revisit a thread from a couple of weeks ago (I was out of town when it first came up).

Kate Bowers said, "Starting with a spreadsheet, you can generate both MARC records and EAD components from the same source data."

But how, exactly (I ask as a non-programmer), is this done? Spreadsheet structure being flat and seemingly one-to-one (unless a lot of data is repeated in succeeding rows), I'm wondering how to indicate in the spreadsheet that a given title (say, of a book or a sound recording) described in a spreadsheet row has more than one creator or subject. In other words, how should a spreadsheet be set up to handle one-to-many relationships, so that its data can be exported and converted to EAD XML or MARC XML? May I ask anyone who is kind enough to consider answering this to please be specific or provide specific examples?

Apologies if this is obvious to many of you. Thanks so much.

Marsha Maguire
[log in to unmask]