I used the NWDA's documentation back in 2011, which is no longer available at, and created the following, which I'll try sharing here, (Someone could try contacting NWDA and asking them to repost the file.)

Anne-Marie H. Viola
Metadata & Cataloguing Specialist,
Image Collections and Fieldwork Archives (ICFA)
Dumbarton Oaks Research Library and Collection
1703 32nd Street, NW Washington, DC 20007
Direct tel: 202.339.6980

On Thu, Jul 17, 2014 at 12:46 PM, Elizabeth Perkes <[log in to unmask]> wrote:
You can use Excel as the data source for Word's mail merge function. Put the XML wrappers in Word with placeholders for the fields defined in Excel, run the merge, delete section breaks, and paste into your EAD document.

Elizabeth Perkes
Electronic Records Archivist
Utah State Archives
346 South Rio Grande
Salt Lake City, UT 84101
[log in to unmask]

On Thu, Jul 17, 2014 at 10:38 AM, Michele R Combs <[log in to unmask]> wrote:
Hi guys --

I seem to recall someone, or perhaps several someones, mentioning on this list that they had macros or scripts or something to convert collection inventories in Excel to EAD.  Yes?

Michele Combs
Lead Archivist
Special Collections Research Center
Syracuse University Libraries
[log in to unmask]