This code is taken from DJ's Weblog, thanks a lot for this!
- You'll need the key of your spreadsheet, the url format should be like this:
https://docs.google.com/spreadsheet/ccc?key=**YOUR-KEY-HERE**=drive_web#gid=0
and also the sheet number (i.e., Sheet 1). - In your document file menu, you'll find File Menu > Tools > Script Editor (you will be redirected to Google's script editor.
- Create a new Script file, and paste the content of the
SheetAsJSON.js
to the editor stage, and save it.