The next version of #LibreOffice Calc (26.2) can directly open generic XML and JSON files and have them mapped to range of cells in Calc. I hope this will be useful to data science users. https://wiki.documentfoundation.org/ReleaseNotes/26.2#Generic_XML_and_JSON_mapping_to_Calc