This will create the associations and Excel will automatically create the required list objects. Choose "XML" then "Export" from the "Data" menu to create your exported XML data file.

Learn how to open an XML File in Excel, Word, Chrome, and Edge on a Windows computer using the methods mentioned in this post.

Google Sheets Import XML You may have seen someone turn an XML document into spreadsheet format, thereby making it easier to work with the data.

Learn how to use Excel Power Query's extract and split column features to extract delimited strings into their components.