When a PDF to Excel conversion failed, the cause is almost always one of five things: a password or copy lock, pages that are images instead of text, a damaged file, a file too large for the tool, or a layout the converter misreads. Check them in that order. Each has a quick test, and most take under a minute.
Which PDF to Excel conversion failure do you have?
A failed PDF to Excel conversion shows one of a handful of symptoms, and each symptom points to a likely cause. An error before anything happens suggests a lock or a damaged file. An empty workbook suggests image-only pages. A timeout suggests size. A finished file with wrong rows suggests layout. Match your symptom first, then test.
The table below lists the causes in the order worth checking, because the early ones are quickest to rule out and the later ones take more work. The symptoms are typical, not guaranteed: the same cause can look different from one tool to the next.
| Order | Likely cause | Typical symptom | First test |
|---|---|---|---|
| 1 | Password or permissions lock | "Protected" or "encrypted" error, or a password prompt the tool cannot pass | Open the file's properties and read the security section |
| 2 | Image-only pages | Conversion finishes but the sheet is blank or nearly blank | Try to select one line of text in a reader |
| 3 | Damaged file | "Cannot open", "not a PDF" or a crash partway | Open the file in a second, different viewer |
| 4 | File too large | Upload stalls, a size error, or a timeout | Check the file size and page count against the tool's limits |
| 5 | Layout the tool misreads | A workbook full of merged text, shifted columns or extra rows | Compare three rows of output against the page |
Work down the table and stop at the first test that fails. If every test passes and the result is still wrong, the problem is in how the tool reads your layout, and the last sections cover that.
Password and permission locks behind a failed conversion
A password or permission lock is the first thing to rule out because it is the fastest to check. A PDF can need a password to open, or it can open freely but forbid copying text. Either one can stop a converter, and many tools report it only as a generic failure.
Open the file in any PDF reader and look at the document properties. The security section says whether the file is encrypted and lists what is allowed. If text copying or content extraction is marked as not allowed, many converters will refuse, even though you can read every page on screen.
What to do next depends on the lock:
- An open password you know. Open the file, then save or print it to a new copy if the permissions allow, and convert the copy.
- An open password you do not know. Ask whoever sent the file. Bank portals usually let you download a fresh copy of your own statement.
- A copy restriction. Ask for an unrestricted copy or a CSV export of the same data. Removing the restriction from a file you do not own is not the fix.
If the security section says no security, the lock is ruled out and you can move to the next cause.
Image-only pages that convert to an empty sheet
Image-only pages are pages that hold a picture of text rather than the text itself. A scanned statement, a photo saved as PDF, or a page printed through certain drivers all produce them. A converter that reads text finds nothing to read, so the conversion completes and returns an empty or nearly empty sheet.
The test takes seconds. Open the PDF in a reader and drag across one line of transactions. If individual words highlight, the page has text. If the whole page highlights as one block, or nothing highlights, the page is an image. A second test confirms it: search for an amount you can see. No hit means no text.
Two variants of this problem catch people out:
- Mixed files. A statement downloaded from a bank can have digital pages, with a scanned page of a cheque or a letter added at the end. Only the scanned page converts badly.
- Text that is there but wrong. Some PDFs hold text that pastes as symbols or nonsense. This is not an image problem but a font encoding problem, and why PDF copy and paste gives gibberish explains the cause and the fixes.
For a true image-only file, the conversion needs OCR, which recognizes characters from their shapes. That is a different kind of tool, and what to compare in OCR PDF to Excel software sets out how to choose one fairly.
Is the PDF file damaged, or only the download?
A damaged PDF has a broken internal structure, so readers and converters cannot find its pages. Often the original file is fine and only your copy is broken, cut short by a dropped connection or a blocked attachment. Opening the file in a second, different viewer tells you which: if both fail, the copy is damaged.
Before trying any repair, look at the file itself. A statement PDF of a few pages is usually tens or hundreds of kilobytes. A file of a few bytes, or one that is exactly zero bytes, did not finish downloading. A file whose name ends in .pdf but that opens as a web page in a text editor is an error page saved with the wrong name, which happens when a download link has expired.
Try these in order:
- Download again from the original source, in a different browser if the first one keeps failing.
- Open in a second viewer. A browser's built-in viewer and a desktop reader use different code, and one can sometimes open what the other rejects.
- Print to a new PDF from whichever viewer opens it. The new file has a fresh, clean structure.
If none of those work, the file needs real repair, or the data is lost. Repairing a corrupted PDF before you convert it walks through the repair options and how to tell when the content is gone for good.
File size and page limits that stop a PDF conversion
File size and page limits stop a conversion when a PDF is bigger or longer than the tool will handle. Online converters often cap upload size, and long scanned files grow large quickly. The usual symptom is an upload that stalls, a size error, or a timeout partway through.
Check two numbers: the file size in megabytes and the page count. Compare both with the limits your tool states. If you are over, you have three options:
- Split the file. Convert a year of statements one month at a time, or split a long statement into page ranges, then combine the sheets afterwards.
- Reduce the file. Scanned PDFs saved at very high resolution can be reprinted or exported at a lower resolution. Keep enough detail for the text to stay sharp.
- Use a range option. Some tools let you pick pages. Microsoft's guide to the Power Query PDF connector in Excel suggests selecting one page or a small range at a time with its StartPage and EndPage options to avoid timeouts on large files.
Page ranges have one more benefit. If a single page is causing the failure, converting in ranges narrows it down. The range that fails contains the problem page, and you can deal with that page alone.
Statement layouts that convert into the wrong rows
A layout problem is the case where the PDF to Excel conversion did not stop with an error but produced the wrong rows. Columns slide into each other, a long description splits into two rows, or headers repeat down the sheet. The file is fine. The tool misread where the columns and rows are.
Compare three rows of output against the page. Pick one ordinary row, one with a long description, and one near a page break. Typical faults and their usual causes:
- Two columns merged into one cell. The columns sit close together with no ruled line between them.
- A transaction split across two rows. The description wrapped onto a second printed line.
- Header text in the middle of the data. Every page repeats its column headers.
- Amounts in the balance column. Debit and credit columns are not aligned the same way on every page.
Microsoft's PDF connector page notes that multi-line rows are not always identified and suggests cleaning them up afterwards, for example by filling values down or grouping adjacent rows. That kind of cleanup works, but on a statement it takes time every month.
A converter built for statements reads them differently, because it expects dates, descriptions, amounts and balances. FastBankConvert reads the layout of the statement rather than relying on a fixed list of banks, and if a statement's balances do not add up after conversion, it tells you before you download. You can get started with FastBankConvert to hear when trial conversions open.
When to stop retrying a failed PDF conversion
Stop retrying a failed PDF conversion when two different tools have failed on the same file for the same reason. At that point the file, not the tool, is the problem. Getting a better source, such as a fresh download or the bank's CSV export, is usually quicker than a third or fourth attempt.
Signs that another attempt will not help:
- Every viewer fails to open the file. The copy is damaged, and conversion cannot fix that.
- The pages are poor scans. Blurry, skewed or low-contrast pages produce OCR errors in every tool. A new scan, or a digital copy, is the fix.
- The output is wrong in the same places each time. Two tools that both misread the same columns are telling you the layout is unusual. Fixing it by hand may be faster than more tries.
- You need only a few numbers. For a single total or a handful of rows, typing them takes less time than troubleshooting.
Keep a note of what failed and why. If the same bank's statements fail every month for the same reason, the fix is upstream: a different download format, a different export, or a different source for the data.