Display Google Sheets Data on Interactive HTML Tables (Quick & Easy Setup)

This video demonstrates how to effortlessly transform your Google Sheets data into dynamic, interactive HTML tables. Using the power of Google Apps Script and the Tabulator library, this process is surprisingly straightforward.

Tabulator provides a wide array of features for filtering, sorting, and more, giving you the ability to create an interactive HTML interface for your Google Sheets data. You can effortlessly enable or disable most of these features without much coding knowledge. If you are searching for an easy setup to display your Google Sheets data on interactive HTML tables, then this is an excellent solution for you.

[DLHK]

wow, the video is very good, short and easy to understand, special thanks to you

[THDYoung]

Thank you.
Question!
If you paste the url of a web app like the one in this video into a Google Site (using 'embed'), then update the data in the spreadsheet associated with the web app, will the Google Site view update automatically or only with a manual page reload?

[ImamFauzi-vjxp]

Thanks for the tutorial, really helpful!

[ArshadRaza-ch]

Hi there, very nice video. please add print option in it so that it can be more usefull for people like us who are not good with coding. thanks

[zaccoza]

I am grateful for sharing your work. I adapted the project according to my own request. Column 3 entries in the data field have url links. What should I do to make the data come with url links in the web table?

[jadoublez]

Hello. This is amazing and thank you. I have several columns of numbers. When I click on column F, the column sorts high to low or low to high. Perfect. When I click column G (replicated from column F exactly in the Javascript), the column seems to sort randomly. My guess is it's feeding off something but i'm not sure why it wouldn't sort the same as Column F. Any reason spring to mind?

[markdaniel-iq]

Can we customize the sheet as per our requirements?

[SOUVIKKUMAR-vjwm]

Sir, if i create hyperlink or want to show any weblink from Google, it is not showing or acting like fix value, how to do.
Please help

[etayojuanc]

Friend, do you have any crud data table type applications where the apps script is outside the spreadsheet?

[SkhemTechNongshli]

Kindly make application that a user login and entry information, and also display only his input or information.

[jorgetesecum]

Mine does not display all the info for example i changed the headers to this: Part Description, Quantity, Location, Condition, Serial Number, Compatibility, Information, Comments, Date/Time ... and only quantity, information and date/time have their data populated in the app, what am i doing wrong ?
columns:[
{title:"Part Description", field:"Part Description"},
{title:"Quantity", field:"Quantity"},
{title:"Location", field:"Location"},
{title:"Condition", field:"Condition"},
{title:"Serial Number", field:"Serial Number"},
{title:"Compatibility", field:"Compatibility"},
{title:"Information", field:"Information"},
{title:"Comments", field:"Comments"},
{title:"Date/Time", field:"Date/Time"},
],

[SOUVIKKUMAR-vjwm]

Sir if i want to show any hyperlink or weblink which is in Google sheet, what changes have to do?
Because hyperlink or weblink is not working in html table, it shows fix value.

Please help

[christopherangeles]

Why the body of HTML didn't show up?

[SOUVIKKUMAR-vjwm]

Sir if i want to show any hyperlink or weblink which is in Google sheet, what changes have to do?
Because hyperlink or weblink is not working in html table, it shows fix value.

Please help