JSON to tabular format via JSONformatter.org and JSON2table.com
Posted by jpluimers on 2020/11/10
Two interesting sites to ease transforming JSON fragments in log-messages to a table system, for instance Excel.
- Paste the bits in [WayBack] Best JSON Pretty Print Online then fix any syntax errors.
- Copy from there to [WayBack] json2table.com and press the triangle button (run)
- Copy either the tabular or tree result to your favourite program.
- Format any numbers for readability. I really like the
Customformat##0.00E+00that just shows the exponents in multiples of 3 (so kilo, mega, giga, etc)[WayBack] formatting – How can I format bytes a cell in Excel as KB, MB, GB etc? – Stack Overflow
This way I copied the example code into adjecent Excel areas, so I could compare the values and calculate memory increase of a Delphi application.
—jeroen
https://gist.github.com/jpluimers/e7284e852bfe3e2c2cc4b24781336616






Leave a Comment