Excel for the web cannot do a PDF import from your own computer. The browser version reads PDFs through Power Query only when the file sits in a SharePoint site and you sign in with a work or school account. For a statement on your laptop, use desktop Excel's From PDF command, a bank CSV export or a converter.
Can Excel for the web import a PDF at all?
Excel for the web can import a PDF only from SharePoint, Microsoft's file service for organizations. Microsoft's table of Power Query data sources by Excel version lists PDF for the web version under SharePoint files, with organizational sign-in. There is no entry for a PDF stored on your own disk.
Power Query is the data import engine behind Excel's Get Data menu. In the browser, it works with a shorter list of sources than on the desktop. The PDF entry belongs to the SharePoint group, together with workbooks, text, CSV, XML and JSON files kept there.
What that means for a personal statement
A free Microsoft account does not come with a company SharePoint site. A statement downloaded to your laptop, or uploaded to a personal OneDrive, falls outside the source Microsoft lists. In practice, Excel for the web gives a home user no From PDF command to click.
What free Excel for the web lacks next to desktop Get Data
Free Excel for the web lacks the local file connectors that desktop Excel has: a PDF on your disk, a local folder of statements and most desktop file types. Microsoft's version table for the browser lists table and range, SharePoint files and folders, several databases and cloud services, almost all needing an organizational or password sign-in.
Here is the gap that matters for statements, taken from that table:
| Source | Desktop Excel, Microsoft 365 on Windows | Excel for the web |
|---|---|---|
| PDF on your computer | Yes, From PDF | Not listed |
| Local folder of files | Yes | Not listed |
| Table or range already in the sheet | Yes | Yes |
The browser version is still useful once the rows are in. It sorts, filters, totals and charts a statement as well as the desktop app does for everyday work.
The desktop Excel PDF import you need instead
The PDF import you need is desktop Excel for Windows, under Data, Get Data, From File, From PDF. Microsoft's version table ticks PDF for the Microsoft 365 plans, both the home and the business ones, and notes that the connector requires .NET Framework 4.5 or later. The Mac table lists no PDF source.
The desktop import shows a Navigator window with each table and page it found. You pick the transaction table, load it, and the rows land in cells with no retyping. It works on text PDFs, the kind most banks produce for download. It reads nothing from a scan, because a scan holds pictures, not text.
Set it up once, reuse it every month
The desktop import is a saved query. Point it at next month's file and refresh, and the same cleanup steps run again. Reusing Power Query for monthly statements shows how to build the query so a new file drops straight in.
Cheapest workarounds when Excel for the web cannot read the PDF
The cheapest workaround is a CSV export from your bank, because it costs nothing and needs no conversion. After that, the right choice depends on the file. The table below compares the options, with times as rough estimates for a text statement of a few pages.
| Workaround | Cost | Rough time | Suits |
|---|---|---|---|
| Bank CSV or spreadsheet export | $0 | 5 minutes | Any statement your bank offers as CSV |
| Google Sheets route | $0 | 20 to 40 minutes | Text PDFs, short statements |
| Automator on a Mac | $0 | 15 to 30 minutes | Mac users with text PDFs |
| A Microsoft 365 trial, cancelled in time | $0 | 1 hour or more with setup | A stack of statements in one month |
| Per-statement converter | A few dollars | A few minutes | Long statements, no time to clean up |
Notes on each row
- Bank export. Most online banking sites offer a transaction download next to the PDF. Downloading bank statements for free covers where to look.
- Google Sheets. The Google Sheets route from PDF to spreadsheet goes through Google Docs and is free with a Google account.
- Automator. On a Mac, extracting PDF text with Automator pulls the text out for pasting into a sheet.
- Per-statement converter. CheapBankConvert is getting ready to open, at early prices of $2.99 for up to 10 pages. Its .xlsx files open fine in Excel for the web.
Is uploading the PDF to OneDrive enough for Excel for the web?
No. Uploading a PDF to OneDrive and opening it gives you a PDF preview, not a spreadsheet. OneDrive shows the pages as they print, and nothing in that view turns them into rows. Excel for the web only works on the data once it is in a workbook, and a personal OneDrive is not one of its listed PDF sources.
This catches people because the PDF sits right next to their Excel files in the same OneDrive folder. It looks as if Excel should be able to reach it. The browser's PDF support is for organizations that keep files in SharePoint, through Power Query, not for a file you dragged into OneDrive.
Copying from the preview
You can select text in a text PDF preview and paste it into an Excel for the web sheet. Expect each line in a single cell, with the date, description and amounts run together. That is workable for a dozen rows and slow for a full statement.
A privacy thought
A statement in OneDrive is a copy of your banking history in the cloud. If you uploaded it only to try the import, delete it from OneDrive and empty the recycle bin there too.