If you clicked on this blog post, you are probably, like most people, extremely busy. I am constantly reviewing the small tasks that I do each day to determine how much time is taken up by the most minor tasks.
For me, the one thing that I spent way too much time doing is searching for the same files over and over in Google Drive. Where it may be easy to “star” those files or even create bookmarks for easy access, I recently came across a better way of going about my business each day at school.
Save Yourself Time with this FREE Google Slides Template Today!
This summer, I redesigned my Tech Coach website to include spreadsheets into my Google Site projects and it has saved me a tremendous amount of time. Because of the Google Sharing settings, I am able to visit my website and edit the spreadsheets, but my visitors can only view the data. This is also a great way of setting up class projects as well.
To get you started with this skill, we would like to offer you a FREE Google Sheets To-Do template today. To download this spreadsheet simply fill out the form below and it will be delivered right to your inbox.
Google Sheets Are Awesome!
In the past, I would come up with ways of saving myself time by trying any number or organizational methods. Sadly, this wasn't the right thing to do. I would often spend too much time creating something and then never use it because it didn't work the way that I wanted it to work or it was inefficient.
Google Sheets and Google Sites … The Hidden Marriage
When it comes to Google Sheets and how they interact with Google Sites, there are a few things you should know. First, there are a few ways that you can show off your spreadsheet data on your Google Site.
Method 1: The Simple Way
The easiest way to embed a Google … anything on a Site is to click on the app name on the right-hand menu and then click on the files to insert it into the menu.
- The Good: The nice thing about this method is that it's quick and easy to do. If you are looking to have your data … ALL of your data seen on your Sheet visible then this is a great way of embedding your content on your website. But …
- The Bad: as you can see in this example, every other column is set up with the new Checkbox feature that can't be rendered using this method of embed. Sadly, this doesn't save us time because to see and use the full spreadsheet we need to click and open the spreadsheet.
Method 2: The Almost Simple Way… that is Hidden
The next method is easy to do, but you won't find any directions on it in any Google Sites handbook. To embed your Sheets this way, all you have to do is copy the URL of your sheet and while your mouse is inside of the canvas click on your paste option (usually Command/Control V)
This then gives you a quick method for putting any type of content on your site without needing to go into the right side menus and doing a search for what you need.
- The Good: This is quicker and much easier and my preferred method vs doing a search on the right side menu.
- The Bad: The end result is the same. You end up with a spreadsheet that doesn't do the trick.
Method 3: Manipulate the URL of your Spreadsheet
In order to create an experience where you can embed a spreadsheet that you can use directly on your website is by manipulating the URL and embedding the entire spreadsheet.
To do so:
- Copy the URL of your spreadsheet
- Paste the URL into a new tab (do not hit enter)
- At the end of the URL, look for the “/” and delete everything to the RIGHT of it.
- Copy the shortened URL and paste it into the embed side of Google Sites.
- Choose WHOLE PAGE
By embedding the whole page you have a working spreadsheet that you can now manipulate the data on your sheet.
How Are You Using Google Sheets To Save Yourself Time?
We would love to learn how you are using Google Sheets to save yourself time. Do you have your own To-Do template that you wouldn't mind sharing? Please leave a comment below and share some of your links with us today!