If you need to import data from another spreadsheet into Google Spreadsheets, you can do this in various ways. Whether you want to retrieve the data from another sheet in the file or a completely different spreadsheet, this is how.
Importing data from another sheet
This first method requires you to have more than one sheet in a document. You can see if your document has more than one sheet by looking at the bottom of the page. And to add another one, press the plus sign (+) to create a new one.
Start your browser, go to Google Spreadsheets and open a spreadsheet. Click and highlight the cell into which you want to import the data.
RELATED: The Beginner's Guide to Google Spreadsheets
Next, you must type a formula that refers to the cell from the other sheet. If your sheets have a name, you want to put the name in place of
Press the Enter key and the data from the other sheet is displayed in that cell.
Importing data from another document
In addition to importing data from a sheet into a spreadsheet, you can also refer to the cell (s) from a completely different document. The formula has changed slightly compared to the previous one, but works almost identically.
RELATED: Importing an Excel document into Google Spreadsheets
Start the document from which you want to import data and note the range of cells to refer to. For this manual we want the range A22: E27.
Then copy the full URL from the spreadsheet to the clipboard. Click on the address bar and then use the shortcut Ctrl + C (Windows / Chrome OS) or Cmd + C (macOS).
Now go back to the Google Spreadsheets homepage and open the spreadsheet where you want to import the data.
Click on an empty cell and type
= IMPORTRANGE (" where
= IMPORTRANGE ("http://docs.google.com/spreadsheets/d/URL/to/spreadsheet/edit", "A22: E27")
Note: If you have more than one sheet in the other document, specify which sheet you want to refer to. For example, if you are importing from Sheet2, type "Sheet2! A22: E27" instead.
Press Enter and you will see the "#REF!" Error. This is normal, you only need Google Spreadsheets to give access to the other sheet. Select the cell with the error and then click "Allow access".
It takes a few seconds to load, but when it's done, the data range imports everything directly into your spreadsheet.
Although cell formatting – such as colors – does not & # 39; t follow data when importing from other sheets, these are the best ways to refer to external cells in Google Spreadsheets.