We have a client who wants to send orders as xml files. We need an automated (easy) process to pull specific elements (order number, shipping method, etc.) from the xml and generate a csv file with those elements.

My original plan of attack was to open the file in Excel and build macros to manipulate the data. But Excel will not open the files unless they are in an xml spreadsheet format.

Next plan is to somehow convert the xml to a csv. Then open that in Excel and run custom macros to get what we need.

But I can't find a solution. Anyone have any ideas?