Tag: google

How to Quickly Copy Data from One Google Sheet to Another

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”. 



Google Doc Add-ons and Easy Bib

Google Doc Add-ons and Easy Bib

Today I wanted to share with everyone an awesome new feature that Google added to both Google Docs and Spreadsheets this week. You may have noticed a new menu option in your Docs and Spreadsheets called Add-ons.

Screen Shot 2014-03-13 at 1.42.06 PM

Add-ons are third party apps that can be integrated into your documents and provide you with lots of new fun tools. To learn more about Add-ons please click here or watch the video below.

My favorite add on so far is Easy Bib. Easy Bib is a free automatic bibliography generator. For more about Add-ons and Easy Bib please check out the video below.

Google Doc Templates

Google Doc Templates

Today I want to share with everyone a great resource for finding Google Doc templates. Using templates with your students is a great way to save time, give students a starting point, or help inspire students to create their own documents. Click here to browse Google’s public template gallery. For education specific templates click here. Your individual school sites will also have some templates that teachers have shared in the past. If you have any questions or find any useful Google Doc templates please feel free to share with the rest of the group!