Michele, et al.


Neither of these solutions should be too technically difficult for any user once some documentation is created, and as long as a computer is around.  Good instructions don’t exist for the approach that I’m using right now, but here’s what it boils down to:


1.       Record data in Excel

2.       “Save as” an XML Spreadsheet 2003 (*.xml) document

3.       Double-click a command file that converts the Excel XML into EAD


The first step requires that you have Excel (but it could be done with Open Office, as well); the last steps requires that you have Java and a free XSLT processor installed on your computer (the latter is a file around 10 MB).  No editing of the XSLT file should be required (in fact, even if you wanted to go 13 levels or deeper, you’d only have to edit the Excel file to allow numbers higher than 12 to be entered into that column).  One other thing that I’d like to create, since I’ve already had a need for it (when we need to edit EAD files that haven’t yet been ingested into a tool like Archivists’ Toolkit), is to reverse this process and to transform any EAD document into this Excel format.


Similarly, it sounds like the tool that Greg is working on could be distilled into just a few steps.   Also, since he’s using a tool like BaseX, his solution could eventually be run through the browser, where you upload an Excel document and then get an EAD document in return (just like how the STEADY process works now).


Thanks for the reminder about SAA’s EAD page!  I’ll try to find out who has the ability to update this page.  I imagine that a lot more tool development might occur shortly after the release of EAD3,






From: Encoded Archival Description List [mailto:[log in to unmask]] On Behalf Of Michele R Combs
Sent: Thursday, July 17, 2014 3:10 PM
To: [log in to unmask]
Subject: Re: Excel-to-EAD scripts, macros, whatever


Thanks Greg and Mark.  Those last two solutions I think are a bit too technical for my requester, but very interesting nevertheless.


For everyone who proposed solutions, might I suggest you post them to the Related Resources section of SAA’s EAD page?  There doesn’t seem to be a single Excel-to-EAD tools up there.  Odd when you consider how common Excel is as an inventory method.


I think Mark Matienzo still maintains that list so you might contact him about it.