Google Sheets is a cloud-based spreadsheets application and by using it we can do a lot of productive work. We can store information, generate summary reports, track progress, and derive insights etc. The possibilities are endless. But, if we are thinking of achieving the advanced level of utility from a brand new spreadsheet file, it will require a lot of our time and effort. A blank file is essentially an empty slate – and bringing that up to the speed of a fully functional and consumable utility is no easy task. Thankfully we can get a head start by choosing from numerous readily available Google Sheets templates.
Google Sheets templates – where to find them?
Navigate to https://docs.google.com/ > Main menu > Sheets. If not signed in to Google account already, the application may ask you to do so.
Clicking on the TEMPLATE GALLERY will bring up the readily available templates applicable to multiple contexts. We will see that they have categorized these templates under headings such as Personal, Work, Project Management, and Education.
For the purposes of demonstration, we chose Gantt Chart template from Project Management category. As soon as we select that, the template automatically loads into a new Google Sheets file. It is also saved in our Google Drive without us having to do anything.
The advantage with templates, as we can see is that most of the groundwork is already done. We just have to customize them to suit our purposes. Considering the example above, we may have to modify certain cells, rows or columns to make them align with our needs. If not for these Google Sheets templates, imagine having to go through all that trouble building it ourselves from scratch!
Third-parties and beyond
If neither of these existing templates satisfies the scope requirements, we can look out for additional templates. They are usually available in the form of add-ons that third parties provide. Some of the notable template providers are Vertex42, Spreadsheet123, and SmartSheet.
If what we need is still a lot different from what is already available, we can create our own custom templates. We outlined this process in this blog post.