I would like to use the importrange formula to import data from "spreadsheetA" that contains "keyword" in columnD.

I can get importrange to work but I cannot figure out how to filter it so it will only import if a keyword is found in column d.

  • I think I know how to help you, can you create a demo sheet with some dummy data?
    – Umar.H
    Sep 21, 2018 at 17:05

1 Answer 1


You nest an import range to a query to meet your desired result:

=query(IMPORTRANGE("key","Sheet1!A:C"),"Select * Where Col2 contains 'Keyword'") 

Demo sheet for you:


If you get a REF error you need to give yourself or get permission from the owner to read data from that sheet.

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