On 2 October, public health authorities discovered figures had lost nearly 16,000 recent cases. Was this an error in file formats, using an old version of Excel, or what?
Looks at plain text, CSV, XML, JSON, RTF, RTFD, .docx, .xlsx, and PDF. Which should you trust with your important documents in archives?
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.