Source: thenewstack.io
How to Convert a Google Spreadsheet to JSON-Formatted Text
https://thenewstack.io/an-introduction-to-json/ stands for JavaScript Object Notation and is an incredibly important open standard file/data interchange format that is lightweight and easy to understand. The JSON syntax rules are quite simple: Data is key-value pairs.
If you now go back to the spreadsheet and reload it, you should see a new menu entry, labeled Export JSON (Figure .
Click Export JSON and then select Export JSON for this sheet.
Even better, you can close the spreadsheet, come back to it later, add more data, and export it as JSON (the Apps Script remains associated with the spreadsheet).
If you now go back to the spreadsheet and reload it, you should see a new menu entry, labeled Export JSON (Figure .
Click Export JSON and then select Export JSON for this sheet.
Even better, you can close the spreadsheet, come back to it later, add more data, and export it as JSON (the Apps Script remains associated with the spreadsheet).
Related Articles
Community Partners
DevOps Careers