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

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

0 Comments

Please sign in to leave a comment.
Powered by Zendesk