Search code examples
databasegoogle-sheets

How to auto repeat ImportHTML with multiple URLS in Google Sheets

I am working on using ImportHTML in a google sheet right now, and am using it to import data that is always 6 columns wide, but is dynamic in length: Data

The formula I am using is: =IMPORTHTML(A1,"table",1,"en_US")

In Column A, i want to be able to add as many URLS as I want, and for it to add all of the data to a large table 6 wide by however long. I know how to add arrays using =Vstack, but i dont know how to use a dynamic list of URLS instead of just one. URLS Text: https://ftc-events.firstinspires.org/2023/USIAMCM1/qualifications

Added bonus if its possible to remove the text Column Labels that is imported with each data set. text: Match # Red Blue Score

Solution

  • You may try:

    =reduce(tocol(,1),tocol(A:A,1),lambda(a,c,vstack(a,let(Σ,importhtml(c,"table",),filter(Σ,index(Σ,,1)<>"Match #")))))

    enter image description here