Using Google Visualization API with PHP

April 4, 2008 8:20 AM

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)

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