Here's my problem, I've got an html page from my own web site which contains a lot of tables. I'm using IMPORTHTML in Google Sheets to import some of them in different spreadsheets. There's 4 different tables used in each of the spreadsheets, I've been doing this for something like the first 100 tables with no problem whatsoever.

This morning, I started a new spreadsheet, importing 4 other tables from the same html page and every importhtml is stuck at loading. I tried closing the browser with no succes.

I tried doing importdata to see if my website server might blocking me for some reason and it doesn't seem to be the case since I can import the HTML page with importdata.

Anybody has an idea?

  • I am having the same problem. Perhaps it has something to do with this console error that is now showing up: This document requires 'TrustedScript' assignment. IMPORTDATA() is still working fine for me.
    – kregus
    Commented Mar 3, 2022 at 19:42
  • Same thing happening to most of my sheets. But, surprisingly in a few of them where i have scripts and thereby Authorizations already granted, importhtml is working. Did you find any solution?
    – Omkar
    Commented Mar 4, 2022 at 9:02

1 Answer 1


This is currently a known bug with ImportHTML and ImportXML, and the fix is expected to come in the next few days. Custom functions are also broken and that breakage appears to be related to this issue.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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