How to call directly from Google Sheets, and how RMDialer calls the whole sheet

This needs no add-on, no extension and no account, and it is the right answer for a short list. Five minutes end to end.

Step 1. Get the numbers into a callable format. Store each number as digits with the country code and nothing else: +919876543210, not +91 98765-43210. Spaces, dashes and brackets are the single most common reason a tel: link does nothing when tapped. If your column came from an export and has formatting in it, clean it with =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2," ",""),"-",""),"(","") or simply Find and replace across the column. Also watch for Sheets stripping a leading zero or converting a long number to scientific notation: format the column as Plain text (Format, then Number, then Plain text) before pasting.

Step 2a. One number, by hand. Click the cell, press Ctrl+K (Cmd+K on a Mac), and enter tel:+919876543210 as the link target. Ctrl+K is simply the insert-link shortcut in Google Sheets; there is nothing calling-specific about it. The tel: prefix is what tells a device to hand the number to its dialer rather than treating it as a web address.

Step 2b. A whole column, with a formula. In an empty cell beside the first number enter =HYPERLINK("tel:"&A2, A2), then drag the fill handle down the column. Replace A2 with whichever cell holds your number. Every row now shows a tappable version. If you would rather see the person’s name than the digits, use =HYPERLINK("tel:"&B2, A2) with names in A and numbers in B.

Step 3. Open it on a phone, not a desktop. This is the step people skip and then conclude the method is broken. A tel: link on a desktop does nothing unless a softphone is installed and registered to handle it. Open the sheet in the Google Sheets app on Android, tap the link, and the dialer opens with the number filled in. You still press the green button; a tel: link never places a call by itself.

Step 4. Share it correctly. If colleagues will call from the same sheet, share with at least Viewer access. The links work for anyone who can open the file. Note what this does not give you: two people tapping the same sheet have no way of knowing the other already rang that number, which is the first thing that breaks once more than one person is calling.

HYPERLINK exists in Excel with the same syntax, so =HYPERLINK("tel:"&A2, A2) works there too, and Ctrl+K inserts a link in Excel exactly as it does in Sheets.

The difference is what happens when you tap it. Excel on Android and iOS handles tel: links and opens the dialer; Excel on a desktop hands the link to whatever application is registered for tel:, which on most business machines is nothing at all. So the practical requirement is identical: the file has to be open on the phone.

If your list arrives as an .xlsx attachment, which in Indian business it very often does, the fastest free route is to open it in the Excel or Google Sheets mobile app, add the formula column there, and tap down the list. For anything past a few dozen rows, uploading the file to a dialer is less work than maintaining the formula column.

Everything above still leaves you doing the same four things after every call: return to the sheet, find your place, type the outcome, and tap the next link. RMDialer removes that loop rather than speeding it up.

Connect the sheet once. Paste the Google Sheets link into RMDialer, map which column holds the name, the number, the city or anything else you keep, and choose who the leads go to. Sharing is by link as a viewer, so no Google account is connected. From that point the sheet is a live source rather than a file you export.

The list then dials itself. Tap Start and RMDialer places the first number, and the next the moment that call ends. No returning to the sheet, no scrolling, no losing your place at row 340.

The record writes itself. When a call ends an outcome sheet appears on the call screen: a status, a remark you can dictate rather than type, and a callback date. Two taps, and the next number is already ringing. That is the column you were maintaining by hand, filled in without leaving the call.

New rows arrive on their own. Anything added to the sheet afterwards becomes a callable lead automatically, assigned round-robin. If your ad platform or website form already writes into that sheet, you now have automated lead capture with no integration work.

And because RMDialer dials through the SIM in the handset, the person you are calling sees your ordinary mobile number, exactly as they would if you had tapped the link yourself. The mechanism is on the SIM-based dialler page.

It does not break; it just becomes slower than the work it was meant to save. The ceiling arrives at around thirty numbers for most people.

The loop is the problem. Tap the link, make the call, end the call, return to Sheets, find your place in a list that has scrolled, type what happened in a column beside it, then scroll to the next row. That is fifteen to twenty seconds of handling per call plus the risk of losing your place, and it degrades as the list grows rather than staying constant.

Three specific things also cannot be done at all. You cannot see who you are calling before they answer, because the sheet is behind the dialer once the call connects. You cannot be reminded to call someone back on Thursday. And if two people work the same sheet, nothing stops both ringing the same person.

For a list of twenty enquiries, none of that matters and you should use the free method. For two thousand, all of it does.

The alternative to tapping links is to let the sheet feed a dialer. RMDialer connects to a Google Sheet once, maps the columns, and new rows become callable leads on their own, assigned round-robin across whoever you nominate.

That distinction between connecting and exporting matters more than it sounds. A one-time CSV export is a snapshot: rows added afterwards are invisible until someone remembers to export again, which is how leads sit unworked for a fortnight. A connected sheet has no such step. If your ad platform, website form or lead portal can write to a sheet, and most can, you now have automated lead capture without an integration project.

The sync report shown above is from a real batch: 184 rows received, 174 imported, 6 updated, 2 skipped as duplicates and 2 rejected for invalid numbers. Duplicates updating rather than doubling is what stops one customer appearing four times with four different statuses.

Not every list lives in Google Sheets, and the same approach covers the others.

An Excel file or CSV uploads directly, with the column mapping remembered so the next file from the same source imports without repeating the setup. JSON works too for anyone exporting from another system.

The case worth calling out is a file shared to you on WhatsApp, because in Indian business that is how a very large share of lists actually change hands. RMDialer imports one directly from the share sheet rather than requiring you to save it, find it in Downloads and upload it, which is three steps where lists commonly get lost.

Whichever route the list takes, what arrives is the same: callable leads with statuses, notes and follow-up dates, described on the lead management page.

Use the free HYPERLINK method if your list is short, you are calling from one phone, and you do not need to record what happened in any structured way. It costs nothing and it works.

Use a connected dialer if the list runs to hundreds, if more than one person calls from it, if rows keep being added, or if you need to know which numbers were called and what the outcome was. The bulk calling app page covers the dialling side of that.

The honest test is whether you are currently losing more time to the sheet than the sheet is saving you. Most people can answer that immediately.