0

I'm putting together a spreadsheet of sports statistics that I intend to display certain calculations from on my website once both my site and the spreadsheet are complete.

I currently have 30+ pages in my Google Sheets, each with 3-4 importHTML statements. It takes quite a long time for the entire spreadsheet with all of its pages to finish loading up as it is, and I'm hoping to improve the loading time and, therefore, its efficiency.

Each page is loading from a specific URL. The URL used on each page is unique from the other pages' URLs. The reason there are 3-4 importHTML statements on each page is that I'm loading specific tables, rather than ALL the data from the URL I'm pulling from.

How can I improve efficiency? Is there a better way to do this than 120 individual importHTML statements spread across 30 pages, or am I just going to have to deal with it being very slow if I want to do what I'm doing?

And, as a follow-up question, I also need these importHTML statements to automatically update at certain time intervals. How can I make this happen without having to manually go into each sheet and retype (or copy/paste) the formulas?

  • How often do you need the data to update? 120 importHTMLs is a tall order. It could be easier to accomplish this using scripts instead of importHTML. – Vidar S. Ramdal Sep 26 '17 at 6:57
  • @VidarS.Ramdal Ideally it should update 2-3 times per week on a specific schedule (IE every Monday, Wednesday, and Saturday at 2pm). I'm not quite familiar enough with scripting in this environment to know how to use that instead of the importHTML. Could you point me in the right direction? – LCD Oct 2 '17 at 0:35
1
  1. How to improve efficiency

    If it's possible, instead of having one large spreadsheet make several small spreadsheets in order to reduce the recalculation time.

    Related Q&A

  2. Automatically update at certain time intervals automatically

    Use Google Apps Script.

    Related Q&A

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.