Yes, you can turn a PDF into an Excel file in most cases. Text-based PDFs convert best, scanned ones need text recognition, and a password or a digital signature changes the steps without ruling conversion out. Answer three questions about your file, below, and you will know which route to take.
Is every PDF file convertible to Excel?
Almost every PDF can become an Excel file, but the result depends on what is inside the PDF. A PDF made from a document or exported by a bank holds real text, and that converts cleanly. A PDF made from a scan holds a picture of text, and it needs text recognition first.
Three kinds of PDF cover most of what people hold:
- Text PDFs come from word processors, accounting software and bank websites. The characters are stored as characters, so a converter can read them directly.
- Image PDFs come from scanners and phone cameras. Each page is a photograph, and nothing on it can be selected until software recognises the letters and digits. Recognition is slower and can misread a digit.
- Mixed PDFs hold both, such as a text report with a scanned page stuck in the middle.
Convertible does not mean tidy. A PDF has no real columns, so a converter has to guess where one ends and the next begins. What survives a PDF to Excel conversion and what breaks shows which numbers, dates and layouts cross intact. The four general methods are compared in how to turn a PDF into Excel.
The three-question checklist
Answer these in order. Each answer sends you down a different path.
- Can you select text in it? Open the PDF and drag across a line. If the text highlights, it is a text PDF and converts well. If nothing highlights, it is an image PDF. A fuller test is in telling an image PDF from a text PDF.
- Does it open without a password? If yes, move on. If it asks for a password, see the locked-files section below.
- Do you need the numbers, or only one changed line? If you need many figures in cells, convert. If you need to fix one word or number in the PDF itself, edit the PDF instead, as explained at the end.
A quick example
Say you download a bank statement from your bank's website. You can select the text, it opens without a password, and you want every transaction in a sheet. That is yes, yes, numbers. Convert it. FastBankConvert is getting ready to open and is built for this exact case, turning a digital statement PDF into Excel, CSV or JSON. Get started puts you on the list to hear when trial conversions are available.
Two special cases to set aside
A PDF made from an Excel workbook may be easier to rebuild than to convert, and the form fields in a fillable PDF are a separate matter from its page text. Both have their own posts: turning a PDF made from Excel back into the workbook and fillable PDF forms and their data fields.
Locked and password-protected PDF files
A PDF can carry two kinds of password. An open password stops anyone reading the file until it is entered. A permissions password lets people read the file but restricts actions such as copying, printing or editing. The two behave differently when you want to convert.
With an open password, you must enter it to see the document at all. Once it is open, you can usually save an unlocked copy by printing to a new PDF, if the document allows printing, and convert the copy. If you do not have the password, ask whoever sent the file, and check the message that came with it, since senders often explain there how the password is set.
With a permissions password, the file opens, but copying may be disabled. A converter that respects the setting may refuse, or return empty cells. That restriction is the document owner's choice. If you need the data, ask the owner or the issuing system for an unrestricted version. Do not try to break the password on a file you are not entitled to open.
What to do in the meantime
If the PDF opens but copying fails, two things can still work. Ask for the same data in another format, such as a CSV from the bank's website, which avoids conversion altogether. Or check whether a version of the statement exists in your online banking that is not protected.
Signed and certified PDF files
A digital signature on a PDF proves who signed it and that the file has not changed since. It does not stop you reading the file, selecting its text or converting it. Converting creates a new Excel file and leaves the signed PDF as it was, so the signature on the original remains valid.
What a signature does restrict is editing the PDF itself. If you open a signed PDF in an editor and change a word, the signature will report that the document was altered after signing. A certified PDF goes one step further and allows only certain changes, set by whoever certified it.
So the rule is simple. Convert freely from a copy, and keep the signed original untouched as your record. Never send the Excel file as if it carried the signature, because it does not. If someone needs proof, send the original PDF alongside the sheet.
The same rule for statements
The habit suits statements whether or not they carry a signature. Keep the PDF you downloaded, convert from it, and compare the converted total with the printed one.
Can you edit the PDF instead of turning it into Excel?
Yes, and for a small change it is often quicker. If you need to fix a name, a date or a single figure in the PDF itself, a PDF editor changes it in place. Converting to Excel makes sense only when you need many values in cells to calculate with.
Pick by what you need to end up with:
- One changed line, and the result stays a PDF: edit the PDF. No conversion is needed, and the layout stays exactly as it was.
- A list of figures to add, sort or chart: convert to Excel.
- A page you only need to read or send: do nothing to it.
Editing is also the wrong tool when the file is signed, because the change breaks the signature. In that case, ask the signer for a corrected version.
A final decision
Go back to the checklist. If you can select the text, the file opens freely and you need the numbers, convert it and check the total against the page. If any answer is no, you now know which fix to try first.