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
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
Data entry is one of the important steps in the data analysis process. It is important that the data collected is correctly entered into the electronic format. A good data entry form can reduce the number of human errors added during the data entry. A correctly designed data entry form can speed up data entry … Read more
When it comes to mass data entry works, it is essential to use data entry forms to improve accuracy and speed. This tutorial will show you how to create a data entry form in Google Sheets. With Google Sheets, it has many advantages over data entry forms like MS Access installed on your local computer. … Read more
Dependent dropdown lists are a type of dropdown list where the options available in the list depend on the value selected in another dropdown list. This type of dropdown list is useful when you design data entry forms or create dashboards with options to automatically change their content based on the user’s selection. Using dependent … Read more
When creating a Google My Map, the system automatically generates a data table for each layer. You can add rows or columns to this table as you develop the map. When you create a layer by importing data from a spreadsheet, the data in the spreadsheet is saved in the data table of that layer. … Read more
You can create your own maps by adding several other layers on top of the Google Map using the Google My Maps feature. Once you create your custom maps, you can share it with your team or anyone. You can view it on any device. In this post, I will show you how easily you … Read more
Using the DirectionFinder class of Google Apps script, you get directions between locations from Google Maps. This class returns several details, including travel time and distance between the given two locations. In this tutorial, I will show you how to get Google Map Travel Tim and Distance to Google Sheets automatically using Google Apps Script. … Read more
