The Scenario
The VP of Sales has a board presentation in three days. She needs a pipeline view — all open Salesforce opportunities above $50,000, with account name, stage, amount, and expected close date — so she can build the forecast model in Excel before the deck goes to design. She does not have Salesforce access. She has asked you to get her the data.
You have Salesforce access. You know the data is there. Getting it out cleanly is a different matter.
The bad version:
- Log into Salesforce, navigate to the Opportunities object, try to build a list view that filters for Amount greater than 50000, realize the default columns are not what she needs.
- Export to CSV, open in Excel, discover the column headers are API field names like AccountId instead of account name, and Amount is formatted as a number without currency symbol.
- Spend 30 minutes reformatting, send the file, get a reply 10 minutes later asking why 40 opportunities are missing their close dates.
The board call does not move. The data has to be right, and it has to be in the format she can actually use, not a CSV artifact from a list view that was never designed for this purpose.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It connects to Salesforce, runs the query you describe, and writes the results directly into your workbook — no export, no reformatting, no field name translation required.
Run a SOQL query to get all open Salesforce opportunities with Amount greater than 50000 and write account_name, stage, amount, and close_date to my workbook starting at row 2.
What You Get
- Every open opportunity above $50,000 written to your workbook, one row per record.
- Columns populated with human-readable values: account name (not account ID), stage label, dollar amount, and close date in a consistent format.
- Results start at row 2, leaving row 1 for headers you can add yourself.
- If the query returns more than one page of results, SheetXAI handles pagination and writes all records — not just the first 200.
What If the Data Is Not Quite Ready
You need to filter by stage as well
The VP only wants opportunities in Proposal or Negotiation stage, not everything open.
Run a SOQL query for all Salesforce opportunities where StageName is Proposal or Negotiation and Amount is greater than 50000 — write opportunity name, account name, stage, amount, and close date to my workbook.
You need owner name, not owner ID
The default SOQL result gives you OwnerId. The board wants to see which rep owns each deal.
Run a SOQL query for all open Salesforce opportunities above $50,000, include the owner name from the related User object, and write opportunity name, owner name, account name, stage, amount, and close date to my workbook.
You need to group by region
Region is a custom field on the Account object. The VP wants to see deals broken out by territory.
Run a SOQL query joining Opportunity and Account to get all open opportunities above $50,000 — include the custom field Account.Region__c as region — write region, account name, opportunity name, stage, and amount to my workbook sorted by region.
Pull the data, calculate weighted pipeline, and flag stale deals in one pass
Close dates older than 90 days suggest stale deals. You want a weighted amount column and a flag column added automatically.
Run a SOQL query for all open Salesforce opportunities — write opportunity name, stage, amount, close date, and probability to columns A through E. In column F calculate weighted amount as amount times probability divided by 100. In column G write stale if the close date is more than 90 days in the past, otherwise write current.
One prompt handles the pull, the calculated column, and the staleness flag at once.
Try It
Get the 7-day free trial of SheetXAI and open a blank sheet, then ask it to pull your Salesforce pipeline into the rows. See also how to bulk update opportunity stages from an Excel workbook, or browse the full Salesforce integration overview.