Using Google Visualization API with PHP
April 4, 2008 8:20 AM   Subscribe

I heard the Google Visualization API Query Language allows you to query Google Spreadsheet documents using a language similar to SQL. Is there a PHP library I can get to use a Google Spreadsheet as a simple database table?
posted by remi to Computers & Internet (2 answers total) 1 user marked this as a favorite
If you're doing it piecemeal, you can publish your spreadsheets as CSV (or a host of other formats) -- example: spreadsheet - CSV.

Choose 'More publishing options' (small link at the bottom of the 'publish' tab) and select your formats. A CSV file can be loaded directly into a MySQL db using LOAD DATA INFILE if you have the FILE privilege -- otherwise, it's fairly easy to parse and insert a CSV.
posted by mrflip at 8:57 AM on April 4, 2008

Response by poster: You're right. I can just export the data into CSV. Actually, I even found out you can simply send the query statement via the URL.

One caveat I just discovered, queries are only used to read data, not write.
posted by remi at 9:00 AM on April 4, 2008

« Older Granooooooola! Granoooooola!   |   Using a monitor to advertise Newer »
This thread is closed to new comments.