Word, Excel & PowerPoint Rolling out #299

Get and transform data with Copilot in Excel

Prepare Excel data by describing what you need

Microsoft is rolling out a get data skill in Copilot in Excel, with general availability targeted for October 2026. Users describe the data they need and how they want it prepared.

Key points

  • The skill connects to data, transforms it, and loads the results into a workbook using Power Query.
  • The resulting query can be inspected, edited, and refreshed.
  • Authentication may be required, depending on the data source.
  • The rollout covers Excel on Web in Worldwide (Standard Multi-Tenant).

What to do

Show users how to describe both the data they need and the preparation steps. Explain that they can inspect, edit, and refresh the resulting Power Query query. Tell users that some data sources may require authentication.

Timeline

  1. October 2026 General availability (planned, not confirmed) Microsoft 365 Roadmap target: General availability target for Excel on Web worldwide.
  2. 26 October 2026 Published
Speaker notes

This skill lets users describe a data preparation task instead of building the query themselves. Copilot connects to the data, transforms it, and loads the results into the workbook using Power Query. The resulting query remains available for inspection, editing, and refresh. Authentication may still be required for the selected data source. The stated scope is Excel on Web in Worldwide (Standard Multi-Tenant). Microsoft lists the feature as rolling out, with an October 2026 general availability target, but does not confirm rollout completion.

Sources and links

Area, status, change type, licence and flags are indicative. Always open the source before you act on a card.