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.