New answers tagged import
I had the same concerns a few moments ago and found your question but no answer given satisfies my needs. Nevertheless I found something that seems to work for what I believe you are really asking (saving a file from it's URL with the less possible clics, and specially avoiding to save it on your device). The following 3 procedures allow you tu upload ...
The QUERY function will do what I want. I had no idea that I could use database like functions in Sheets. =QUERY(IMPORTRANGE("insert_url","Range"),"Select Col1, Col2 Where Col4='Value'")
Top 50 recent answers are included