I am trying to import data from one Google Sheet to another sheet using import range function, my data is not that large to break it only has four column and rows is 2000 than also when am importing that amount of data then also that function is showing import range internal error.
I even try the given method in below link but that also not working using iferror function than also it is showing import range internal error.
Is there any solutions for this or any other way to import the data from one sheet to another?
I have also used coupler.io extension that also didn't do well on my sheet.

Using Iferror


1 Answer 1


When you are copying data from one sheet (tab) to another within a spreadsheet file, you should not use importrange() but an { array expression }.

When you are using importrange() to copy data from one spreadsheet file to another, there will be trouble if the source data in turn depends on the target spreadsheet through another importrange().

If the source data is static, i.e., it is not expected to change, or the possible updates are of no relevance in the target spreadsheet, you can just use copy and paste.

If the source data is dynamic, and updates need to be shown in the target spreadsheet, you will have to use importrange() or a script. Some of the best resources for learning Google Apps Script include the Beginner's Guide, the New Apps Script Editor guide, the Fundamentals of Apps Script with Google Sheets codelab, the Extending Google Sheets pagejavascript.infoMozilla Developer Network and Apps Script at Stack Overflow.

Also see Import Range internal error.

  • Thanks @doubleunary for your reply on this issue of mine actually i have created pivot table in the google spreadsheet and then i was importing pivot table data into another google sheet but than also it was showing the same issue now instead of pivot table i have used formula for the calculated values of mine formulas are (unique ,vlookup) after using this formula i am trying to import that data into another google sheet but than also it is showing import internal error. so if you have any suggestion regarding that which can help me than please let me know.
    – new1
    Jul 23, 2021 at 14:06
  • Consider sharing two publicly editable sample spreadsheets, one being the source spreadsheet and the other the target spreadsheet where the issue can be reproduced. Jul 23, 2021 at 14:16
  • actually that sheet has my office data which i can't share and also the data on that sheet is linked to another sheet so is their anyother way through which you can help me out
    – new1
    Jul 24, 2021 at 7:18
  • Do not share your original spreadsheets but publicly editable sample spreadsheets with realistic-looking data, where the issue can be reproduced. Jul 24, 2021 at 7:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.