XML Formatter / parser
I am looking for a tool to open an XML file and convert it to a database or spreadsheet. The XML file is well formed and follows this basic idea:
<database name='Data' date='2/2/2021 9:08:39 PM'>
<Field3>6/12/2012 12:00:00 AM</Field3>
... repeat for all "Table1"
... repeat for all "Table2"
... many more tables
This file is generated from an online service I use and is a "Database Backup" of my data. Right now this XML file has almost 5 million lines of text. I can view it and such easily in BBEdit but I am hoping something to convert it to a SQLlite database or a spreadsheet where each sheet is a different table.
Anyone have any thoughts?