Google Sheets is the most popular cloud-based spreadsheet application. It is also one of the best alternatives to Microsoft Excel. The best thing is, Google has made this tool available for free. You only need to have a free Google account to access Google Sheets. On bpewebs.com, under this category, you can find some tips and tricks to improve productivity with Google Sheets.
You can build several types of Web Apps using Google Sheets Apps Script. In previous posts, we discussed creating several types of online data entry forms using Google Apps Scripts. This post will show you how to pull data from Google Sheets to HTML table and display it in a Web app created with Google … Read more
When you share a Google Sheet with others, they will have access to all individual sheets in the Spreadsheet. At present, there is no direct option to share a single sheet in Google Sheets. However, using the following method, you can share data in a single sheet or selected few sheets without giving access to … Read more
Google Sheets Checkbox is an interactive element that allows the user to make a binary choice. With this option, you can convert a cell to a check box. By default, the checkbox is unchecked, and the value is FALSE. You can click the cell to change the state. When the checkbox is checked, the cell … Read more
In previous tutorials, we talked about building web apps to interact with Google Sheets using Google Apps Script. When you build those types of web apps, you may need to implement a search field to get data from Google Sheets back. This tutorial will show you how you can create a web form to search … Read more
In the previous tutorials, we talked about importing data from another sheet in the same spreadsheet and from other spreadsheets to Google Sheets. In this tutorial, let’s focus on importing CSV into Google Sheets. You can import TSV files also using the methods described below. In addition to that, I will show you how to … Read more
In the previous tutorial, we discussed how to import data from another Sheet in the same Google Spreadsheet. This tutorial will show you how to import data from one Google Sheet to another. And also, you can use this method to import data from multiple Google Spreadsheets. How to uniquely identify each Google Spreadsheet You … Read more
Analyzing data is simpler when your raw or source data is on a separate sheet. This keeps your analysis sheet organized and tidy. In this post, I will demonstrate how to get data from another sheet in Google Sheets. By storing your raw data on a separate sheet, you can import it as needed for … Read more
Online data entry forms are a powerful tool that you can use to collect many types of data more easily and accurately. Google Sheets is the most powerful cloud-based spreadsheet application that you can use absolutely free. Google is also offering another free tool named Google Apps Script (GAS) to increase the power of your … Read more
There are many Project Management Tools available in the market. Many of them have cloud versions that you can access with a monthly subscription. If those subscription plans are not affordable to your project, this article is for you. In this post, I will show you how you can use Google Sheets for project management. … Read more
In a previous post, I explained how to create a simple dependent dropdown list in Google Sheets. However, using that method you cannot copy the dependent dropdown list into multiple rows. As such, in this tutorial, I will show you how you can create a dependent dropdown list in Google Sheets and copy it into … Read more