Google Site: list template + local spreadsheet/database

Question

I am building a couple of "list" (based on the page template) pages on a google site. This is all great. The thing though is that I want to have a local copy (spreadsheet) as a backup or for offline use.

My first question is: can I somehow download the list as a spreadsheet?

Moreover, it would be much better if I could use the nice functionality of the list template (i.e; one simple form to enter all data for an entry; I already use this in my list template, including drop down lists, as well as the ability to sort by columns!) and at the same time be able to download a cope of the list or have it in my Drive.

Is that possible? and how?

thanks

Answer 1

Yes you can...sort off. It is possible to do some basic web scraping in Google Sheets with the functions:

IMPORTHTML

IMPORTXML

Between the two, IMPORTXML works well to get specific data while IMPORTHTML is perfect for grabbing tables Using Google Sheets as a basic web scraper.

From there you can download the Google Sheets with the list and keep a copy in your Google Drive normally an even export it as a PDF or excel file.