Because I often find myself saving tabular data to a csv file, and then converting that csv file to JSON, I'm proposing the enhancement of enabling Libre Calc to directly save tabular data to JSON.
I don't think it will be hard to find open source code that already does this. Mainly, the effort would be a matter of incorporating that code into the Libre Calc project. For example, I'm currently using this to do it: https://www.npmjs.com/package/csvtojson
Is there a single way to represent spreadsheets in JSON?
How about an extension? Was looking for a solution and found very quickly http://www.csvjson.com/csv2json. The request needs to define precisely constraints and needed options. But I guess it's a good enhancement either per extension or inbuilt -> NEW.
There are multiple ways to represent a spreadsheet using JSON, but the most expected way would probably be an array of objects where each row is an object and each column-name becomes a property of each of those objects. Yeah, that's verbose, but it is probably what most people would expect from a "Save as JSON" option. For this request, I was not thinking about super complicated spreadsheets. I was mainly thinking about simple tables that you can currently save to a csv. Any spreadsheet that can be saved as csv can certainly also be converted to JSON almost as easily. One nice thing about JSON is that it already handles edge cases that might corrupt a CSV file (a cell with its on internal commas for example is problematic with CSV). Does Excel offer this feature? If so, I say just do it a little better than how they do it.