Browsing my log in Excel for the first time was a revelation of its potential. We have the tools – all we need is the imagination.
I’m sure there are more idiomatic or even efficient ways of doing it, but here is how I converted JSON data to CSV output.
JSON is a popular standard for data obtained from internet sources. How well is it supported by spreadsheets? And two major upgrades: Tinderbox 7 and Dash 4.
How to import complete log extracts into Excel or Numbers, using R as a conversion platform. It’s a bit convoluted, but it works.
Storyspace and Tinderbox can import a range of other formats, including CSV. This explains how to use that format.