Setting up an Excel XML template for a weekly xml data pull?

[bborawski]

Hello,

I am working with an XML data extract that will be viewed by my clients in Excel on a weekly basis. Each week, a fresh XML file is sent to them for review.

Is there a way to define a schema in Excel so that when they open the file in Excel, it will automatically show certain data fields? I want to avoid having them define the schema. And the XML list shows far more data than is necessary.

Thanks!