K
K
Konstantin Davydov2020-08-12 02:24:13
Google Sheets
Konstantin Davydov, 2020-08-12 02:24:13

How to tame the IMPORTDATA function?

When using the =IMPORTDATA (URL...) function, an array of data is displayed in one column, everything is fine, but after some time when working with a table, the import result itself changes into something empty with the title in the first line "!Doctype html" . The function itself has not undergone any changes.
If you correct the address in the URL of the function, for example, by removing www or s (from httpS), then the result again becomes as it should. But after a certain amount of time, everything repeats. What is the issue and how can I prevent this from happening?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
N
Noir, 2020-08-18
@PolarBearGG

Script for updating imports
https://gist.github.com/PolarBearGG/746c6b8b95b34d...

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question