The Scenario
You are the data manager at a Square merchant with a mid-size customer database. Three weeks ago, a test import created 150 duplicate customer records — test profiles scattered through your customer directory, polluting segments, loyalty group counts, and email lists.
You have identified the duplicate customer IDs. They are in column A of an Excel workbook, 150 rows. You need them gone.
The manual version:
- Log into Square's Customer Directory
- Search for the first customer ID
- Click into the profile, confirm it is the test duplicate
- Click Delete, confirm
- Go back, repeat
- At 90 seconds per record, that is 225 minutes. You do not have 225 minutes.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads the IDs in column A and deletes each Square customer profile, writing a result back per row for a full audit log.
Open the SheetXAI sidebar and type:
Delete every Square customer whose ID is listed in column A of this workbook. Write "Deleted" into column B for each successful deletion, or the error message if it failed.
SheetXAI calls Square's bulk delete endpoint, processes all 150 IDs, and writes the result into column B. Successfully deleted rows show "Deleted." Errors show the specific message — typically "Customer not found" if already removed, or a conflict if the customer has active orders.
What You Get
A workbook with 150 rows resolved:
- Column B: "Deleted" for every profile removed from Square
- Column B: error message for any ID Square could not delete — not found, active order conflict, etc.
- Complete audit trail — you know exactly which records were removed and which were not
The errors are immediately useful. If 6 IDs failed because they have pending orders, you have a specific list to review in Square rather than guessing which ones remain.
What If the Data Is Not Quite Ready
Duplicate removal lists have common complications. SheetXAI handles them in the same prompt.
When some IDs are already deleted
A partial cleanup removed some of them earlier. You do not know which.
Delete every Square customer whose ID is in column A. Write "Deleted" into column B for successful deletions. If the customer is not found (already deleted), write "Already removed." If any other error, write the error message.
When you want to preview before deleting
You are not 100% confident the list is correct and want to verify each ID is a test record first.
For each customer ID in column A, retrieve the Square customer profile and write their name, email, and creation date into columns B, C, and D. Do not delete anything yet.
Review, mark confirmed test records with "DELETE" in column E, then re-run:
Delete every Square customer whose ID is in column A where column E says "DELETE." Write the result into column F.
When you need to skip IDs with associated orders
You want to avoid accidentally deleting a real customer who ended up on the duplicate list by mistake.
For each customer ID in column A, check whether they have any associated Square orders. If they have no orders, delete them and write "Deleted" into column B. If they have orders, skip them and write "Skipped — has orders" into column B.
When you need to delete, verify, and report the final count in one shot
Your manager wants a clean summary: how many deleted, how many already missing, how many errors and why.
Delete all Square customers in column A. Write the result per row into column B. Then below the data, add a summary section showing: total deleted, total already missing, total errors with error types listed.
The pattern: the audit log in column B is the proof the cleanup ran correctly — your data manager will ask for it.
Try It
Get the 7-day free trial of SheetXAI and clean up your Square customer directory from the workbook you already have. The Square integration is included in every SheetXAI plan. For related workflows, see how to bulk-import customers into Square from Excel or the Square in Excel overview.