How to Change the Date Format in Google Sheets

You can customize the date format in a Google Sheet with the TEXT function and completely change the way the date and time values are displayed in the worksheet.

Find Product Prices in Google Sheets with Vlookup and Match Functions

How to use the Index and Vlookup functions in Google Sheets with Match and ArrayFormula to lookup product prices that are listed as a table in the spreadsheet.

How to Request Payments with Stripe Checkout and Google Sheets

How to use Google Sheets to generate Stripe payment links and request payments in any currency from customers anywhere in the world!

How to Request Payments with Razorpay and Google Sheets

How to use Google Sheets to generate Razorpay payment links and easily accept payments from customers anywhere in the world!

Essential Date Functions for Google Sheets

Master all the important date functions for Google Sheets with working formula examples. Whether you are looking to calculate the number of working days before the project is due or days until your upcoming birthday, this is the place to start.

How to Use Notion with Gmail and Google Sheets using Apps Script

How to use the Notion API with Google Apps Script to connect Gmail, Google Forms, and Google Sheets with your Notion workspace.

Sort by Random - How to Randomize the Order of Rows in Google Sheets

Learn how to sort your data in a Google Sheet in randomized order using Excel formulas and Google Apps Script.

How to Replace Accented Characters (diacritics) with English letters in Google Sheets

The Google Sheets function will convert diacritics letters or characters with accents to their simple Latin equivalent. For instance, á or à will change to 'a', ê or ë will be replaced with e and so on.

How to Convert Column Number (e.g. 28) to Column Letter (e.g. AB) in Google Sheets

Convert column letters (AA) to corresponding numbers, or covert column numbers to A1 notation cell references in Google Sheets and Microsoft Excel.

Google Sheets - Find Values in One Column that are Missing in Another Column

How to compare columns in Google Sheets and highlight cell values that are in one column but missing in another column.

How to Email Spreadsheets Automatically on a Recurring Schedule

How to Add Options in Google Forms Questions from Google Sheets

Learn how to bulk add options in dropdown lists and multiple-choice questions in Google Form using values from Google Sheets

Google Maps Formulas for Google Sheets

Use Google Maps formulas inside Google Sheets to calculate distances, travel time, get driving directions, look up postal codes with reverse geocoding and more!

How to Perform IP Address Lookup with Google Sheets

How to determine the country, city and ISP name of IP addresses in bulk with Google Sheets and IP2Location service.

How to Copy a Formula Down an Entire Column in Google Sheets

Learn how to use the ARRAYFORMULA function in Google Sheets to quickly apply a formula to an entire column in the spreadsheet. The formula is also added to new rows automatically.

How to Use Formulas with Google Form Responses in Sheets

Learn how to add autofill formulas with Google Form responses in Google Sheets. The cell values are automatically calculated when a new Google Form response is submitted.

The Best Google Add-ons for Docs, Sheets, Slides and Google Forms

How to Preserve Formatting of Spreadsheet Cells in Mail Merge

You can format the source data in Google Spreadsheet in different colors, fonts and sizes and all your cell formatting will be retained in the email messages.

How to Highlight Duplicates in Google Sheets and Remove

How to quickly highlight cells with duplicate values in Google Sheets using conditional formatting. The duplicate cells can be easily removed from the spreadsheet with Google Script.

Measure Core Web Vitals of your Websites with Google Sheets

Core Web Vitals are a set of metrics defined by Google to help webmasters understand the performance of their websites. You can automate the measurement and tracking of core vitals with Google Sheets.

How to Use Hyperlinks in Google Sheets

How to Use Google Sheets with D3.js and Google Visualization

How to Make Pixel Paintings with Google Spreadsheets

How to Insert Images in Google Sheet Cells

How to Get Hidden and Filtered Rows in Google Sheets with Google Script

Convert Numbers to Words using Indian Numbering in Google Sheets

Use a custom Google Sheets function to convert numbers to words in Indian Rupees using lakhs and crores grouping.

How to Send SMS Messages with Google Sheets and your Android Phone

Send personalized text messages to your contacts with the help of Google Sheets and your Android phone. The SMS messages go directly from your phone SIM, no third-party SMS service is required.

Track Coronavirus (COVID-19) Cases in India with Google Sheets

The Coronavirus (COVID-19) tracker uses sparklines in Google Sheets to help you visualize the spread of the coronavirus outbreak across different states of India over time.

How to Import MailChimp Subscribers to Google Sheets

Learn how to import subscribers' email addresses from your MailChimp mailing lists into Google Sheets and Google Contacts.

Convert Google Documents and Spreadsheets with Apps Script

How to Scrape Reddit with Google Scripts

Learn how to scrape data from any subreddit on Reddit including comments, votes, submissions and save the data to Google Sheets

How to Color Alternate Rows in Google Sheets

Convert and Email Google Spreadsheets as PDF Files

Get the Form Edit Response URL in Google Sheets

How to Track your Study Time with Google Forms and Sheets

Save Gmail Messages to a Google Spreadsheet

How to Track Google Spreadsheet Views with Google Analytics

How to Make YouTube Playlists with a Google Spreadsheet

Find Duplicate Rows in Google Sheets

How to Import Web Data into Google Sheets

Build a Web Page Monitor with Google Sheets using ImportXML

Screen Scraping the Google Play Store with Google Sheets

How to Write JSON to a Google Spreadsheet

Convert Word, Excel and PowerPoint files to Google Docs with Google Script

Save Paypal Email Receipts in Google Spreadsheet

Build a Charts Dashboard with Google Sheets and HTML Service

How to Create Personalized Documents from a Google Spreadsheet in Minutes

Fill Google Spreadsheet with Random Data

How to Import CSV Files into Google Spreadsheets with Google Apps Script

Color Codes for Google Spreadsheets