No, not reliably, and not in the way people expect. Copilot in Excel works on data that is already sitting in your worksheet. It does not open PDFs, it does not import them, and Microsoft does not document any supported path that takes an arbitrary PDF table and hands you back a correctly typed spreadsheet.
That answer surprises people, because Copilot is genuinely good at a lot of spreadsheet work, and because Microsoft 365 Copilot chat will happily read a PDF and print a table into the conversation. It looks like the feature exists. It mostly does not. Here is what is actually there, what Microsoft says about it, and what to use instead.
What does Copilot in Excel actually do?
It analyzes, summarizes, formats, and writes formulas against data already in the worksheet. Ask it to build a PivotTable, highlight outliers, add a column with a formula, or explain a trend, and it does that well. Everything it touches has to already be in the file.
Microsoft's own requirements make the boundary clear. Copilot in Excel needs a qualifying license, the workbook must be saved to OneDrive, OneDrive for Business, or SharePoint with changes saved automatically, and the file must be a modern Open XML format such as .xlsx rather than a legacy binary. Microsoft also publishes a page called Format data for Copilot in Excel, which asks you to format your data as an Excel table or a supported range before Copilot will work with it properly.
Read that requirement again. Copilot wants a clean, structured table as its starting point. Converting a PDF into a clean structured table is the entire problem you were trying to solve.
| Task | Copilot in Excel | Copilot chat | Power Query From PDF | PDF converter |
|---|---|---|---|---|
| Open or import a PDF | No | Reads it as input | Yes | Yes |
| Return a downloadable .xlsx of a PDF table | No | Not documented | Yes | Yes |
| Handle a scanned PDF (needs OCR) | No | No | No | Yes |
| Analyze data already in the sheet | Yes | Limited | No | No |
| Works on Excel for Mac | Varies | Yes | No | Yes, any browser |
Can I attach a PDF to Copilot chat and get a spreadsheet back?
You can attach the PDF. Microsoft's supported file formats page confirms Copilot accepts PDFs as input and can pull content from them, so it will summarize the document, answer questions about it, and often render a table of values directly in the chat window. Microsoft has also shipped file creation flows in the Microsoft 365 Copilot app that generate Word, Excel, PowerPoint, and PDF files from a chat.
What Microsoft does not document anywhere is the specific thing you want: feed in an existing multi page PDF table, receive a faithful, correctly typed .xlsx of that exact table. The file creation feature generates a new spreadsheet from a prompt. That is a different operation from high fidelity extraction, and the two get conflated constantly in write-ups that claim Copilot converts PDFs to Excel.
So the honest status is: undocumented, unsupported, and inconsistent in practice. Sometimes you get a beautiful table. Sometimes you get a beautiful table that is missing four rows.
How accurate is Copilot at reading tables from a PDF?
Microsoft will not tell you, because Microsoft has not published accuracy figures or row limits for this. What it has published is a warning and a workaround, and both are worth reading as what they are.
The warning, from the Copilot in Excel FAQ: Copilot uses AI to generate suggestions and can sometimes make mistakes, misinterpret information, or produce inaccurate results, and you should review, edit, and verify anything Copilot creates before you rely on it. Microsoft specifically calls out finance, legal, and medical contexts. The workaround, from the supported file formats guidance: if you have a very long document, large PDF, or spreadsheet with many formulas, consider splitting it into smaller documents.
That second line is a company telling you, politely, that reliability degrades with size. And the failure modes of language model table extraction are not random noise, they are specific: rows get silently dropped, columns transpose, a number formatted as (1,234) becomes positive 1234, a currency symbol gets absorbed into the value so the cell is text instead of a number. None of these announce themselves. The output looks like a table because the model is very good at producing things that look like tables.
For a summary of a report, that is fine. For a trial balance that has to tie, it is not. The difference is not how smart the model is. It is that an extractor reads the coordinates of the text on the page and rebuilds the grid, while a chat model reads the text and writes a new grid that resembles it. Only one of those is reproducible. If you are checking any converted file, our conversion error checklist takes about a minute and catches nearly all of this.
What is Excel's built-in way to convert a PDF?
Power Query, and it has nothing to do with Copilot. Go to Data, then Get Data, then From File, then From PDF. Excel opens a Navigator showing the tables it detected, you pick one, and you Load or Transform it. Microsoft documents this as the Power Query PDF connector.
Three limits matter before you rely on it:
- Windows only, in practice. It is in Excel for Windows on Microsoft 365 and Office 2019 or later. It is not in Excel for the web, whose connector list is much shorter, and it is effectively absent from Excel for Mac.
- No OCR. The connector reads the PDF's text layer. A scanned page or a photographed document has no text layer, so the Navigator finds nothing at all. This catches people out constantly, because the file opens fine in a PDF reader.
- Multi page tables need cleanup. Microsoft's own limitations section points you at the MultiPageTables option, StartPage and EndPage for large files, and Table.FillDown and Table.Group for rows that wrap across lines.
Within those limits it is genuinely good, it is free, and it refreshes. If you are on Windows with a clean digital PDF, try it first. Our walkthrough of converting a PDF with Power Query covers the transform steps, and the full method comparison puts it next to the alternatives.
Has Copilot changed recently?
Yes, and none of it changes this answer. Copilot in Excel reached general availability, and Copilot support for Python in Excel is generally available in US English on Windows for licensed users, which lets Copilot run Python for cleaning, machine learning, and visualization against data in the sheet. A 2026 update pushed Copilot further toward editing the workbook directly rather than only suggesting.
All of that improves what happens after the data is in Excel. The Microsoft 365 Copilot app also added flows to create files, including generating a PDF from your documents, which is the feature most often mistaken for PDF conversion. And Copilot agents can produce artifacts, though none is documented as a dependable PDF table to typed spreadsheet converter.
Net effect: Copilot has become a much better analyst of data that is already structured. It has not become an importer.
What does Copilot cost?
The durable headline figure is $30 per user per month for the Microsoft 365 Copilot enterprise add-on on an annual commitment, layered on a qualifying base plan. Microsoft's business pricing page currently shows bundled options too, such as Business Standard with Copilot at $23.50 per user per month annually and a Copilot Business add-on starting around $18.00 per user per month annually with a discount noted through September 2026. Consumer access comes through Microsoft 365 Personal or Family with AI credits, or Microsoft 365 Premium.
Promotions move these numbers, so check the pricing page before you budget. The relevant point for this article is that none of those tiers buys you PDF to Excel conversion, because that is not a Copilot feature at any price.
So what should you actually use?
Match the tool to the document.
- Clean, digital PDF, on Windows, occasional use. Power Query's From PDF connector. Free, built in, refreshable.
- Scanned or photographed pages. Anything with OCR, because Power Query and Copilot both stop at a text layer that does not exist. Our OCR PDF to Excel converter reads the characters off the image and rebuilds the table.
- Financial documents where the totals must tie. A dedicated PDF to Excel converter that preserves numeric types, then verify the row count and one column total against the source.
- Many files, every month. A batch converter, or a real extraction pipeline. Teams pulling the same fields from thousands of documents a month generally move to purpose built document extraction rather than asking a chat assistant to do it one file at a time.
- Understanding what a document says. This is where Copilot is genuinely excellent. Ask it to summarize the PDF, explain a clause, or find the section you need. Then convert the tables with something built for tables.
The general lesson holds beyond Copilot. We looked at the same question for ChatGPT and PDF conversion and the shape of the answer was identical. Chat assistants read documents and generate plausible output. Extraction tools read document structure and reproduce it. When the output has to be right, and when someone downstream is going to sum a column and act on the total, you want reproduction, not generation.
Use Copilot for the thinking. Use a converter for the typing.