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

Honestly? Can spreadsheet do calculations of a link? Technically yes, but it’s a pain.

Sheets’ regex functions are your best bet.

Or—hear me out—use a free API tool like Postman to extract the data first, then import it.

Way less headache than fighting with IMPORTXML errors.

Excel’s FILTERXML is another option, but good luck debugging it.