I need to restrict the ImportRange function below to show only visible rows as some of the rows are filtered and some of the rows are grouped.


2 Answers 2


Follow this answer.

  1. Create a new sheet within the same document
  2. Use filter function (Set the A1 cell to be =filter(Sheet1!A:X, Sheet1!A:A>1)). (See docs on the filter function.)
  3. Import range from this new sheet.

At this time IMPORTRANGE can't import only visible rows. Currently there isn't any built-in function that does that and this can't be done by using a custom function as accesing an external range require authorization and custom functions can't use methods that require it.

The alternative is to use another kind of script, and add-on or a third party application.

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