To open a PDF in Excel, you have three real choices: File > Open, which usually fails or hands you to an import step; Insert > Object, which only attaches the PDF as an icon; and an import or converter, which turns the numbers into cells. Only the last one gives you data you can sum.
What happens when Excel opens a PDF file?
When you pick a PDF in Excel's File > Open dialog, Excel does not read it like a workbook. A PDF describes where each character sits on a page, and a spreadsheet needs rows and columns. What you see depends on your Excel version, and the usual result is an error message or an import prompt, not a sheet.
Excel opens files by recognising their format. Workbooks, CSV files and plain text all have a structure Excel can read. A PDF has none of that. It stores text fragments with page positions, and it has no concept of a table. Two numbers that look stacked in a column are just two fragments that happen to share a horizontal position.
The error and the gibberish
Most people meet one of two outcomes. The first is a message saying Excel cannot open the file because the format or extension is not valid. The second is a sheet full of strange symbols, which happens when the PDF is read as plain text, for example through a text import or a plain text editor. The symbols are the compressed internal structure of the PDF, and no cell in that mess is a number from your page.
Do not rename the extension. The rename changes the label on the file and nothing inside it. It will not make a PDF into a workbook, and it can leave you with a file that Excel flags as damaged.
When Excel offers an import instead
The way to get a PDF's tables into Excel itself is Data > Get Data > From File > From PDF, not File > Open. That import shows a Navigator window listing the tables and pages Excel found, and you choose what to load. It exists only in some versions and platforms, so check your Data tab first. The exact click path is covered in the Get Data from PDF import steps, which is the reliable route when File > Open does not do it for you.
What you do not get
Even when an import works, it reads the page, not your intent. Expect to check three things: that every row arrived, that amounts are numbers and not text, and that a page header was not read as data. A short list of checks like these is the difference between a file that looks right and one that sums right. How to make a result sortable and totalled is in turning a PDF into a spreadsheet you can sort and sum.
Inserting a PDF as an object in a workbook
Inserting a PDF as an object places the whole PDF file inside your Excel workbook, shown as an icon or a picture of the first page. Double-clicking opens the PDF in your PDF reader. The numbers stay inside the PDF, so no formula can use them. Use it to keep a source document beside your work.
On Windows desktop Excel, the path is Insert > Text > Object, then the Create from File tab, then Browse to the PDF. You then choose between two settings:
- Display as icon shows a small icon that opens the PDF on a double-click. This keeps the sheet tidy.
- Link to file stores a path to the PDF instead of a copy. It keeps the workbook small, and it is the cause of the broken links described further down.
If you leave the link box unchecked, Excel stores a full copy of the PDF in the workbook. A 4 MB statement, to take an example size, makes the workbook roughly 4 MB bigger, and every copy you email carries it along.
What an inserted PDF is good for
An inserted PDF suits an audit trail. A reviewer opens the workbook, sees your figures and the source document in one file, and checks one against the other. It also suits a client file where the original must travel with the working papers.
What it cannot do
It cannot give you data. Excel treats the object as a picture of an attachment. You cannot select a value inside it, point a formula at it or filter it. If a reader asks "can I get the figures from the inserted PDF?", the answer is no, not without importing or converting the PDF separately.
Opening a PDF in Excel for the web
Excel for the web is the browser version of Excel, and it has fewer features than the desktop app. Do not assume the desktop options carry over. A PDF dragged into it is stored as a file in OneDrive, but the browser version is not a PDF reader and does not turn a PDF into cells.
Check the Insert and Data tabs in your own browser before planning around any import or object feature there. If the PDF import is missing there, you have two practical choices. Open the workbook in the desktop app, where the Get Data route is available on Windows, or convert the PDF outside Excel and open the result.
Online storage is not the same as conversion
Putting a PDF in OneDrive or SharePoint makes it viewable in the browser. It does not change what is inside. A PDF previewed in a browser tab is still a page layout, and the numbers in it are still not in any cell.
A note on sensitive files
A bank statement holds account numbers and transactions. Before you upload one to any service, read what happens to the file afterwards. The trade-offs of web converters are weighed in whether uploading a PDF to an online converter is safe.
When should a PDF open as data, not as an attachment?
A PDF should open as data whenever you plan to calculate with it: summing, sorting, filtering, charting or comparing months. It should stay an attachment when the file is evidence and you only need to see it. Decide by asking what you will do with the numbers in the next ten minutes.
The table below maps four common goals to the method that fits. The goals and methods are the ones covered in this post.
| What you want | Best fit | Why |
|---|---|---|
| See the PDF beside your numbers | Insert > Object | The document travels inside the workbook |
| Edit or total the numbers | A converter or an import | Values must land in cells |
| Refresh the sheet every month | Get Data > From PDF (Windows) | A saved query reruns on a new file |
| Send one file to someone | Insert > Object, or a converted workbook | Choose by whether they need figures or evidence |
| Open the PDF straight with File > Open | Rarely works | Excel cannot read a page layout as cells |
Find your goal in the first column and read across. If two goals apply, you may want two methods: an import for the numbers and an inserted PDF for the proof.
A worked example
Say a small business owner gets a three-page bank statement and wants to find the total spent on fuel. The owner needs figures in cells, so File > Open and an inserted object are both the wrong tool. A converter or an import gives a sheet with one row per transaction. They filter the description for "fuel" and sum the amount column. Then, if the accountant wants proof, they insert the original PDF as an object on a second sheet. The example values here are invented, but the order of steps is the point: data first, evidence second.
Why the statement case is special
A bank statement has a clear row structure: a date, a description, an amount and often a balance. That makes it a good candidate for a converter built for it. FastBankConvert is getting ready to open and is built to turn a digital statement PDF into Excel, CSV or JSON, and you can join through Get started to hear when trial conversions are available.
Linked PDF objects that break when files move
A linked PDF object stores the path to the PDF, not the PDF itself. If the PDF is renamed, moved or deleted, or the workbook is opened on a computer that cannot reach that path, the link breaks. Excel then fails to open the PDF or shows an error.
The fix depends on which copy you can still find.
- Find the PDF in its new folder, or recover it from a backup or the email it came from.
- Delete the broken object in the workbook.
- Insert it again, this time with Link to file unchecked, so the workbook holds its own copy.
- Save, close the workbook, move it to another folder and reopen it. If the PDF still opens, the copy is embedded.
Choosing link or embed
Link when many people read one shared PDF that changes, and everyone sees the same network path. Embed when the workbook will be emailed, moved to another drive or archived. For client work and monthly bookkeeping, embedding is usually the safer choice. The cost is file size, which is easy to check before you send.
Other reasons an inserted PDF will not open
A broken link is not the only cause. The computer may have no PDF reader set as the default, the object may be blocked by a security setting on a shared drive, or the workbook may have been opened in the web version, which may not open the object at all. Test by opening the PDF by itself from the same folder. If it opens, the problem is in the Excel object, and re-inserting it fixes most cases.
Passwords and protected PDFs
An embedded PDF keeps its own password. Excel does not store the password, so the reader is asked for it each time the object opens. If the PDF is locked and you need its numbers, the lock has to be dealt with before conversion.
A short rule to remember
Open means look, insert means attach, and import means calculate. When you only need to see a PDF, attach it. When you need its numbers, get them into cells with an import or a converter, and then check the total against the page. If you work on a Mac, the options differ, and converting a PDF to Excel on a Mac covers them.