Skip to main content

Phone number callable in Google sheets😵😵😵😵

How to Make Phone Numbers Callable in Google Sheets


If you click an email link on a webpage, it opens your default mail program. Similarly, you can make phone numbers on your website “callable” meaning when someone clicks the phone number, it will launch the dialer on their mobile phone and initiate dialing of the specified phone number. It is recommended that you make phone numbers clickable as more and more people would be accessing your site on their mobile devices.

How to Insert Clickable Phone Numbers in Web Pages

We use the simple tel protocol to convert a plain text phone number on a web page into a clickable telephone link.
html-telephone-links.png
For instance, if you click this link on a mobile phone, it will open the phone dialer prefilled with the specified number. There’s no need to copy-paste numbers.

How to Type Phone Numbers in a Google Sheet

It is a bit tricky to type phone numbers inside Google Spreadsheets. Here’s why:
Phone numbers are mostly made of digits preceded by the plus (+) symbol. The problem is as soon as add the plus sign in the spreadsheet cell, it assumes that you entering a math formula and tries to calculate the value.
phone-number-formatting.png
There are two simple workarounds to this problem. You can enclose the phone number inside double quotes (“) and precede it with an equal to (=) sign.
An even easier alternative is to use the single quote (‘) before the phone number. Google Sheets will then interpret the cell’s value as text and the phone number formatting will be preserved.

How to Make Phone Numbers Clickable in Google Sheets

Coming to the main problem, how do you make phone numbers inside a Google Sheet clickable. The obvious answer would be to use the =HYPERLINK() method with the tel protocol but, unfortunately, Google Sheets do not support it.
So a formula like =HYPERLINK(“tel:12345”, “Call Me”) would not work since sheets will only allow regular http and mailto hyperlinks. There’s a simple workaround though.
google-sheet-phone-links.png
You can create a regular hyperlink in the cell pointing to a website which in turn redirects to the actual telephone link. To see this in action, add https://ctrlq.org/call/ before any phone number in the Google Sheet and it will turn into a clickable telephone link.
Say you have the phone number in cell A1. Add this simple formula in any other cell and it will create a telephone link just like on a regular webpage.
=HYPERLINK(“https://ctrlq.org/call/”&A1; “Call our support team”)
To get a better idea, open this Phone Number Google Sheet inside the Sheets app of your Android or iPhone and try clicking any of the phone links.



Comments

Post a Comment

Popular posts from this blog

How to Embed Images from Google Photos into your Website

How to Embed Images from Google Photos into your Website Google Photos is the best service for backing up your digital photos to the cloud. They have no storage restrictions, your can upload images as well as videos, and visual search helps you find photos by people or things in them. There’s one feature though that’s still missing in Google Photos. You can easily share your photos with anyone using a simple link but Google Photos offers no option for you to embed an existing image into a website. That is, if you have already uploaded an image onto Google Photos, you can’t directly embed it into your website through Google Photos. Google Photos as an Image Host Embed Google Photos  is a new web app that, as the name suggests, makes it extremely easy for you to pick any image hosted on Google Photos and place it on a web page using simple HTML code. Here’re the steps involved: Go to  photos.google.com  and open any image that you wish to embed in your w...
Post a Comment
Read more

Let your website seen by other language persons

Let non-English Visitors Read Your Website Imagine someone coming to your site and leaving it the very next moment, not because the content was bad but because the site content was not written in his native language. It is a perfect case of a missed opportunity. Statistics show that the web has just 60% English speaking users. The rest may be from Russia, Japan, the Middle East or other regions, where people are either less comfortable reading English content or can’t read and interpret the language at all. By confining your website to English (or for that matter, just one language), you are missing a large group of people (or site traffic), who could have become potential customers or regular visitors if the website’s content had been written in their native language. Most of the machine translation services like Google Translate, Altavista, Yahoo Babelfish, Lycos are powered by Systran software. So you can choose to incorporate either of these services and the r...
Post a Comment
Read more

How to easily switch your Google accounts

How to Easily Switch between Multiple Google Accounts Lots of us maintain multiple Google accounts for a variety of reasons. Maybe your day is mostly spent inside Gmail and Google Calendar associated with your work account but you prefer to store files inside Google Drive of your personal Google Account. Google does make it easy for you to sign-in to multiple Google accounts simultaneously so you don’t have to log out of one Gmail account to check emails of the other one. Simply go to  accounts.google.com/AddSession  and sign-in with the other Google account inside the same browser session. Sign-in is Easy, Switching Accounts is Difficult One you are logged in, click your profile image in the upper right and select any Google account from the drop down to switch to that account. The default account, the one that appears on top of that list, is the one that you signed in with first. Thus, if you ...
Post a Comment
Read more