The Spreadsheet Export builder requires that exported content be structured as an HTML table.
The format lets the builder accurately transform rows and columns in the table into corresponding rows and columns in the exported spreadsheet.
If the XML data to be exported is obtained from a page location, then it is likely that some table-oriented builder such as Data Page was used to create the page content. In these situations, the XML content is already in the HTML table format and can be exported as-is.
When using an indirect reference as the source of XML data you can either ensure the XML is already formatted as an HTML table or you can use an advanced feature of this builder to recognize table-like structures in the XML and handle them appropriately.
Parent topic: Spreadsheet Export builder