The Scenario
You are a fraud prevention analyst. Your team identified 250 known robocall and spoofed numbers over the past two weeks. They are sitting in an Excel workbook, column A of the "Spam Numbers" tab.
The Monday morning calling window opens at 8 AM. If those numbers are not blocked by then, your contact center agents will spend the first hour of the week fielding spam calls instead of working the queue.
It is Friday at 4 PM.
The bad version of Friday afternoon:
- You open the Dialpad admin portal and navigate to the blocklist
- You find the add-number field and paste the first number
- You repeat 250 times, one number at a time
- The portal times out after 40 minutes and you lose your place
- Monday morning arrives with 180 numbers still unblocked.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads your fraud list and submits the entire blocklist batch to Dialpad in one operation.
Open the SheetXAI sidebar and type:
Read the "Spam Numbers" tab (column A = phone numbers). Format all numbers to E.164 and add them to the Dialpad blocked list in one batch. Write "BLOCKED" into column B for each success and "ERROR: [reason]" for any failure. Put a count of successfully blocked numbers in cell D1.
SheetXAI reads the column, normalizes the formats, submits the batch to the Dialpad blocklist API, and writes a status into column B for every row. Cell D1 shows the total count. You have a full audit log in the workbook before you close your laptop.
What You Get
A workbook where column B is fully populated with outcomes:
- "BLOCKED" for every number successfully added
- "ERROR: [reason]" for anything that failed, with the failure reason inline
- A total count in D1 so you can confirm the operation at a glance
You do not enter the Dialpad portal once. The entire operation runs from Excel. If 12 numbers fail because they are already on the list, you know exactly which 12 without going back into the portal.
What If the Data Is Not Quite Ready
Fraud lists from multiple sources are rarely in clean E.164 format. SheetXAI normalizes and blocks in the same prompt.
When number formats are inconsistent
Your workbook has a mix of (415) 555-1234, 415-555-1234, and +14155551234 in the same column.
Normalize all phone numbers in column A to E.164 format and write the normalized version into column C. Then add all of them to the Dialpad blocked list and write the status into column B.
When you only want to block numbers that appear more than once
Your fraud team flagged that single-occurrence numbers may be false positives.
Count how many times each phone number appears in column A. Write the count into column B. Then add only numbers with a count of 2 or more to the Dialpad blocked list and write the status into column C.
When the list came from multiple tabs and needs deduplication first
The Phishing tab has 100 numbers, the Robocall tab has 180, and there is overlap.
Combine all phone numbers from the Phishing tab (column A) and the Robocall tab (column A) into a single deduplicated list on a new tab called "Block Queue." Normalize all numbers to E.164. Then add every number on the Block Queue tab to the Dialpad blocked list and write the status in column B.
When you want to write the normalized list back and confirm the block in one pass
Your security team wants the final E.164 list as the permanent record, not the original messy numbers.
Normalize all phone numbers in column A to E.164 and overwrite column A with the normalized values. Then add every number to the Dialpad blocked list and write "BLOCKED" or "ERROR: [reason]" into column B. Put a count of successful blocks in cell E1.
The pattern: instead of cleaning the list first and then running the blocklist job, you describe the cleanup and the action in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open your next fraud number list in Excel, then ask it to add the entire column to the Dialpad blocklist. The Dialpad integration is included in every SheetXAI plan. For related workflows, see how to audit call labels and usage in Excel or the Dialpad in Excel overview.