View config data in spreadsheet

The v2 of publication and project data is flat json, i.e. no nesting. The reason for this was to make it easier to view data in a spreadsheet. It's hard to visualize a large json file raw, and it's easy to overlook things like a missed field.

Ideally we'd have a native interface for viewing and editing, but lacking that, it's now pretty simple to view these flat json files. Here's a couple of ways.

Start with the raw json:

https://raw.githubusercontent.com/suttacentral/bilara-data/published/_publication-v2.json

convert to csv

Throw the raw json data in here:

https://konklone.io/json/

Export as tsv and view locally in a spreadsheet.

import to Google sheets.

See instructions here:

https://apipheny.io/import-json-google-sheets/

This uses this script:

https://gist.github.com/paulgambill/cacd19da95a1421d3164

Supply the raw json URL and it imports to Google sheets.

Unfortunately it doesn't update, so to do that, click on the first cell where the formula is, cut it, click outside so the data disappears, then paste and run again.

Here's a dummy file I made for testing:

https://docs.google.com/spreadsheets/d/1SfS83_qBmrkRKMg3I-J5FmlYlPFwKOfHibCm5ARW118