Press "Enter" to skip to content

A Tool for Publishing Responsive HTML Tables of a Google Spreadsheet as a CMS

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


See Demo And Download

Official Website(davidayalas): Click Here

This superior jQuery/javascript plugin is developed by davidayalas. For extra advanced usage, please go to the official website.

Be First to Comment

    Leave a Reply

    Your email address will not be published.