قالب وردپرس درنا توس
Home / Tips and Tricks / How to import data from another Google Sheet

How to import data from another Google Sheet



  Google Sheets logo

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.

  Several sheets in a document are at the bottom of the page.

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

  Click an empty cell where you want to import the data.

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 and the cell you want to refer to. It should look like this:

  = ! B7 

  Type = followed by the name of the sheet and the cell you want to import.

Press Enter and Data from This cell displays a different sheet.

  As if by magic, the cell is filled with the data.

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.

  Note the cell range to import. This manual uses 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).

  Select the URL and copy it to your clipboard.

Return to Google Now Click on an empty cell and enter = IMPORTRANGE ("", "") where ] is the link, that you copied, and is the cells that you want to import and that you wrote down. Paste the URL between the quotation marks by pressing Ctrl + V (Windows / Chrome OS) or Cmd + V (macOS), typing in the range, and then pressing Enter. It should look like this:

  = 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".

 Let your spreadsheet access the other and click

Loading should take a few seconds, but when it's complete The data area imports everything directly into your spreadsheet.

 Again, all data from the cell range is imported into your document like magic.


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.




Source link