Microsoft has begun rolling out a Copilot feature for Excel that fundamentally changes how data gets into your spreadsheets: you can now ask the AI assistant to find and import tables, lists, and facts directly from the web, Word documents, PowerPoint presentations, and PDFs — all using plain English. The capability, which is landing first for Microsoft 365 Insiders and licensed Copilot for Microsoft 365 subscribers, will soon reach Excel for the web, closing a long-standing gap between desktop and browser-based users.

What Actually Arrived

Three concrete updates hit Excel alongside this rollout, and together they remove some of the most stubborn friction in day-to-day spreadsheet work.

Pulling data from anywhere you keep it

Until now, bringing a table from a quarterly PDF report or a colleague’s slide deck into Excel meant either manual copy-paste or navigating Power Query’s interface. Copilot flips that. Type a command like “Get the revenue table from the March board deck” or “Import the exchange rate table from the web for USD to EUR,” and the assistant scans your permitted sources — SharePoint, OneDrive, and the web if your tenant allows it — then surfaces matching results. A single click pulls the structured data into your sheet.

According to Microsoft’s support documentation, Copilot identifies tables, lists, and other organized facts inside Word files, PowerPoint slides, and PDFs stored in the cloud. It is not just pulling metadata; it extracts the actual contents. For teams that still rely on PDFs and slide decks to circulate numbers, this alone can save hours per reporting cycle.

Where possible, Copilot sets up a refreshable connection behind the scenes, much like a Power Query link. That means your imported table is not a one‑off snapshot — you can update it later to reflect changes in the source. This works best when the source is an Excel table already stored in OneDrive or SharePoint, but Microsoft has signaled that refresh semantics will expand over time. For now, treat any import from a non‑Excel format as a candidate that may need manual refresh until you confirm the link type.

Faster access via a new Copilot button

The assistant also gets a more convenient entry point. A Copilot icon now appears near the selected cell and on the ribbon, letting you jump straight into a data prompt without digging through menus. It is a small UX change, but it shortens the distance between thinking of a query and seeing the result, and it is available on both the desktop and web versions.

How It Changes Your Workflow

The impact varies sharply depending on your role.

For business analysts and data teams: The biggest win is time. Extraction from PDFs, slide decks, and even older Word reports has been a manual chore that introduces errors. Copilot’s import capability turns that into a conversational step. After the data lands, you can immediately apply formulas, PivotTables, or even Copilot‑generated visualizations. If your organization also has Python in Excel, you can pipe imported data directly into advanced analyses — all without leaving the workbook.

For IT administrators: Governance becomes the priority. Because Copilot can reach into organizational files and — if enabled — the public web, you need to lock down what it can access. Microsoft 365 tenant controls let you enable or disable web search for Copilot, and you can limit which SharePoint sites or OneDrive accounts the assistant can scan. Audit trails are still maturing, so you should establish a process now: require users to document their prompts and sources, save workbook versions after each import, and verify that no sensitive data leaks into shared spreadsheets.

For small teams and home users: The feature is gated behind a Microsoft 365 Copilot license. If you are on a standard Microsoft 365 plan, you will not see these import options. Even with the right license, you may need to be in the Insiders channel to get early access; general availability for production tenants will follow after the staged rollout completes. Check your Microsoft 365 admin portal or update policy to see when it reaches your rings.

The Road to Smarter Imports

Excel has always been the landing pad for ad‑hoc data, but the journey to get data into the program has been stuck in 2010. Power Query gave power users a robust ETL toolkit, yet it remains inaccessible to many. Microsoft’s Copilot bet is that plain language can close the gap.

This import feature is not an isolated bolt‑on. Over the past year, Excel has gained natural‑language formula generation, a dedicated COPILOT function for in‑cell AI operations, Python integration, and an Agent Mode that can plan multi‑step automations. Importing data connects these pieces: you fetch the numbers from a PDF, run a Python script on them, then ask Copilot to summarize trends — all in a single workbook.

It also marks a meaningful step toward parity between Excel for the web and the desktop app. For a long time, browser‑based users could not touch advanced import tools. Now, staged rollout means web users will get the same Copilot‑driven ingestion as their desktop colleagues. That matters for distributed teams that live inside the browser.

Steps to Take Now

If you have a Copilot license and the feature has hit your build, here is how to start — and how to avoid the biggest pitfalls.

  1. Check your license and build. Copilot import requires a Microsoft 365 Copilot add‑on or an eligible business subscription. Insider builds get the feature first; confirm your update channel in the Microsoft 365 admin center.
  2. Set tenant guardrails. In the Microsoft 365 admin portal, review Copilot’s web search and data access policies. Restrict web scraping if your data governance framework requires it, and define which organizational repositories Copilot can scan.
  3. Craft prompts with precision. Vague commands yield vague results. Instead of “get the sales table,” try: “Import the sales table from ‘Q4_Report.docx’ stored in /Shared/Finance, and include Date, Region, and Revenue columns.” Add “Show tables to import” if you want to preview before pulling.
  4. Validate everything before relying on it. Copilot can hallucinate or misinterpret ambiguous structures. After import, scan for blank cells, date conversion quirks, and number formatting issues. Compare a few rows against the original source manually. Microsoft itself warns that Copilot outputs are assistance, not authoritative — and for financial or legal numbers, human verification is mandatory.
  5. Build an audit trail. Save a version of the workbook immediately after each import. Note the prompt you used, the source file path or URL, and whether a refreshable connection was created. This is essential for regulated industries.
  6. Pilot with a small team first. Before rolling out broadly, let a group of trusted users test typical import scenarios. Learn where the feature breaks down — complex PDFs with nested tables are often tricky — and create a quick reference guide for common errors.

What’s Next

Microsoft’s roadmap suggests this is only the beginning. Refreshable imports will expand beyond Excel‑formatted tables to more file types, and the Copilot entry points will become more contextual — perhaps suggesting imports when it detects a relevant file in your conversation history. The company is also weaving Copilot into other Office apps, so expect similar “fetch and import” patterns in tools like Word and OneNote.

For now, the immediate value is clear: the era of re‑typing numbers from a PDF into a spreadsheet is coming to an end. But the responsibility to verify and govern that data lands squarely on the human at the keyboard. Get your pilot, your prompts, and your policies in order, and this update will pay for itself in reclaimed hours.