Thursday, July 7, 2011

The easiest way to parse Google Spreadsheets with PHP

After tinkering with the available publishing options for Google Docs Spreadsheets, I landed on the following.

$jsonData = file_get_contents("");
var_dump(json_decode($jsonData, true));

This makes the assumption that your spreadsheet content is not private and is OK to "publish as a web page".


  1. Hi there,
    I've been playing around with much the same thing as your Google Sheet powered blog. Are you still working on it at all? If so then please do let me know as I'd be interedted in the progress you've made. You're welcome to have a look at my efforts this far on GitHub:
    Hope to hear from you,

  2. Google forms and google sheet are really helpful for data collection I come to know about one google sheet addons call trigger and send it help us in to collect data from forms and store in the google sheets automatically called Trigger and send. I found it here at:


Please email files to