google-sheetsgoogle-sheets-formulaimportrange

I cant import data from another big sheet

Im having trouble importing data from my another sheet. Its quite big, has over 500 rows and to 100 columns. (I dont know if thats important but it has about 50 sheets, I want to import from first biggest one)

Importhtml and importdata take too long to load and then say that source is too big.

But what I want is importrange and that says internal error all the time.

Do you have any advice how can I import my data? Maybe even how to change source so it can be imported from?

Sheet I want import to

enter image description here

Solution

  • The function to use is IMPORTRANGE

    =IMPORTRANGE("XXXXXXXXXX";"Prices!A1:AJ")

    (where XXXXXXXXX is the sheet ID)

    Pro tip

    But what I want is importrange and that says internal error all the time.

    A good practice is to first link the two sheets by using a very small range like:

    =IMPORTRANGE("XXXXXXXXXX";"Prices!A1:A3")

    enter image description here

    and then change the range to meet your needs

    =IMPORTRANGE("XXXXXXXXXX";"Prices!A1:AJ")