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 where 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. range_string