I have a Google spreadsheet with data that will be updated on a weekly basis. I need to bring this data into a HTML table on my website.
Rather than running it through a CSV to HTML converter each time and having to update the HTML code each time, is there a way for me to use PHP or Javascript to look up the Google Spreadsheet URL and convert the data to HTML Table tags without me needing to alter the code each time?
I have a Google spreadsheet with data that will be updated on a weekly basis. I need to bring this data into a HTML table on my website.
Rather than running it through a CSV to HTML converter each time and having to update the HTML code each time, is there a way for me to use PHP or Javascript to look up the Google Spreadsheet URL and convert the data to HTML Table tags without me needing to alter the code each time?
Share Improve this question asked Aug 2, 2012 at 10:18 wadeywadey 933 silver badges10 bronze badges2 Answers
Reset to default 3You may be interested in GD API (description concerning spreadsheets).
Default download format is html. Write a script and run in using CRON once a day to pull newest version of you document.
Open your spreadsheet, go to File > Download as > Web page (.html, current sheet)
That should open a link in a new window. This should automatically update when you reload the page after the data has been edited. In jQuery, you can use the .load function to load the data into your page.