![]() Here is an example spreadsheet, which includes several sheets of different structures, and a script to convert the spreadsheet to JSON. Now it’s general purpose, JSON oriented, written in JavaScript, integrated with Google Sheets and also Unit圓D, and I’m releasing a simple library that works in browsers, Google Sheets and node.js, as free software. This is a fresh new reimplementation of some old ideas I’ve been happily using for years with CSV files and Python for many years, plus some new ideas focused on JSON, JavaScript and Google Sheets. Then other apps and services can easily retrieve those live spreadsheets as TSV files, which are super-easy to parse into 2D arrays of strings to convert to JSON. It’s especially powerful with Google Sheets, since it can run JavaScript code to export, import and validate JSON, provide colorized syntax highlighting, error feedback, interactive wizard dialogs, and integrations with other services. So I’ve come up with a simple format and convenient conventions for representing and editing JSON in spreadsheets, without any sigils, tabs, quoting, escaping or trailing comma problems, but with comments, rich formatting, formulas, and leveraging the full power of the spreadsheet. My goal is to be able to easily edit JSON data in any spreadsheet, conveniently copy and paste grids of JSON around as TSV files (the format that Google Sheets puts on your clipboard), and efficiently export and import those spreadsheets as JSON. How can you conveniently and compactly represent, view and edit JSON in spreadsheets, using the grid instead of so much punctuation? Here is the question I’m trying to answer: So I’ll briefly describe how it works (and share the code and examples), in the hopes of receiving some feedback and criticism. I‘ve been successfully synergizing JSON with spreadsheets, and have developed a general purpose approach and sample implementation that I’d like to share. I’ve been developing a convenient way of representing and editing JSON in spreadsheets, that I’m very happy with, and would love to share!
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |