Search code examples
google-sheets

How can I importrange from mulitple URL

Basing on this tutorial

I have tried to importrange from multiple spreadsheet, but it won't work.
I'm trying to use:

={importrange(url,range1);importrange(url,range2)}

But I always get only the import from the URL I put int the first importrange function

If I import them separatly with:

=importrange("url","data_range")

It works!
What am I doing wrong?

Solution

  • It was just importing the 1000 blank row. SO the second sheet appear at line 1001

    here is the formula I found using query to clean my work :

    =QUERY({importrange(url,range1);importrange(url,range2)}, "Select * WHERE Col2 IS NOT NULL") know it's perfectly doing the job !