If you need to import data from another spreadsheet into Google Sheets, you have several options. Regardless of whether you want to drag data from another sheet in the file or from a different table:
Import data from another sheet
This first method requires you to have more than one sheet in a document. You can tell if your document contains more than one sheet by looking at the bottom of the page. To add another one, simply press the plus sign (+) to create a new one.
Launch your browser and go to Google Sheets and open a spreadsheet. Click the cell where you want to import the data and highlight it.
RELATED: The Beginner's Guide to Google Sheets
Next, you must enter a formula that points to the cell from the other sheet. If your sheets are named, you would like to insert the name after the exclamation mark instead of
Press Enter and Data from This cell displays a different sheet.
Import data from another document
In addition to importing data from a sheet in a table, you can refer to a cell (s) from a completely different document. The formula has changed slightly from the previous one, but it works almost identically.
RELATED: Importing an Excel Document into Google Sheets
Start the document from which you want to import data and note the range of cells to reference. In this manual we would like to use the range A22: E27.
Then copy the full URL of the table to the clipboard. Click the address bar and use Ctrl + C (Windows / Chrome OS) or Cmd + C (macOS).
Return to Google Now Click on an empty cell and enter
= IMPORTRANGE ("where
= IMPORTRANGE ("http://docs.google.com/spreadsheets/d/URL/to/spreadsheet/edit", "A22: E27")
Note: If If the other document contains more than one sheet, you must specify which sheet you want to refer to. For example, if you are importing from Sheet2, enter "Sheet2! A22: E27" instead.
Press Enter, and the error "#REF!" Should be displayed. This is normal. For Google Sheets, all you have to do is allow access to the other sheet. Select the cell with the error and click on "Allow access".
Loading should take a few seconds, but when it's complete The data area imports everything directly into your spreadsheet.
The formatting of cells, eg. t Follow the data when importing other worksheets. This is the best way to reference external cells in Google Sheets.