Import data from other sheets

TRY IT OUT

Google Sheets has a number of functions that can be used to import data into a spreadsheet, including ImportData, Import HTML and ImportRange.

The following functions can be used:

For example, to import a range of data from one sheet into another:

In the source spreadsheet, select the spreadsheet reference from the URL in the address bar along the top of the browser window, then press Ctrl C to copy the URL
Note the sheet name and range you wish to import data from
In the destination sheet, click in the first cell you wish to import data into
Type =IMPORTRANGE and open brackets (
Open quotations, press Ctrl V to paste the spreadsheet URL, then close quotations
Type a comma
Open quotations, type the sheet name followed by ! then the range of cells, then close quotations
Close brackets )
Press Enter to enter the formula

For example, if a spreadsheet has the following URL:

And you wish to copy the totals from the selected cells in Sheet1:

You would enter the following function:

=IMPORTRANGE("1Dpfe3qyfbLks9hGYhCqF_-VMTkRgxCTuqpdON6dgYVU","Sheet1!B6:E6")

You can only have a maximum of 50 import functions in a spreadsheet.

We recommend using IMPORTRANGE to import no more than 20,000 rows of data in a single function.

Report abuse