Clear all

XML Formatter / parser

New Member
Joined: 5 years ago
Posts: 1
Topic starter  

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:

<?xml version="1.0"?>
<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?

Topic Tags