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.

Related Posts

Confetti-Falling-Animation-Effect-party

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…

jquery-cookie-consent

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-Plugin-for-jQuery

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…

angular-ngx-carousel-slider

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…

vue-fullpage-modal

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…

random-number-picker

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…