How to Quickly Copy Data from One Google Sheet to Another

Google Sheets is a great tool for documenting and sharing data. Sometimes you need to have multiple copies of your data in different spreadsheet files. Traditionally we would need to copy the data from one spreadsheet and paste it into a new spreadsheet. Today I wanted to share with everyone a shortcut for quickly copying data in between two different Google Sheets files. This shortcut is a big time saver and great for ensuring that all of your formulas, formatting, and data copy correctly. For more information on this topic click here for a brief 90 second tutorial video.


Step 1:Screen Shot 2014-05-27 at 9.10.54 AMEnter the data that you want to copy into your spreadsheet. Click on the sheet name and click on “Copy to…”

Step 2: Screen Shot 2014-05-27 at 9.11.12 AM

Select the Google Sheets file you want to insert your sheet into.

Step 3:Screen Shot 2014-05-27 at 9.11.20 AMAfter your data has been copied you should see this prompt.

Step 4:

Screen Shot 2014-05-27 at 9.11.31 AMOpen up your target notebook and look for a worksheet called “Copy of Sheet 1”. 



Leave a Reply

Your email address will not be published. Required fields are marked *