How-To Geek: How to Convert a JSON File to Microsoft Excel. “Have you received a JSON file that you’d like to convert to Microsoft Excel format? Excel offers a built-in option to help you import it without third-party parsing tools. Here’s how you can do it.”
How-To Geek: How to Scrape a List of Topics from a Subreddit Using Bash. “Reddit offers JSON feeds for each subreddit. Here’s how to create a Bash script that downloads and parses a list of posts from any subreddit you like. This is just one thing you can do with Reddit’s JSON feeds.”
From a gentleman named Simon Willison, and this looks delicious: Datasette Publish: a web app for publishing CSV files as an online database. “I’ve just released Datasette Publish, a web tool for turning one or more CSV files into an online database with a JSON API. Here’s a demo application I built using Datasette Publish, showing Californian campaign finance data using CSV files released by the California Civic Data Coalition. And here’s an animated screencast showing exactly how I built it…” Are there are enough hours in the day? Find out in our next episode, THERE ARE NOT ENOUGH HOURS IN THE DAY.
Archives.gov has a new read/write API. “The dataset for our catalog API contains all archival descriptions, authority records, digitized records (the images, videos, and so on) and their file metadata, all NARA web pages, and public contributions (tags, transcriptions, and comments). The API will allow developers to retrieve all of this metadata in specified formats (JSON or XML) for any given record or search results set.” A read API is pretty great, but wow, a read-write API?