قالب وردپرس درنا توس
Home / Tips and Tricks / Import data from another Google magazine

Import data from another Google magazine



  Google Spreadsheets logo

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.

  Multiple sheets in a document are located at the bottom of the page.

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

  Click on an empty cell where you want the data to go.

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

  = ! B7 

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

Press the Enter key and the data from the other sheet is displayed in that cell.

  Just like magic, the cell is filled with the data.

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.

  Note the cell range that you want to import. We use A22: E27 for this manual.

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).

  Select and copy the URL to your clipboard.

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 is the link you copied and indicates the cells which you want to import and which you have noted. Paste the URL between the quotation marks by pressing Ctrl + V (Windows / Chrome OS) or Cmd + V (macOS), type the range and press Enter. It should look like this:

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

 Give your spreadsheet access to the others and click

It takes a few seconds to load, but when it's done, the data range imports everything directly into your spreadsheet.

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


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.




Source link