To put a PDF into Excel, import it with Data, Get Data, From File, From PDF. That reads the tables inside the file into cells. File, Open fails because Excel does not read PDFs as workbooks, and Insert Object only attaches the PDF as an icon. Locked files need a password first.
What happens when you put a PDF into Excel with File, Open?
Excel shows an error or a prompt when you try File, Open on a PDF, because Excel opens spreadsheet formats such as XLSX, XLS and CSV, and a PDF is a page description, not a spreadsheet. The file is not damaged. You are using the wrong command for it.
The exact message varies by version. You may see a message that the file format is not recognized, or that Excel cannot open the file because the format or extension is not valid. In every case, nothing arrives in cells.
Why renaming the file does not help
People often try renaming statement.pdf to statement.xlsx. That does not convert anything. It changes the label, not the contents, and Excel then reports that the file is corrupt. Undo the rename and use one of the commands in the next section.
What the PDF contains
A PDF holds text placed at positions on a page, plus lines and images. It has no cells. Any tool that puts a PDF into Excel has to look at where the words sit and infer rows and columns, so the result depends on how tidy the layout is. Four free methods compared explains which ones work best on statements.
Open vs import: putting a PDF into Excel the right way
Importing is the right way to put a PDF into Excel, and opening is not. Import reads the tables in the PDF and places them in cells you can sort and sum. The Get Data command does this, and Microsoft lists a PDF connector among the data sources in its overview of Excel data sources.
Here is how the three commands compare:
| Command | What it does with a PDF | What you get |
|---|---|---|
| File, Open | Tries to load the PDF as a workbook | An error, and no data |
| Data, Get Data, From File, From PDF | Reads the tables in the file | Rows and columns you can edit, often one table per page |
| Insert, Object, Create from file | Embeds the PDF as an attachment | An icon that opens the PDF, and no data in cells |
The middle row is the one you want. The Get Data from PDF steps walk through each click, from the Data tab to Close & Load.
What to expect from an import
The import works well on a PDF with real text and ruled or evenly spaced tables. It gives nothing for a scanned PDF, because a scan is a picture. A quick check: if you cannot select a word in the PDF with your cursor, Excel cannot read it either.
If you have no Get Data
Without that tool, the fallbacks are Word, Google Docs or copy and paste. The Google Sheets route is the most reliable of those. On a Mac without Excel, converting a PDF on a Mac with Preview and Numbers has its own steps.
Password-protected PDF edge case in Excel
A locked statement fails in Excel because the file is encrypted, and the import cannot read text it cannot decrypt. Some banks protect downloaded statements with a password, and Excel cannot guess it.
Microsoft's help page for the PDF import does not describe a password prompt, so do not count on one. If your PDF reader asks for a password when you open the statement, treat the protection as the cause of the failed import. If the file opens without one, look for a different problem, such as a scan or a damaged download.
Two fixes for a locked file
First, open the PDF in a PDF reader, enter the password and print or save a copy as a new PDF with no protection. Then import the new copy. Second, check your bank's help page for the password rule, because the format differs from bank to bank and I will not guess at yours here.
A privacy note
Removing a password makes a copy of your statement that anyone can open. Delete that copy when you finish, and keep it off shared folders. The original protected file is the safe copy to keep.
Can you put a PDF into an Excel sheet as an object?
Yes, you can put a PDF into an Excel sheet as an object, but the object is an attachment, not data. Excel shows an icon or a picture of the first page. Double-click and the PDF opens in your PDF reader, and no figure ever lands in a cell.
To do it, open Insert, choose Text, then Object, switch to the Create from File tab and select the PDF. Tick Display as icon if you want a small icon and not a picture of the first page.
When an object is the right choice
It suits keeping a source document next to the numbers, for example a statement tucked into the workbook that holds your reconciliation. Anyone reading the workbook can open the original. It increases the file size by about the size of the PDF.
When it is not enough
If you wanted to sum a column, filter dates or categorize spending, the object does nothing for you. You still need the import above. Many people embed the PDF, see it sitting in the sheet, and assume the data is there. The test is simple: click a cell next to the icon. If it is empty, nothing was imported.
When typing is your only option
If the PDF is a scan of poor quality and no tool reads it, you may be left retyping. A faster Excel setup for typing statements helps with that. Before you start, consider a per-statement converter. CheapBankConvert charges once for a document and previews the first 2 pages free, and Get started puts you on the list for when it opens.