Publishing Responsive HTML Tables of a Google Spreadsheet

gshtmltable.js is a javascript library for creating an HTML table from a generic Google Spreadsheet – a Google Spreadsheet to an HTML timeline.

It allows non-technical users to edit a schedule in a Google Spreadsheet and then publish it on a web page.
It has two copies:
Desktop (same as spreadsheet view)
Responsive (Split column headers-Mon,…, Sunday- as new rows)

convert google sheet to html table, create bigquery table from google sheet, editable spreadsheet html, google sheets data connector, connected sheets google workspace

[CRUD] Data Grid Component With A Spreadsheet In JavaScript/HTML5 | Handsontable

How to make use of it:

1. To get started, include the gshtmltable.js library on the page.

<script src="./lib/gshtmltable.js"></script>

2. Draw the HTML table (desktop version) of the generic Google Spreadsheet you provide.

<div class="desktop_table">

drawTables({
  url: " ",
  desktop_container: ".desktop_table",
  responsive_container: null
});

3. Draw a mobile-friendly table from your generic Google Spreadsheet.

<div class="responsive_table"></div>

drawTables({
  url: " ",
  desktop_container: null,
  responsive_container: ".responsive_table"     
});

4. Apply additional CSS classes to the table.

drawTables({
  desktop_css : "",
  responsive_css : "" 
});

Generate Tables From Public Google Spreadsheets, Google Spreadsheet to HTML Timetable Plugin/Github, data connectors google sheets not showing, connected sheets pricing