/docs/community?hl=en
/docs/community?hl=en
1/5/17
Original Poster
cuseguy51

importhtml and importxml sometimes loads, sometimes doesn't

I have sheets that use a bunch of these import functions, but sometimes fail to load some of them. Sometimes it works fine. When it fails, I get the following error:

"Loading data may take a while because of the large number of requests. Try to reduce the amount of IMPORTHTML, IMPORTDATA, IMPORTFEED or IMPORTXML functions across spreadsheets you've created."

The spreadsheet I'm trying to load only has about 10 importhtml/importxml functions. Usually I can just wait a few hours and try again and it'll work, but the work I'm doing is time sensitive.

Anyone know how I can fix this, or any alternatives to google sheets that allow me to easily import html or xml?
Community content may not be verified or up-to-date. Learn more.
All Replies (38)
Richard Rasch
2/3/17
Richard Rasch
I have read every post about this I can find, still no solution! It is extremely frustrating to wait over an hour for 4 or 5 cells to populate with data. Yet, if I copy these few cells into a new google sheet they fill immediately. Why won't this work in the original sheet?
Bokubokus
2/24/17
Bokubokus
I am having this problem aswell. Someone please help!
2/26/17
Original Poster
cuseguy51
This issue seems to have gotten even worse for me. Does anyone know what triggers it? Reducing the number of import functions doesn't seem to fix it. I even tried deleting other spreadsheets that had a lot of import functions... still doesn't work.

If anyone could shed some light on what's causing this problem, it'd be helpful. If it is just a bug that only Google can fix, then at least I can stop wasting my time trying to fix it.
Google user
2/27/17
Google user
Same issue - I've posted multiple times and never even get a response.  It's like Google is just ignoring it altogether
3/9/17
Original Poster
cuseguy51
After about a week without this issue I thought maybe it had been fixed, but today the problem is back. Anyone know if a permanent fix will happen anytime soon?
3/28/17
Original Poster
cuseguy51
This has gotten even worse... I now have another spreadsheet doing the same thing. It has a total of 10 importxml functions.

The good news is I found a way to import from the web in Excel:


It's not as simple as in Google sheets, but it's good enough. Hopefully Google can fix this issue at some point.
4/3/17
Original Poster
cuseguy51
Today I have a sheet that has a grand total of two IMPORTXML functions. They won't load. Is anyone at Google working on this?
4/6/17
Original Poster
cuseguy51
In one of my sheets that would be too much of a pain to convert to Excel, I've attempted to significantly reduce the number of of import functions. I have it down to 8, which still appears to be too many for Google to handle. When one loads, another fails. Then when the failing one loads, another that had been working fails.

Am I doing something wrong? Or is this still a Google issue that hasn't been fixed? Is there something else I can do to get it to work (other than convert the whole sheet to Excel... it uses several functions that aren't available in Excel, and it'd be annoying to have to change those functions to something that works in Excel).
4/13/17
Original Poster
cuseguy51
Once again, I had it working for a few days, and now it no longer works. Can someone from Google explain why it sometimes works and sometimes does not, and how we can know when there will be an outage of this feature to prepare for it and avoid lost time and profits?
4/18/17
Original Poster
cuseguy51
Good news... I've found a method that seems to make these work more consistently, so I thought I'd post my solution. The spreadsheet that I had all of these importxml/importhtml functions in is pretty intricate and has a lot of formulas. I moved all of the importxml/importhtml formulas to a new sheet, and use importrange to import the data from the new sheet into the more complicated sheet. I find that it works a lot better that way, and it also appears to update the web data more frequently and consistently.

Or maybe Google fixed this issue and it happened to coincide with me trying this. Who knows.

If you're still having this issue, you can give this a try and see if it works for you.
27 MORE
Cory Lee
6/7/18
Cory Lee
Happy it works as well for you as it does for me :)

Cory Kapty
Were these replies helpful?
How can we improve them?
 
This question is locked and replying has been disabled. Still have questions? Ask the Help Community.

Badges

Some community members might have badges that indicate their identity or level of participation in a community.

 
Google Employee — Google product team members and community managers
 
Community Specialist — Google partners who help ensure the quality of community content
 
Platinum Product Expert — Community members with advanced product knowledge who help other Google users and Product Experts
 
Gold Product Expert — Community members with in-depth product knowledge who help other Google users by answering questions
 
Silver Product Expert — Community members with intermediate product knowledge who help other Google users by answering questions
 
Product Expert Alumni — Former Product Experts who are no longer members of the program
Community content may not be verified or up-to-date. Learn more.

Levels

Member levels indicate a user's level of participation in a forum. The greater the participation, the higher the level. Everyone starts at level 1 and can rise to level 10. These activities can increase your level in a forum:

  • Post an answer.
  • Having your answer selected as the best answer.
  • Having your post rated as helpful.
  • Vote up a post.
  • Correctly mark a topic or post as abuse.

Having a post marked and removed as abuse will slow a user's advance in levels.

View profile in forum?

To view this member's profile, you need to leave the current Help page.

Report abuse in forum?

This comment originated in the Google Product Forum. To report abuse, you need to leave the current Help page.

Reply in forum?

This comment originated in the Google Product Forum. To reply, you need to leave the current Help page.