To turn a PDF into Excel, pick one of four routes: export from your PDF reader, import it with Excel's own Get Data from PDF, copy and paste a table, or upload it to an online converter. A text-based PDF with clear tables works with all four. Scanned pages and phones narrow the choice.
Which PDF to Excel method fits your file?
Start by looking at the file, not the tools. Two questions decide the route: can you select the text with your cursor, and do the numbers sit in a table with clear columns? Your answers point to one of four methods, and the rest of this post compares them.
Check whether the PDF holds text or a picture
Open the PDF and drag your cursor across a line of numbers. If the text highlights, the file is a text PDF, and every method below can work. If you only see a blue box over the whole page, the page is a picture of text, usually from a scanner or a phone camera. Reading it needs optical character recognition (OCR), which turns the image of a letter into the letter itself. Excel's import and a plain copy cannot do that. The guide to telling an image PDF from a text PDF shows the checks in more detail.
Match the file to a method
Use this as a first pass:
- A short table on one or two pages: copy and paste is often the fastest route, and it needs no extra software.
- A table that runs over many pages: Excel's Get Data from PDF can stack the pages for you, if your version has it.
- A PDF your reader can export: the reader's export option takes one click, if your reader offers it.
- A scan, a phone photo, or a file you are not sure about: an online converter with OCR is the realistic choice.
The four routes also differ in what you must have installed, which is why the comparison table later in this post includes Excel version and phone columns.
Excel's built-in route for PDF files
Excel can read a PDF itself through Get Data, a feature built on Power Query, which is Excel's data import and cleanup engine. You choose Data, Get Data, From File, From PDF, and pick the tables you want. It needs no other tool, but not every version of Excel has the From PDF option, so check your Data menu.
Microsoft documents the PDF connector as part of Power Query, with Excel listed as a supported product. The connector reads a file and hands back the tables it finds, along with whole pages. You choose from that list in a window called the Navigator, then either load the data or open it in the Power Query editor for cleanup. Microsoft Learn describes the PDF connector and its options, including how to limit the page range and whether similar tables on consecutive pages are combined.
What this route does well
Excel's import is strong on long, regular tables. The connector can combine similar tables on consecutive pages into one, which saves the manual stacking you would do after a copy and paste. The query also stays in the workbook, so you can refresh it later against a new file. For the exact clicks, read the step-by-step Power Query import guide.
Where it falls short
The import only reads text PDFs. If Excel lists no tables, or lists a table that is only part of the page, you will end up cleaning columns by hand. It also depends on your version of Excel. If the From PDF option is missing from your menu, you cannot use this route until you update or switch tools.
Online converters for PDF to Excel
An online converter is a website or app where you upload the PDF and download a spreadsheet. It adds what Excel's own import lacks: it runs on any device with a browser, and many include OCR so scanned pages work. The trade-off is that your file leaves your computer.
What an upload converter adds
Three things make converters worth considering. They run the work on a server, so a phone or a locked-down work laptop can use them. They can read pages that are images. And they usually try to guess the column layout for you, so you skip the Navigator and the cleanup window.
Quality varies a great deal. Some tools put every page on its own sheet, some drop header rows, and some turn a column of dates into text. Before you trust one with real work, test it with a file whose totals you already know. The post on what separates a good PDF to Excel converter from a bad one lists what to look for.
Privacy and bank statements
A PDF that holds a bank statement contains account details and transactions. Read the tool's statement on how long it keeps uploads before you send anything. FastBankConvert, which is not open yet, converts PDF bank statements to Excel, CSV or JSON, encrypts uploads in transit and deletes trial files after download; the get started page takes your email for when trials open.
How long does each PDF to Excel method take?
Time depends on the file more than the tool. On a clean five-page text PDF, a reader export takes a minute or two, Excel's import a few minutes the first time, and copy and paste longer. The figures in this section are example estimates, not measurements.
A worked example: five pages, one table
Take a five-page PDF of transactions with one table running across all pages. These example estimates assume a text PDF and a person who has done the task before:
- Reader export: open the file, choose export, pick Excel, save. About one to two minutes, plus a check of the result.
- Get Data from PDF: pick the file, choose the table in the Navigator, load. About three to five minutes the first time, less on later months because the query can refresh.
- Copy and paste: copy each page, paste, then delete the repeated headers. About five to ten minutes, and it grows with every page.
- Online converter: upload, wait, download, open. About one to three minutes if the tool reads your layout correctly.
Notice what these numbers leave out. Fixing a bad result can cost more than the conversion itself. A method that finishes in one minute but leaves numbers stored as text can take ten more minutes to repair, so judge a method by the time to a usable sheet, not the time to a file.
What slows each route down
Copy and paste slows with page count, because each page is a separate paste and a separate cleanup. The Excel import slows when a table is split into fragments. Reader exports slow when they produce one sheet per page. Online converters slow on big files, and scanned pages take longer than text ones.
The four PDF to Excel methods side by side
The table below compares the four methods on the points that usually decide the choice. The time column uses the same example estimates as the section above and assumes a five-page text PDF. The other columns describe how each method typically behaves, so test your own file before relying on them.
| Method | Time on a five-page file | Keeps columns | Handles scans | Needs Excel 365 | Works on a phone |
|---|---|---|---|---|---|
| Reader export | 1 to 2 minutes | Usually, on clean tables | Only if the reader has OCR | No | Rarely |
| Get Data from PDF | 3 to 5 minutes first time | Yes, when tables are detected | No | Yes, a version with Power Query | No |
| Copy and paste | 5 to 10 minutes | Often not; may land in one column | No | No | Awkward |
| Online converter | 1 to 3 minutes | Depends on the tool | Often, with OCR | No | Yes |
How to read the table
If your file is a scan, the "handles scans" column removes two methods at once. If you do not have a Power Query version of Excel, it removes one more. If you work from a phone, the converter is the only column that fits. For a text PDF on a desktop, every row survives, and the decision comes down to how many pages there are and whether you will repeat the task next month.
Repeating the task
A task you will do every month favors a method you can repeat with little effort. A saved Excel query refreshes against a new file with the same layout. An online converter repeats in the same few clicks each time. Copy and paste has no memory, so each month starts over.
When retyping beats any PDF to Excel method
Retyping beats conversion when the PDF is short, the layout is messy, or the numbers matter more than the speed. A handful of values in a document that is mostly prose is quicker to type than to convert and clean. A conversion that needs ten minutes of repair is a poor trade for one minute of typing.
Signs a PDF is too messy to convert
Some documents defeat every route. Watch for these:
- Invoices and forms with boxes, logos and free-floating labels instead of rows and columns.
- Photos taken at an angle or with shadows across the numbers.
- Handwriting, which OCR reads poorly.
- Two or three numbers inside a long text document.
For files like these, the cost is not the conversion but the checking. Whatever route you pick, add up a column in Excel and compare it with the total printed on the PDF. A matching total is the cheapest proof that nothing was dropped or doubled.
What the conversion cannot restore
A PDF stores where text sits on a page, not what the text means. That is why even a good method can lose a merged heading or turn a page footer into a data row. The post on what survives the trip from PDF to Excel explains why, and the guide to saving a PDF as Excel from your reader covers the export menu in detail.
For bank statements, FastBankConvert runs that balance check for you and warns you before download if the balances do not add up. It is not open yet.
Copy and paste repairs
If you choose to paste, expect the table to land in a single column or a block of merged cells. That is normal and fixable. The steps are in the guide to why a pasted PDF table lands in one column.