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
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
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
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.
Step 4. Select the column
Click the column you want to add data to. After that, the column will be marked.
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
Step 6. Press Enter key
The formula will be applied and the data from the sheet you selected will be retrieved.
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
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
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.
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
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.
Step 5. Select the column
Click the column you want to add data to. After that, the column will be marked.
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.
Step 7. Press Enter key
Formulas will be applied and data from other sheets will be imported.
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.