Reference data from other sheets

Within a single spreadsheet, you can replicate data and copy it from one sheet to another.

Get data from other sheets in your spreadsheet

  1. On your Android phone or tablet, open the Google Sheets app Sheets.
  2. Open or create a sheet.
  3. Select a cell.
  4. Type = followed by the sheet name, an exclamation point, and the cell being copied. For example, =Sheet1!A1 or ='Sheet number two'!B4.

Note: If a sheet name contains spaces or other non-alphanumeric symbols, include single quotes around it (as in the second example).

Get data from other spreadsheets

To pull data from other spreadsheets, open on your computer and use the IMPORTRANGE function.


Was this helpful?
How can we improve it?