How to Convert a Google Spreadsheet to JSON-Formatted Text

3 years ago thenewstack.io

Summary: This is a summary of an article originally published by The New Stack. Read the full original article here →

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).

DevOps Articles