Friday 10 March 2017

How to Make Phone Numbers Callable in Google Sheets

Learn how to insert phone numbers inside Google Spreadsheets and make the numbers clickable and callable on mobile phones. 

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.


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.
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. 


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.

0 comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...

Labels

404 AdBlock Add-on Airtel GPRS Trick Airtel SMS Trick Alexa Amazon Amazon Kindle Amazon Prime Android Android 8 Android Oreo antivirus Apple Apple Mac ASCII Audacity Audio Authotkey Backup Balance Transfer in Vodafone Battery Bing Blogger Blogging Bookmarklet Browser Camera Chromebook clock Cloud colors command lines Computer Computer Tricks configuration Contact Creative Commons Credit Card CSS devolop DIY Doodle DOS Download Dropbox E-Mail eBook Email Email Attachment Embed Encryption English Error Evernote Eyes Facebook Facebook Tricks Feedburner Flipkart Font Foursquare Free Internet Free sms trick in Vodafone G Mail Gadget Game Getty Images GIF Gists Github Google Google AdSense Google Analytics Google Apps Google Chrome Google Contacts Google Currents Google DNS Google Docs Google Drive Google Earth Google Font Google Forms Google Images Google Map Google Photos Google Play Store Google Plus Google Print Google Reader Google Script Google Sheets Google Spreadsheet Google Translate GPRS Setting GPS Hacking Health App HelloFax Hindi Hoodie HTML Icons idea Image Editing Images IMEI Indian Railways Infographics Instagram Internet Internet Explorer Internet Tricks iOS iPad iPhone IRCTC iTunes iTV JavaScript JioCinema JioTV Junglee Kindle Language Translation Laptop Laptop. TV Life Time FREE GPRS Life-Style Link Linkedln Linux logo Make Money Online Microdoft Powerpoint Microdoft Word Microsoft Office Microsoft Outlook Mobile Mosaic Music Name Networking nexus Notepad OCR Online Shopping Open DNS OS Outlook Password PDF Petya Phillips Hue Lights Photogtraphy Pixel Play Station Podcasts Pokemon Pokemon Go Polls Print Productivity Proxy Server Pushbullet QR Code Ransomware Reddit Reliance Hack GPRS Reliance Jio RGB Ringtone Router RSS Safe Mode Samsung Galaxy S Scrabble Screen Capture Screen Sharing Screencast Secrets Security Send free sms from PC SEO Sierra Skype Slideshare SMBv1 SMS Snapchat Snapdeal Social Media Solution Sound Device Speech Recognition Sql Steam Sync Synology NAS Tata Docomo GPRS trick Teleprompter Torrent Trick Tricks TV Twitter UltraISO Unicode Unknown Extension Unlimited 2GB Unlimited 3GB Unlimited GPRS USB USB Security Key Video Editing virtual desktop Virus attack VLC Vodafone 110% working trick for GPRS Vodafone 3g Vodafone GPRS VPN wallpapers WannaCry Web Design Web Domain Website Wget Whatsapp WiFi Wikipedia Windows Windows 10 Windows 10 S Windows KN Windows Tricks windows updates Winows N Wolfarm Alpha WordPress XBox YouTube Zip
Twitter Delicious Facebook Digg Stumbleupon Favorites More