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">
  url: " ",
  desktop_container: ".desktop_table",
  responsive_container: null

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

<div class="responsive_table"></div>
  url: " ",
  desktop_container: null,
  responsive_container: ".responsive_table"     

4. Apply additional CSS classes to the table.

  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.

Related Posts


Confetti Falling Animation Effect In JavaScript | party.js

Party.js is a JavaScript library to brighten user site experience with visual effects! Celebrate success with dom confetti! The library is written in TypeScript and compiled into…


Simple jQuery Cookie Consent Plugin

jquery.cookie-consent is a simple jQuery plugin to request consent to use cookies. An easy-to-use and highly customizable cookie consent bar that informs your visitors of the use…


Timepicker JavaScript Plugin for jQuery Inspired by Google Calendar

jquery.timepicker is a lightweight jQuery timer plugin inspired by Google Calendar. It supports both mouse and keyboard navigation and weighs 5.5KB minified and compact. Features: Highly customizable…


A Lightweight, Touchable, and Responsive Angular Universal Carousel Library

ngxCarousel is a lightweight, tactile, and responsive library for creating an angular carousel. No dependencies, no more hammer. Must Read: Angular Responsive Image Slider With Lightbox Popup…


First Mobile Full-screen Modal Popup Library For Vue

Vue full-page modal is a responsive, mobile-compatible, screen-friendly pop-up library for Vue.js. Must Read: Modal Component Is Written in Vanilla JS | ensemble Modal How to make…


Generate a Random Number Picker In Vanilla JavaScript

Random Number Picker is a Vanilla JS-based number picker that allows you to generate a random number within a specified range. Must Read: Generating Lottery Numbers Using…