Embedded Files
Do you want to import the data from other Google Sheets into the one in which your working currently?
You can do this easily using the IMPORTRANGE function in Google Sheets.
While it’s really easy to connect two workbooks in Excel that reside on your hard drive or a network drive, the only way to connect two Google Sheets is by using the IMPORTRANGE Function.
How to use?
How to use?
SYNTAX: =IMPORTRANGE(spreadsheet_url, range_string)
spreadsheet_url – this URL of the Google Sheets spreadsheet from which you want to import the data. This URL needs to be within double quotes. You can also have the URL in a cell and then use the cell reference.
range_string – the range of cells that you want to import. Note that this needs to be in the following format: “[sheet_name!]range”. For example, if you want to import the cells A1:C10 from a sheet named Test, the format would be “Test!A1:C10”
If you do not specify the sheet name, the formula would assume that you need to import the data from the first sheet of the Google Sheets document.
You can also have this text in a cell and then use the cell reference as the second argument.
PRACTICE SHEET
The above sheet is view only mode, please make a copy to practice .
Page updated
Google Sites
Report abuse