/docs/community?hl=en
/docs/community?hl=en
1/13/15
Original Poster
crambo

Sheets IMPORTDATA(url) Issue

Interesting issue:

Can you control how often the SHEET will check to "reimport" changes to the the remotely hosted CSV? I have updated the remote CSV and it doesn't seem to readily reload the actual data. For instance, I set a CSV to 400 rows. Upon first load, it will get the 400 rows. However, if I update the file to 500 rows, it doesn't seem to not the additional rows, even if I reload the whole sheet, or even attempt to just refresh the cell with the function in it.

THoughts? Am I expecting too much functionality? 

Cheers,
Cameron
Community content may not be verified or up-to-date. Learn more.
All Replies (1)
--Hyde
1/14/15
--Hyde
Hi Cameron,

In the good old days importdata() updated every five minutes or so. I do not know how it works nowadays. There is a workaround to force it to update that works with most web sites that host CSV data: add a dummy query string that changes every now and then.

For example, to force an update whenever cell L1 changes, try something like this:


Note that this approach will not work with web sites that use such query strings to function.

Back in the good old days, you could use structures such as the five-minute clock to force an update periodically. Because of changes to the handling of volatile functions such as now(), this most often causes the dependent import formula to just display "Loading". The easiest way to force an update is to edit the trigger cell (L1) manually every now and then, or make it the sum() of a numeric column that changes often, and does not depend on any volatiles.

If you need more help, please share a sample spreadsheet.

Cheers --Hyde

Was this reply helpful?
How can we improve it?
 
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.