I wanted to enable people who work in government to generate JSON-LD representations of their services in the easiest way possible. What is the number one way for people in government to manage data? Spreadsheets.

I decided to start with Google Docs, and generate a simple JavaScript tool to take a Google Spreadsheet template that was setup with the required fields for a government services schema.

Next I wrote an import script using Tabletop.js that would grab the contents of the Google Spreadsheet template and using JavaScript to generate the JSON-LD.

You can find this Google Spreadsheet to Government Services JSON-LD tool as a dedicated section on this project site. Everything is written in javaScript and runs here on Github, so you can fork and employ as your own repository, or you can just generate here and copy, paste and publish where you need.

Read Full Story