No issue, just requesting assistance

[levisanderson]

Hello, I am trying to pull the data contained in the table on this webpage into my google spreadsheet but can't quite figure out the formula.

https://practiscore.com/results/html/97ee41fe-ccbc-44f5-81e2-c3733644195c?page=overall-combined

Eventually I'm looking to create a dynamic formula, where I can enter a similar URL into a cell and have the table data populate into google sheets.

Any help is greatly appreciated!
Thanks in advance.

[hello-party]

this script is for JSON. For you, I think you can simply change the URL to get a clean HTML table, changing overall-combined to match the table you want to import.

=IMPORTHTML(
   "https://s3.amazonaws.com/ps-scores/production/97ee41fe-ccbc-44f5-81e2-c3733644195c/html/overall-combined",
   "table",1)