Converting XML into a JavaScript object takes up to tens or hundreds more lines of code compared to JSON, and it requires an XML parser. XML documents are also more difficult to read when compared to ...
That shouldn't be a problem, after all, Excel can handle JSON. So, you try to open the file in Excel using its data import tooling, which usually works very well indeed as a basic ETL system.