Can Spreadsheet Do Calculations of a Link? How to Extract and Compute Data from URLs? Alternatively:

Kinda surprised no one mentioned this yet—but you can use =QUERY(IMPORTDATA(A1)) in Sheets if the URL spits out CSV/TSV.

For your example, tho, regex is the way.

Can spreadsheet do calculations of a link? Yeah, but it’s not always straightforward.

If you’re on Excel, Power Query’s "From Web" option might help.

Otherwise, Python + pandas is overkill but bulletproof lol.