The Scenario
You are a business development manager. The board approved the new services line last week and you now have 40 qualified prospects in an Excel workbook, sourced from a LinkedIn outreach campaign. Columns: deal name, estimated value, party name, notes.
Your target: every one of those 40 prospects entered into Capsule CRM as an opportunity at the Proposal milestone, ready for the team to assign owners and start working, before Monday's kickoff call.
It is Friday afternoon.
The bad version of Friday:
- You open Capsule and start creating opportunities manually
- The Capsule CSV import does not support setting a milestone on import — you would have to update each one after
- You enter twelve deals, lose your place, re-open the workbook to check the next row
- Someone sends you a Teams message. You come back and enter the wrong value for the next deal.
- You finish 25 of 40 before giving up and deciding to do the rest on Monday.
Monday's kickoff call starts with half the pipeline missing.
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 qualified-lead rows and creates Capsule CRM opportunities at the right milestone, without touching the UI.
Open the SheetXAI sidebar and type:
Create a Capsule CRM opportunity for each row in this workbook. Use the deal name in column A, value in column B, and party name in column C. Set the milestone to Proposal for every opportunity. Write the new opportunity ID back to column D.
SheetXAI reads all 40 rows, creates the opportunities in Capsule, sets the milestone to Proposal on each one, and writes the IDs back to column D.
What You Get
40 Capsule CRM opportunities at the Proposal milestone, created from the workbook:
- Opportunity ID in column D — for cross-referencing and follow-up lookups
- Milestone set on creation — no second-pass update needed
- Party name linked — Capsule associates the opportunity to the existing party record if found by name
Your team can start assigning owners and scheduling follow-up activities in Capsule immediately.
Want to also attach the notes from column E to each opportunity as a Capsule note? Add it to the prompt.
What If the Data Is Not Quite Ready
Qualified-lead workbooks from outreach campaigns are rarely clean.
When deal names have duplicates from multiple outreach threads
The same prospect appears twice because two reps worked the same LinkedIn search independently.
Deduplicate rows in this workbook by party name in column C — keep the row with the higher value in column B. Then create a Capsule CRM opportunity for each remaining row at the Proposal milestone. Write the opportunity ID to column D.
When values are in mixed currencies
Some deals are in USD, some in GBP, some blank. You want them all standardised to GBP before they go into Capsule.
Normalise the values in column B to GBP using today's exchange rates. Where the value is blank, set it to 0. Then create a Capsule CRM opportunity for each row at the Proposal milestone, using the normalised value. Write the opportunity ID to column D.
When some party names do not exist in Capsule yet
A handful of prospects are brand new — they are not in Capsule as parties yet.
For each row in this workbook, check if a Capsule CRM party exists for the name in column C. If not, create the party first using column C as the name and any email in column E. Then create the opportunity at the Proposal milestone. Write the opportunity ID to column D.
When you want each opportunity scoped by deal size before entering Capsule
Small deals go in at Qualified, medium at Proposal, large at Negotiation.
For each row: if the value in column B is under £5,000 set the milestone to Qualified; if between £5,000 and £20,000 set to Proposal; if above £20,000 set to Negotiation. Create a Capsule CRM opportunity for each row with the appropriate milestone. Write the opportunity ID and the milestone used to columns D and E.
The pattern: qualification logic that used to be a separate step happens inside the same prompt.
Try It
Get the 7-day free trial of SheetXAI and open any workbook of qualified prospects, then ask it to create Capsule CRM opportunities for each row. The Capsule CRM integration is included in every SheetXAI plan. For related workflows, see how to bulk-update opportunity milestones after a review or the Capsule CRM in Excel overview.