# Copilot in Excel PDF Import: Worth the Extra Cost?

- Author: CheapBankConvert (https://cheapbankconvert.com)
- Published: 2026-10-17
- Category: Free tools you already own
- Canonical: https://cheapbankconvert.com/blog/copilot-in-excel-pdf

> Can Copilot in Excel pull a PDF statement into a sheet? What it costs on top of Microsoft 365, what it gets wrong, and the free steps it replaces.
Copilot in Excel can pull data from a PDF, but only a PDF saved in OneDrive or SharePoint, and only for the person who owns a plan with Copilot. It inserts what it finds, and you still check every row against the statement balance. For a text-based statement, Excel's free Get Data import does the same job.

## Can Copilot in Excel read a PDF statement?

Yes, within limits. Microsoft says Copilot in Excel can add data from Word, Excel, PowerPoint or PDF files stored in SharePoint or OneDrive. You ask for the data in plain words, and Copilot inserts it into the sheet. It does not replace checking, and it does not reach a file kept only on your computer.

Microsoft's article on [importing data with Copilot in Excel](https://support.microsoft.com/en-us/topic/import-data-from-the-web-and-internal-sources-with-copilot-in-excel-7a72fb29-e623-49e2-9f7d-38664b593054) describes the flow: open Copilot from its icon, ask it to find the data you want, and wait while it collects the data and places it in your sheet. The page names PDF files among the sources. It does not describe how Copilot handles a multi-page table, a page header that repeats, or a scanned page. Those are the parts of a bank statement that cause trouble with any tool.

So the honest answer has two halves:

- **What is documented:** a PDF in OneDrive or SharePoint can be a source for data Copilot inserts.
- **What is not documented:** whether every row of a 12-page statement arrives, in order, with amounts as numbers.

The second half is something you find out on your own file. Treat the first run as a test, not as a finished import.

There is also a basic file check. Copilot works from the text a file contains. If your statement is a scan or a phone photo, try to highlight a line in a PDF viewer first. If nothing highlights, the file has no text layer, and no import tool reads it without OCR.

## What Copilot in Excel costs on top of a Microsoft 365 plan

Copilot in Excel comes with Microsoft 365 Personal, Family and Premium, not as a separate charge, but only the subscription owner can use it. Microsoft 365 Basic has no AI features. In the US, Personal is $99.99 a year, Family $129.99 and Premium $199.99, with usage limits on AI features.

Those figures and conditions come from Microsoft's [comparison of Microsoft 365 plans](https://www.microsoft.com/en-us/microsoft-365/buy/compare-all-microsoft-365-products), read in October 2026. The footnotes carry the details that matter here:

- AI features are for the subscription owner only and cannot be shared, even on Family.
- Usage limits apply. Premium is listed with extensive Copilot usage, while Personal and Family are listed as higher than the free tier.
- Copilot in Excel requires AutoSave to be on and does not work with unsaved files.
- Microsoft 365 Basic, at $19.99 a year, has no AI features.

### What "extra cost" means in practice

If you already pay for Personal, Copilot in Excel adds no new charge. The cost question only bites if you would upgrade or subscribe to get it. Here is the gap, using the plan prices above as examples of what you would add:

| Starting point | Upgrade to get Copilot in Excel | Extra per year |
| --- | --- | --- |
| No plan | Personal | $99.99 |
| Microsoft 365 Basic | Personal | $80.00 |
| Family, but you are not the owner | Your own Personal plan | $99.99 |
| Personal | Nothing to add | $0 |

The third row surprises families. A household member on a Family plan has desktop Excel but not the AI features, so Copilot is not an option for them unless the owner does the work.

A trial is one way to test Copilot on your own statement before paying. [Running a Microsoft 365 free trial for one PDF](/blog/microsoft-365-free-trial) covers the steps and the date to cancel by.

## Asking Copilot for statement rows from a PDF, step by step

The Copilot route takes six steps: put the PDF in OneDrive, open a blank workbook saved to OneDrive with AutoSave on, open Copilot, ask for the transaction table by name, review what it inserts, and run the balance check. The wording of your request matters more than any setting.

### The steps

1. Upload the statement PDF to OneDrive. If you use the OneDrive app on your computer, drag it into a OneDrive folder and wait for the sync mark.
2. Open Excel, create a blank workbook and save it to OneDrive. Check that the AutoSave switch at the top left reads On.
3. Select the Copilot icon. Microsoft's article says it sits in the lower-right corner of Excel.
4. Type a specific request. A vague one ("get my statement") invites a summary. A specific one names the file and the columns.
5. Read what Copilot inserts before you accept it. Look at the first row, the last row and the row count.
6. Run the checks in the next section.

### An example request

The wording below is an example. Change the file name and columns to match yours.

> From the file March-checking.pdf in my OneDrive, insert every transaction as one row with four columns: Date, Description, Amount and Balance. Use negative numbers for withdrawals. Do not summarize or skip rows.

Naming the columns gives you a table you can test. Asking for negative withdrawals gives you one signed amount column, which makes the balance check a single sum.

If your Excel has no Copilot icon at all, check the version as well as the plan, since Microsoft's article applies to Excel for Microsoft 365. [Finding which version of Excel you have](/blog/which-version-of-excel-do-i-have) shows where to look and what each version includes.

## Copilot PDF output checks before you trust the totals

Every set of rows Copilot inserts from a PDF needs the same proof as any other conversion: the opening balance plus the sum of the amounts should equal the closing balance. Microsoft's documentation offers no accuracy guarantee for PDF imports, so the check is yours to run. It takes two minutes.

### The checklist

Work through these on the inserted rows. The figures in the worked example are made up.

- **Row count.** Count the transactions on the PDF's last page and one middle page. Compare with the rows on those dates in the sheet.
- **First and last row.** The first date and the last date should match the statement period.
- **Amounts as numbers.** Click an amount. If it is left-aligned, or the sum ignores it, it is text.
- **Signs.** Withdrawals should be negative if you asked for that. A positive withdrawal doubles an error.
- **Page breaks.** Repeated headers such as "Date Description Amount" should not appear as data rows.
- **Wrapped descriptions.** A merchant name that wrapped onto two lines should be one row, not two.
- **Balance proof.** Opening balance, plus the sum of all amounts, should equal the closing balance.

### A worked balance check

Say an example statement shows an opening balance of $2,410.55 and a closing balance of $1,987.30. The amounts Copilot inserted sum to −$398.25.

$2,410.55 − $398.25 = $2,012.30. That is $25.00 more than the closing balance, so one withdrawal of exactly $25.00 is missing, or one $12.50 withdrawal came in with the wrong sign. Search the PDF for 25.00 and 12.50 first.

When the numbers match to the cent, the import is complete. When they do not, the gap amount tells you what to look for, which is faster than reading every row.

## Copilot in Excel edge case: a statement saved only on your laptop

A PDF kept only in your Downloads folder is invisible to Copilot's file import. Microsoft's article says the source files must be saved in SharePoint or OneDrive. Microsoft's plan footnotes add that Copilot in Excel needs AutoSave on and does not work with unsaved files, and AutoSave is a feature of workbooks saved to OneDrive or SharePoint.

This is where privacy and convenience pull against each other. Some people keep bank statements off cloud storage on purpose. Copilot's route asks you to upload the statement to OneDrive, at least for the length of the import. If you do not want that, the Copilot route is not for you, and the free desktop import below reads a local file without uploading it anywhere.

If you do use OneDrive for the import, a few habits help:

- Put statements in one folder, so you know what you uploaded.
- Delete the PDF from OneDrive afterwards if you do not want it stored there, and empty the OneDrive recycle bin.
- Keep the original statement wherever you normally keep records.

## Is Copilot worth it over the free Get Data PDF import?

For a text-based statement, usually not. Excel's Get Data, From File, From PDF menu reads tables from a local PDF in desktop Excel for Windows on a Microsoft 365 plan, with no upload and no owner-only limit. Copilot earns its place when you already own it and want to ask follow-up questions about the rows once they are in.

Here is a side-by-side for statement work:

| Question | Get Data from PDF | Copilot in Excel |
| --- | --- | --- |
| Extra cost on a desktop plan | None | None for the owner, a new plan for anyone else |
| PDF location | Local or cloud | OneDrive or SharePoint |
| Shows you the tables found | Yes, in the Navigator window | No, it inserts its result |
| Repeatable each month | Yes, with a saved query | You type the request again |
| Answers questions about the data | No | Yes |

The Navigator window is the deciding difference. Get Data shows every table it found and lets you pick, so you see what it read. Copilot hands you an answer. For a document where one missing row matters, seeing the source tables is worth more than a natural-language request. Other routes for bringing a PDF into a workbook, including Insert Object and plain copy-paste, are compared in [how to put a PDF into Excel](/blog/how-to-put-a-pdf-into-excel).

Where Copilot does help is after the import. Once clean rows are in the sheet, asking "which merchants did I pay more than three times this month" is quicker than building a pivot table.

If you are weighing an upgrade mainly for imports, the same logic applies as for any software tier: pay for the feature you will use, not the bundle. [Comparing free and pro PDF converter plans](/blog/pdf-converter-free-vs-pro) runs that test in detail. A per-file option is the other comparison. [CheapBankConvert](/get-started), which is not open yet, plans to charge once per statement, from $2.99 for up to 10 pages, with amounts saved as numbers in the .xlsx file.