How to Create Callable Phone Numbers on Google Sheets

When you click on an email link on a website, it opens your default email program. Similarly, you can generate callable phone numbers on your website. When someone clicks on the phone number, it will activate the dialer on their mobile phone and start dialing the specified number.

The guide below has two parts. The first part involves adding phone numbers to a Google Sheets file, and the second part focuses on creating clickable phone number links.

HOW TO ADD A PHONE NUMBER TO GOOGLE SHEETS

You can't simply add a phone number to a Sheets on Google Sheets because phone numbers with a '+' sign at the beginning are interpreted as mathematical formulas. When you add a phone number to Sheets with a '+' sign, it assumes you are entering a mathematical formula and calculates a value.

There are 2 methods to add a phone number to Google Sheets

Method 1: You can enclose the phone number in double quotes and start with an '=' sign.

Method 2: Another easier way is to add a ' in front of the phone number. Google Sheets will recognize this as a text string.

HOW TO MAKE A DIALABLE PHONE NUMBER ON GOOGLE SHEETS

Getting into the core issue, how to create a phone number that can be dialed on Google Sheets. Normally, we would use the =HYPERLINK() formula with the phone number protocol, but unfortunately, Google Sheets doesn't support this formula.

So, a formula like =Hyperlink('tel:123456','Call') won't work since Sheets only allows regular http and mailto hyperlinks. There's a very simple workaround. We'll create a 'regular hyperlink' by adding the following formula: https://ctrlq.org/call/ before each phone number in Google Sheets.

Apply it to the phone number as in cell A2. By adding the formula above, we get a formula like this:

= HYPERLINK('https://ctrlq.org/call/' &A2, 'Call Mytour Support')

Display Result:

That's it, you can click on the link to initiate the call. After clicking on the link for the callable phone number, the system will provide options to open the calling software on your computer (or phone). Depending on the software you use for voice on your computer, the system will open that software; in my case, it will open Skype.

Here is a guide on using Google Sheets with the trick of writing and making phone numbers callable on Google Sheets. We hope this article will be helpful to you in using Google Sheets. If you encounter any difficulties during the process, feel free to comment below; the Mytour technical team will assist you.