Query Function to Obtain Data from One Spreadsheet and Link into another in Google Spreadsheets

Avatar
David Boxer
Follow

Google Spreadsheets has a powerful function that allows you pull data from other sources, including other Google Spreadsheets. The QUERY() function. It can be very useful if you want to query (or pull) information from one spreadsheet and reference it into a second spreadsheet, which would allow you to only update in one location.  

Watch at 15 minute Video Demonstrating How to Setup the Query Function:

 

Resources Discussed in the screencast (after opening each sheet, choose File>Make a Copy… from the menu to make your own editable copy of each sheet. I demonstrate doing this in the beginning of the video.):

Query Source Spreadsheet 2

Query Example Spreadsheet 1

 

Generic Query Formula:

=QUERY(ImportRange("SPREADSHEET_UNIQUE_ID", "SHEET_NAME!RANGE"), "YOUR QUERY", NUMBER_OF_HEADER_ROWS)

Example of a Generic Query Formula:

=QUERY(importRange("0AoFcccw7VbMKdGFlV0JhMHRNTWU1d2FBQl9MUXk", "Sheet1!A1:C5"), "select Col1, Col2, Col3", 1)

 

Reference: CrestWeb Services - Query Function Examples in Google Spreadsheets

Google Help: Google Drive - Query Function

Have more questions? Submit a request

1 Comments

Date Votes
  • 0
    Avatar
    Bernabe Garcia

    Thank you.  Just enough in your notes to get those of us halfway familiar with Query to up and running without having to watch the video.  I wish more gurus would do that.  Sometimes I am just missing a quotation mark or a comma and looking at your example really helped me figure out what was wrong.

Please sign in to leave a comment.