How to import data from website to Google Sheets

How to import data from website to Google Sheets

We use data from various sources for our data analysis works. In previous posts, we discussed how to import data from one Google Sheets to another, one sheet (tab) to another sheet(tab), and Import CSV files to Google Sheets. In this post, I will show you several methods to import data from website to Google … Read more

How to Create a Button in Google Sheets to Run Scripts

How to Create a Button in Google Sheets to run Scripts

You can create a button in Google Sheets to run Apps Script from its user interface. The button is essential when you design Google Sheets for others who do not know App Scripts. This post will show you how you can create a button in Google Sheets and attach the Google Apps Script function to … Read more

How to Create an Online Data Entry Form that can Perform CRUD Operations on Google Sheets

How to Create an Online Data Entry Form that can Perform CRUD Operations on Google Sheets

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

Top 10 Keyboard Shortcuts That Everyone Should Know

Top 10 Keyboard Shortcuts That Everyone Should Know

Keyboard shortcuts are designed to access routing functions more quickly and easily. When you are working with computer applications, you will see that several shortcuts are common to many of the applications. Knowing these common keyboard shortcuts will assist you in working with any application easier. This post is an attempt to summarize the top … Read more

These 10 Google Search Tricks can yield more relevant results

Google Search Tricks

Google is the most popular search engine in the world. However, did you know that there are special characters and words that you can include in your search to get even better results? Try following 10 google search tricks and tips on your next google search to get more accurate results. 01. Use quotes (“”) … Read more