I am really new to the excel inner workings, such as macros and building xml and schemas, i have an xml that i would like to use as a template to build a spreadsheet around so the output looks like the xml file. i took the xml to an xsd generator and it spit out the (generic) file attached. the (mock) file is something along the range of what i would like to work off of. Also is there anyway that each row can be created as its own xml file? Because as you can see the xml file matches the firts row of the mock spreadsheet. any and all help would be appreciated.