Import Range & Query combined

When you apply QUERY and IMPORTRANGE together, you can query a data range in another spreadsheet (or multiple spreadsheets).

How to use?

SYNTAX: =QUERY(IMPORTRANGE("spreadsheet_url", "data_range"), "query_string")
spreadsheet_url – insert the URL of the spreadsheet to import data from.
data_range – insert a range of cells to query.
query_string – insert a string made using clauses of the Google API Query Language.

PRACTICE SHEET

The below sheet is view only mode, please make a copy to practice.

Copy of ImportantRange & Query Function

Make A Copy

Page updated

Google Sites

Report abuse