Sheetgo Blog

Your go-to resource for all things spreadsheet related

How to visualize your Google IMPORTRANGE connections

For most of us, dealing with data is commonplace. And spreadsheet applications such as Google Sheets are a great means of working our way through these heaps of data sets. One of the challenges with data is that it has so many variations to it. So, we cannot treat it...

read more

Student attendance tracker template in Google Sheets

Every teacher is aware of the fact that some of their students tend to skip a few classes where possible. If this teacher does not have an easy system to track each student's attendance, it can get difficult to manage a big group. The Student attendance tracker...

read more

How to better manage your IMPORTRANGE connections?

We deal with a lot of data in our daily lives and usually manage that with spreadsheet applications such as Google Sheets. It makes sense to use a separate spreadsheet for each individual purpose. Because for one thing, we can't store everything on one file. For...

read more

How to transfer formatted Google Sheets

Spreadsheets have become an integral part of our lives. They have advanced so much over time that embracing them into our work makes more sense by the day. Their evolution manifested them from standalone desktop applications to cloud-based applications that can be...

read more

How to efficiently merge dozens of spreadsheets

It won't be an understatement to say that most of us handle our data and reports using spreadsheet applications like Google Sheets. The primary reason being they are inexpensive (read free). But they have also come very far in terms of form, functionality,...

read more

Automatically Import Filtered Data in Google Sheets

The ubiquity of the internet and deluge of wireless devices certainly made our daily lives easier. They paved the path for cloud-based applications such as Google Sheets. This application lets us collaborate and work on the spreadsheet data regardless of the location...

read more

Inventory Management: Definition and Best Practices

Inventory, in simple terms, is the list of goods in stock. For any organization, it is crucial that they keep tabs on the levels of their inventory at any given point in time. And that they keep their inventory in line with the present and projected demand for their...

read more

How to manage workflows in spreadsheets

A workflow is a predefined sequence of steps that we can use to get our work done with. The best part about a workflow is that we can illustrate the process in the form of a sequence diagram. In the context of spreadsheets, how relevant are workflows? Can we...

read more

How to analyze BigQuery data within Google Sheets

What is BigQuery? BigQuery is Google's solution to enterprise-level data storage. It is a cloud-based service that offers rapid SQL querying for big data at an affordable price. Because it is a Google product it is reliable, secure, and always improving. With...

read more

How to get data from BigQuery to Google Sheets automatically

What is the BigQuery Data Connector for Google Sheets? BigQuery connectors allow users to integrate BigQuery with other platforms—either data sources or analytics tools. Google recently launched a BigQuery connector for Google Sheets which allows greater accessibility...

read more

Best of 2018: Sheetgo’s top 10 blog posts

Let's get ready for 2019...We want to look back on an amazing Sheetgo year by presenting you with the best of 2018, top 10 blog posts that provided you with tips and tricks on how to use Google Sheets and all its possibilities, but also the extremely handy Sheetgo...

read more