Using Excel Spreadsheets to Communicate XML Analysis
Betty Harvey · Balisage series on markup technologies · 2018
What is the best approach for analyzing large XML datasets? Reading thousands (or possibly millions) of pages of raw XML to fully understand the markup constructs? This approach is just not feasible. CSS stylesheets are useful for displaying a few files of XML data but is not really efficient. I have found creating analysis information in Excel spreadsheets is a very useful tool for understanding the full XML data constructs. This approach is also understandable to stakeholders when trying to convey useful information about their datasets. This paper will describe an approach for creating document analysis Excel spreadsheets using XSLT and XML.