Google Sheets IMPORTRANGE Function tutorial. With IMPORTRANGE function you can import data from other spreadsheets. All you need is the spreadsheet URL and the range you'd like to import. You can use IMPORTRANGE to create dynamic reports and also append data from multiple sheets.