Excel Copilot Data Connectors in 2026: Pull Financial and Business Data From FactSet, PitchBook, HubSpot and More
If you spent last year exporting CSVs from FactSet, copy-pasting deal data out of PitchBook, or manually re-typing HubSpot pipeline numbers into a workbook, 2026 is the year you can stop. Microsoft has quietly turned Excel into a live dashboard that reaches directly into the platforms your business already runs on — no exports, no macros, no third-party add-ins duct-taped together.
The June 2026 wave of Copilot in Excel updates added a fresh batch of data connectors covering both financial research and everyday business tools: CB Insights, Daloopa, FactSet, Morningstar, PitchBook, and S&P Global on the financial side, plus HubSpot, Intercom, Linear, Notion, Canva, Google Calendar, and Google Contacts for teams that live in a broader software stack. Here's what actually changed, and how to put it to work today.
What a Copilot Data Connector Actually Does
A data connector is a licensed, authenticated bridge between a cell in your workbook and a live external source. Instead of pasting a static number, you reference a company, ticker, contact, or record, and Excel fetches structured, refreshable data — the same way STOCKHISTORY or the old Stocks data type worked, but now extended to a much wider set of business platforms.
The data lands as a rich data type, meaning a single cell can carry an entire record (name, revenue, funding round, deal stage) that you expand into columns with a simple field reference or the FIELDVALUE function. Refresh it, and every formula downstream updates automatically.
The New Financial Research Connectors
This update is aimed squarely at analysts, investment teams, and finance functions that previously relied on manual downloads or Bloomberg-style terminals sitting outside of Excel.
CB Insights — private company data, funding history, and market intelligence pulled straight into a workbook.
Daloopa — standardized financial statement data sourced directly from company filings, ideal for building comparable company models without manual transcription.
FactSet — broad market, fundamentals, and estimates data for equity research and portfolio analysis.
Morningstar — fund, ETF, and equity research data for wealth management and personal finance workflows.
PitchBook — private equity and venture capital deal data, valuations, and ownership structures.
S&P Global — credit ratings, index data, and macroeconomic indicators.
The New Business and Productivity Connectors
Not every team is building a DCF model. The same update brought connectors for the tools that run day-to-day operations, so Excel becomes a reporting layer on top of your existing systems rather than a separate silo.
HubSpot — pull deal stages, contact records, and pipeline values into a workbook for custom reporting HubSpot's own dashboards don't cover.
Intercom — bring support conversation and ticket data into Excel for volume and response-time analysis.
Linear — surface issue status, cycle progress, and engineering throughput for leadership reporting.
Notion — reference database records and pages without re-keying project data.
Canva — connect design assets and brand kit references for marketing operations trackers.
Google Calendar and Google Contacts — useful for teams on a mixed Microsoft/Google stack who still want scheduling or contact data inside their Excel reporting.
How to Connect a Data Source, Step by Step
Type a company name, contact, or record identifier into a cell (for example, a company name for PitchBook or FactSet).
Go to the Data tab and select Data Types, then choose the relevant connector, or let Excel auto-detect it and show the data type icon in the cell.
Click the data type icon and select “Insert Data” to expand specific fields (revenue, last funding round, deal stage) into adjacent columns.
Use FIELDVALUE(cell, "field name") if you want to reference a specific attribute without expanding the whole record.
Set your workbook to refresh automatically, or refresh manually from Data > Refresh All before every reporting cycle.
Putting It Together With GROUPBY and PIVOTBY
Live connector data pairs naturally with Excel's newer array functions. Once PitchBook or FactSet data is populating a table, GROUPBY and PIVOTBY can summarize it by sector, stage, or region without you ever touching a PivotTable dialog box. Since the underlying data type refreshes on its own, your summary formulas recalculate the moment new figures come through — turning a one-time export into a living report.
A Few Practical Use Cases
A finance analyst building a comparable-company model pulls live fundamentals from FactSet and Morningstar side by side, instead of juggling two separate terminal exports.
A sales operations lead builds a pipeline health tracker that references live HubSpot deal stages, refreshed every morning before the team stand-up.
An engineering manager builds a lightweight capacity report pulling Linear cycle data next to headcount figures already in the workbook.
A marketing coordinator keeps a campaign asset tracker linked to Canva so nobody is hunting for the latest approved file.
Licensing and Access Notes
Most of the financial connectors (FactSet, PitchBook, Morningstar, S&P Global, CB Insights, Daloopa) require an active subscription with that provider in addition to your Microsoft 365 Copilot license — Excel provides the pipe, not the underlying data rights. Business connectors like HubSpot and Notion typically authenticate through your existing account permissions, so check with your admin if a connector doesn't appear in your Data Types menu.
Final Thoughts
The bigger shift here isn't any single connector — it's that Excel in 2026 no longer expects you to import your business data. It expects your business data to already be there, live, the moment you open a workbook. If your team is still exporting CSVs from FactSet or PitchBook by hand, this is the update that makes that workflow obsolete. Open Data Types, connect your first source, and build a report that updates itself.
