Modified 03 January 2020 by Vicki Rayner

Save time by importing existing data into a new spreadsheet without having to copy it all again.

We often find we need to copy important data into more than one spreadsheet, but it can be tricky if the data is large and complex. Use this handy formula to import your data in minutes.

  • To start, open up the spreadsheet or tab you want to copy to the new Sheet > copy the sheet’s URL
  • Make a note of the cells you want to import
  • Open the new sheet where you want the data to appear
  • In the cell begin to type > =IMPORTRANGE (you’ll see the code as you begin to type)
  • Type > quotation  (very important) then paste the URL from the sheet and add another quotation mark at the end of the URL
  • Then add a comma , > quotation mark again “ > then type the exact name of the specific tab you want to copy followed by an exclamation mark !
  • Finally, type the range of cells you want to import eg: A1:A19 followed by quotation marks
  • Press > Enter and your data will now appear in your new Sheet

Follow the formula




Name of tab


Cell range