How to Retrieve Data from Another Sheet on Google Sheets Via PC or Mac Computer

Table of contents:

How to Retrieve Data from Another Sheet on Google Sheets Via PC or Mac Computer
How to Retrieve Data from Another Sheet on Google Sheets Via PC or Mac Computer

Video: How to Retrieve Data from Another Sheet on Google Sheets Via PC or Mac Computer

Video: How to Retrieve Data from Another Sheet on Google Sheets Via PC or Mac Computer
Video: How to Install Fonts in Windows 7 2024, November
Anonim

This wikiHow teaches you how to retrieve data from another sheet in a Google Sheets document, as well as pull data from a separate Google spreadsheet. To import data from a separate document, you need the URL of the sheet you want to source before the data can be retrieved.

Step

Method 1 of 2: Retrieving Data from Other Sheets on the Same Sheet

Pull Data from Another Sheet on Google Sheets on PC or Mac Step 1
Pull Data from Another Sheet on Google Sheets on PC or Mac Step 1

Step 1. Visit https://sheets.google.com via a web browser

If you're already signed in to your Google account, a list of Google Sheets documents linked to your account will appear.

Sign in to your Google account if you don't automatically sign in

Pull Data from Another Sheet on Google Sheets on PC or Mac Step 2
Pull Data from Another Sheet on Google Sheets on PC or Mac Step 2

Step 2. Click the Google Sheet document

After that, the spreadsheet of the document you want to use will be displayed.

  • You can also create a new spreadsheet by clicking the button

    Android_Google_New
    Android_Google_New
Pull Data from Another Sheet on Google Sheets on PC or Mac Step 3
Pull Data from Another Sheet on Google Sheets on PC or Mac Step 3

Step 3. Open the sheet you want to add data to

On the sheet tab at the bottom of the window, click the sheet to which you want to send data.

If the spreadsheet does not have multiple sheets, click the “ ” in the lower left corner of the page.

Pull Data from Another Sheet on Google Sheets on PC or Mac Step 4
Pull Data from Another Sheet on Google Sheets on PC or Mac Step 4

Step 4. Select the column

Click the column you want to add data to. After that, the column will be marked.

Pull Data from Another Sheet on Google Sheets on PC or Mac Step 5
Pull Data from Another Sheet on Google Sheets on PC or Mac Step 5

Step 5. Type =Sheet1!A1 into the field

Replace " Sheet1 " with the sheet name, and change " A1 " to the copied column. This formula must contain an equal sign, sheet name, exclamation point, and the column you want to copy.

If the sheet name contains spaces or symbols, enclose the name in single quotation marks. For example, if you want to copy column A1 from the “Fund Sheet $$$” sheet, the formula you need to use is ='Fund Sheet $$$'!A1

Pull Data from Another Sheet on Google Sheets on PC or Mac Step 6
Pull Data from Another Sheet on Google Sheets on PC or Mac Step 6

Step 6. Press Enter key

The formula will be applied and the data from the sheet you selected will be retrieved.

Pull Data from Another Sheet on Google Sheets on PC or Mac Step 7
Pull Data from Another Sheet on Google Sheets on PC or Mac Step 7

Step 7. Drag the blue selector to copy the next columns

If you want to copy more columns from the same sheet, click and drag the blue selector box in the lower-right corner of the marked column, and drag the selection down or sideways to copy more columns.

Method 2 of 2: Retrieving Data from Another Sheet

Pull Data from Another Sheet on Google Sheets on PC or Mac Step 8
Pull Data from Another Sheet on Google Sheets on PC or Mac Step 8

Step 1. Visit https://sheets.google.com via a web browser

If you're already signed in to your Google account, a list of Google Sheets documents linked to your account will appear.

Sign in to your Google account if you're not automatically signed in

Pull Data from Another Sheet on Google Sheets on PC or Mac Step 9
Pull Data from Another Sheet on Google Sheets on PC or Mac Step 9

Step 2. Open the Google spreadsheet that you want to use as a data retrieval source

Click the spreadsheet document with the data you want to retrieve.

Pull Data from Another Sheet on Google Sheets on PC or Mac Step 10
Pull Data from Another Sheet on Google Sheets on PC or Mac Step 10

Step 3. Right-click the URL and select Copy

After opening the spreadsheet document, right-click the web address in the browser's address bar to highlight all addresses, then select Copy ” from the drop-down menu.

On Mac computers using a trackpad or magic mouse, click the mouse using two fingers or hold down the Control key and click to perform the right-click mechanism

Pull Data from Another Sheet on Google Sheets on PC or Mac Step 11
Pull Data from Another Sheet on Google Sheets on PC or Mac Step 11

Step 4. Open the spreadsheet you want to add data to

In a new tab or browser window, visit https://sheets.google.com and click the worksheet you want to add data to.

Pull Data from Another Sheet on Google Sheets on PC or Mac Step 12
Pull Data from Another Sheet on Google Sheets on PC or Mac Step 12

Step 5. Select the column

Click the column you want to add data to. After that, the column will be marked.

Pull Data from Another Sheet on Google Sheets on PC or Mac Step 13
Pull Data from Another Sheet on Google Sheets on PC or Mac Step 13

Step 6. Type the following formula into the column:

=IMPORTRANGE("spreadsheetURL", "Sheet1!A1:B14")Delete "spreadsheetURL" and paste the URL you copied earlier, and replace "Sheet1!A1:B14" with the sheet name and column range you want to import. This formula must contain an equal sign, the word “IMPORTRANGE” in capital letters, opening brackets, quotation marks, source sheet URL, quotation marks, commas, quotation marks, column names, exclamation points, first column in data range, colons, the last column in the data range, quotation marks, and closing brackets.

To paste the URL, right click and select “ Paste ”, or press the keyboard shortcut Ctrl+V on Windows computers or Command+V on Mac computers.

Pull Data from Another Sheet on Google Sheets on PC or Mac Step 14
Pull Data from Another Sheet on Google Sheets on PC or Mac Step 14

Step 7. Press Enter key

Formulas will be applied and data from other sheets will be imported.

Pull Data from Another Sheet on Google Sheets on PC or Mac Step 15
Pull Data from Another Sheet on Google Sheets on PC or Mac Step 15

Step 8. Click Allow Access on the column pop-up menu

You will be asked to grant data retrieval permission if this is your first time retrieving data from another spreadsheet. Now, the data has been successfully imported to the destination spreadsheet.

Recommended: