Access Google Spreadsheet as JSON : Method 1


Google Sheets is a a free, web-based software office suite offered by Google within its Google Drive service.
One useful feature of Google Spreadsheets is the ability to access the data as JSON by using a particular URL.

To access a spread as JSON First, you must create and publish/share your spreadsheet to the web.

Look at the Youtube tutorial for better understanding.

id (required): The ID of your document. This is the big long aplha-numeric code in the middle of your document URL.

Macro URL:

NOTE: Replace the SHEETID & SHEETNAME  to your sheet details


Hi! I am Sartaj Husain. I am a Professional Software Developer, live in Delhi. I write blogs in my free time. I love to learn and share the knowledge with others because it is no good to try to stop knowledge from going forward. So free posts and tutorials. more..

No comments