How to pull data from Google Sheets to HTML table using Google Appscript

FREE020 puts your whole sheet on a web page as a table that behaves like one — sortable by any column, searchable as you type, and paginated so a large dataset does not arrive all at once. The point of this file is not the features; it is that they hold up at size.

Proven on a big sheet

The walkthrough generates roughly twenty thousand rows — two hundred and seventy plus pages of them — and then searches. The results come back the instant a few characters are typed, whether it is a name, a phone number or a city. If you have a sheet that has grown past the point where a plain table is useful, that is the demonstration worth watching.

Sorting and paging

Click a column heading and the table sorts by it; click again to reverse. Dates to the top, a status column grouped, a city column alphabetised — whatever makes the list readable for the task in front of you. The rows-per-page selector offers twenty five, fifty or one hundred, with pagination handling the rest.

What people actually use it for

A front desk looking up a student's details, a roll number, a phone number or an address without opening the spreadsheet. The staff member gets a search box, not edit access to your data, which is usually the right arrangement.

Setting it up

Copy the sheet, paste your spreadsheet ID into the code and deploy. The fast filtering comes from a table plugin included in the project, so there is nothing else to install.