I downloaded some data but it’s in .json format (a hypertext-based database).
Is there a way to load this into LibreOffice so it is properly formatted into a table I can view? (I don’t need to edit it. Just see it formatted.)
Yes, python has a json module to read|write that format.
For detailed help we need some example.json and how it should displayed in Calc
Thx. I obtained the data here checking Twitter followers for “bots”.
The output is a json hypertext file which would be much easier to read if input into a table.
I dont like to make twitter- and botometer-accounts to be able to solve YOUR problem.
but with the raw .json, and a description how it should displayed, propably …
1 Like
If you can’t help (or unwilling to), don’t reply.
I didnt say, “I cannot help…”
So you assume we will try to repeat your work, get an json, create an solution and wait if this solution also fits your use-case. And maybe we will get a json wich is not identical to yours…
I will not even start to get an account there…
On a general level: Not every json can be converted to a table. So you need a special solution for your data.
Thx, but that’s the first thing I did. Most of the responses don’t actually provide answers.
The top response is something cryptic about “SheetCellCursor” with no explanation on how to use it.
The next two responses say to use Python instead (Not helpful.)
The rest (that seem to apply) received no response.
Thus, my post.
As I said: Imho, there is no general solution to convert any json to a table. I (and also Karolus) know how to write a
converter for some json-Files, but as you don’t need to give the precise details to your problem I wish you good luck solving this. I have some whining to do…