Imports a range of cells from a specified spreadsheet.
Sample usage
IMPORTRANGE('
https://docs.google.com/spreadsheets/d/abcd123abcd123
', 'sheet1!A1:C10')
IMPORTRANGE(A2,'B2')
Syntax
IMPORTRANGE(spreadsheet_url, range_string)
-
spreadsheet_url
– The URL of the spreadsheet from which data will be imported.- The value for
spreadsheet_url
must either be enclosed in quotation marks or be a reference to a cell containing the URL of a spreadsheet.
- The value for
-
range_string
– A string, of the format'[sheet_name!]range'
(e.g.'Sheet1!A2:B6'
or'A2:B6'
) specifying the range to be imported.-
The
sheet_name
component ofrange_string
is optional; by defaultIMPORTRANGE
will import from the given range of the first sheet. -
The value for
range_string
must either be enclosed in quotation marks or be a reference to a cell containing the appropriate text.
-
Notes
-
Spreadsheets must be explicitly granted permission to pull data from other spreadsheets using
IMPORTRANGE
. The first time that the destination sheet pulls data from a new source sheet, the user will be prompted to grant permission. Once access is granted, any editor on the destination spreadsheet can useIMPORTRANGE
to pull from any part of the source spreadsheet. The access remains in effect until the user who granted access is removed from the source. -
If the data that you are trying to import is too large, you may get an error.
See also
IMPORTXML
: Imports data from any of various structured data types including XML, HTML, CSV, TSV and RSS and Atom XML feeds.
IMPORTHTML
: Imports data from a table or list within an HTML page.
IMPORTFEED
: Imports an RSS or Atom feed.
IMPORTDATA
: Imports data from a given URL in .csv (comma-separated value) or .tsv (tab-separated value) format.