Reading JSON and XML files in LibreOffice Calc
LibreOffice Calc automatically maps generic XML and JSON documents with linkable ranges to individual sheets. If a document contains multiple linkable ranges, each range is assigned to a separate sheet.
A linkable range is a section of a document containing tabular records.
Opening a JSON or XML file with linkable range
-
Choose .
-
Locate the JSON or XML file that you want to open.
-
Click .
The structure of the original data in the source document is not restricted, as it is automatically analyzed and mapped to the sheet. However, this process is performed on a best-effort basis and may not work in all cases.
