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("http://spreadsheets.google.com/feeds/list/YOUR-SPREADSHEET-ID/1/public/values?alt=json");
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".
Posted by at

8 comments:

  1. DominicMyersDecember 29, 2013 at 9:10 AM

    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,
    Cheers,
    Dom

    ReplyDelete
  2. MartinahammerApril 6, 2017 at 4:24 AM

    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: https://chrome.google.com/webstore/detail/trigger-send/lmpdaoninbfpblmajgcodhookngnekek

    ReplyDelete
  3. UnknownJuly 27, 2017 at 10:20 PM

    Thanks for sharing such wonderful information about Jobs in PHP.I read your articles very excellent and the i agree our all points because all is very good information provided this through in the post.Anybody want to build your website.

    White Label Website Builder

    ReplyDelete
  4. AnonymousMay 23, 2020 at 11:31 PM

    Thanks for sharing useful information.
    keep updating.

    Big Data Hadoop Training In Chennai | Big Data Hadoop Training In anna nagar | Big Data Hadoop Training In omr | Big Data Hadoop Training In porur | Big Data Hadoop Training In tambaram | Big Data Hadoop Training In velachery

    ReplyDelete
  5. AnonymousApril 28, 2022 at 11:13 PM

    mmorpg oyunlar
    instagram takipçi satın al
    tiktok jeton hilesi
    tiktok jeton hilesi
    sac ekimi antalya
    instagram takipçi satın al
    INSTAGRAM TAKİPCİ SATİN AL
    Metin2 pvp serverlar
    instagram takipçi satın al

    ReplyDelete
  6. AnonymousMay 17, 2022 at 2:46 PM

    Perde Modelleri
    sms onay
    mobil ödeme bozdurma
    nft nasıl alınır
    ankara evden eve nakliyat
    trafik sigortasi
    dedektor
    Websitesi kurmak
    Aşk kitapları

    ReplyDelete
  7. BharathiDecember 12, 2023 at 3:38 AM

    Hii
    Thank you for sharing this information. As I build my new website, I'm certain that the articles I'm writing will be instrumental in enhancing my Google search ranking.Here is sharing some ELK Stack Training journey information may be its helpful to you.

    ELK Stack Training

    ReplyDelete
  8. udayDecember 22, 2024 at 7:55 PM

    Nice Article!

    Thanks for sharing with us 🙂

    Generate AI Training in Hyderabad

    ReplyDelete

Please email files to bla@bla.com

Subscribe to: Post Comments (Atom)