Excel Auto Dialer: List to Calling Campaign in 10 Minutes
By Pushpa Godara · Chief Executive Officer, Wappblaster
In short: Import the Excel as leads (map name, number, source columns; let dedup merge repeats), tag the batch as its own source, then auto dial the segment with the after-call sheet recording outcomes. The list becomes a tracked campaign instead of a sheet of phone numbers someone types one by one.
Somewhere in your business is an Excel file full of phone numbers: the exhibition visitor list, last year’s enquiry register, the export your ad agency sent. Its default fate: someone types numbers into a phone one at a time for a week, or it is quietly forgotten. Here is the ten-minute route from file to running campaign.
Step 1: Make the file boring (2 minutes)
Importers fail on creative spreadsheets, so flatten yours: one header row, one lead per row, no merged cells or summary rows. Three columns matter: name, mobile number, and ideally a source or note column (“Expo 2026”, “Old enquiry: kitchen”). Number formatting is the classic trap: Excel loves turning 9876543210 into 9.87654E+09, and mixed formats like +91-98765 43210 abound. A good importer normalises Indian numbers on the way in; if yours has already mangled digits into scientific notation, re-export from the original.
Step 2: Import and map columns (3 minutes)
In RMDialer, the importer takes CSV, Excel or JSON: pick the file, map your columns to lead fields (extra columns like budget or city can land in custom fields), and import. Two settings deserve attention:
- Source tag. Give the whole batch its own source (“Expo-2026”). This single tag is what later tells you whether the exhibition was worth the stall fee.
- Duplicates. Old lists overlap with people already in your data. Dedup by number should merge, not duplicate, so an existing customer does not get a cold pitch from a rep who cannot see their history.
If the “file” is actually a living Google Sheet your agency keeps filling, skip manual re-imports: connect the Sheet and new rows become leads automatically.
Step 3: Fire the campaign (5 minutes)
The imported batch is now a filterable segment, and a segment can be worked:
- (Optional but wise) announce first. A short template introduction on WhatsApp an hour before calling turns cold dials into half-warm ones; on old lists it also flushes out the “who are you?” replies cheaply.
- Auto dial the segment. Pick the list, choose the SIM and the gap between calls, press start. No number gets typed by a human today.
- Outcomes in two taps. The after-call sheet records interested / not / call-back per lead as you go, which is the difference between a campaign and an activity that leaves nothing behind.
- The machine handles the aftermath. Interested leads get details by WhatsApp automatically; call-backs become reminders that ring; no-answers roll into a redial list for a different hour.
What you know at the end (that Excel never told you)
By evening the campaign has numbers: dialed, connected, interested, follow-ups booked, per rep if the list was split across a team. Next week, “Expo-2026” as a source shows its conversion against your Facebook and walk-in leads, which is what decides next year’s stall. The same file that would have been a week of typing and a month of guessing became a measured campaign in an afternoon, and the leads it produced now live where every future call will keep their story, not in row 214 of a sheet nobody will open again.
The tool this walkthrough assumes is the RMDialer Excel auto dialer: import the sheet, press Start, and it calls the list from your own SIM with the after-call sheet between calls. The auto dialer page covers the settings, and the bulk calling app page covers the same job for pasted lists.
- auto dialer
- lead sources
- guide