Insert PDF into Excel: Embed a PDF into Excel or Convert PDF Tables to Cells
Excel's Insert Object command attaches the PDF as a picture or an icon. It sits on the sheet, it prints, and it opens on a double click, but you cannot sort it, filter it, or add it up. If the reason you are inserting the file is the numbers inside it, convert it instead: drop the PDF on the right and get every value in its own cell.
Works in any browser and any Excel version, scanned files included.
Drop your PDF here or click to browse
PDF files up to 50MB
Real cells you can total, not an embedded picture. Free to preview.
The short answer
To insert a PDF into Excel, click the cell where you want it, open the Insert tab, click Object in the Text group, choose the Create from File tab, click Browse, and pick your PDF. Leave the checkboxes clear and Excel displays the first page of the file; tick Display as icon and you get a small icon instead. Either way the PDF is an embedded object, not data, so nothing in it can be sorted or summed. When you need the figures as spreadsheet rows, convert the PDF to XLSX or CSV and paste the result into your sheet.
Last updated August 2026
Real cells
Not a picture
OCR
Reads scanned PDFs
Any Excel
Mac and Windows
Numeric
Ready to total
What inserting a PDF into Excel actually does
Insert, Object, Create from File embeds the PDF as an OLE object. Excel stores a copy of the whole file inside the workbook and shows you either the first page of it or an icon, depending on whether you tick Display as icon. Double clicking opens the file in your PDF reader. You can drag the object anywhere on the sheet and resize it with the handles.
What you do not get is data. The embedded object floats above the grid rather than living in cells, so a column of amounts inside it cannot be summed, sorted, filtered, or referenced by a formula. Search will not find text in it. Two other things catch people out: the workbook grows by roughly the size of the PDF you embedded, and Microsoft notes that inserting an object turns AutoSave off, which matters if the file is shared on OneDrive or SharePoint.
That is fine when the PDF is an attachment, a signed contract or a supporting document that just needs to travel with the workbook. It is the wrong tool when the PDF holds a table you meant to work with. For that, run it through the PDF to Excel converter and paste real rows into your sheet.
| Invoice | Vendor | Amount |
|---|---|---|
| INV-4471 | Cascade Supply | 2,840.00 |
| INV-4472 | Northline Freight | 1,215.60 |
| INV-4478 | Ridgeway Print | 396.25 |
| INV-4483 | Cascade Supply | 1,904.00 |
Embed the same invoice PDF and this table would be a flat picture. Convert it and the Amount column is true numbers, so a SUM, a filter by vendor, and a pivot all work straight away.
Embed, link, or convert: which one you want
All three put a PDF and a spreadsheet together. They solve completely different problems, and picking the wrong one is why people end up with a workbook they cannot calculate on.
| Method | What lands in the sheet | Can you calculate on it | Best for |
|---|---|---|---|
| Insert, Object, Create from File | A copy of the PDF shown as its first page or an icon | No | Keeping a contract or receipt attached to the workbook |
| Insert, Object with Link to file | A pointer to the PDF sitting elsewhere on disk | No | Big files you do not want bloating the workbook |
| Insert, Link, Hyperlink | Clickable text in a cell pointing at the file | No | A reference column next to rows you already have |
| Insert, Picture (screenshot of the PDF) | A flat image of one page | No | Illustrating a slide-style summary tab |
| Data, Get Data, From PDF | Tables loaded through Power Query | Yes | Clean digital PDFs, if your Excel build has the connector |
| Convert the PDF first | Rows and columns of real values | Yes | Any Excel version, any PDF, scans included |
The From PDF connector ships with Microsoft 365 and some recent builds only, and it has no OCR. If it is missing from your Data tab, see how to import a PDF into Excel without Microsoft 365.
How to insert a PDF into Excel, step by step
This is the genuine embed route, for when you want the file itself riding along in the workbook.
Click the target cell
Select the cell where the object should sit. Excel anchors it there, though you can drag it afterwards.
Insert tab, then Object
Object lives in the Text group, on the right-hand side of the Insert ribbon. On a narrow window it hides behind the Text button.
Create from File, Browse
Switch to the Create from File tab, browse to the PDF, and select it. Tick Link to file if you would rather point at the file than copy it in.
Choose page or icon
Leave the boxes clear to show the first page, or tick Display as icon for a compact marker. Click OK and double click any time to open it.
Only the first page shows, and that is normal
A common complaint is that a ten-page statement embeds as a single page. That is the documented behavior: with no checkbox ticked, Excel renders the first page as the object's preview and keeps the rest inside the file. Double clicking opens the complete PDF. If people need to read all of it in the sheet, embedding is the wrong answer. Convert the pages into rows, or use a hyperlink and keep the PDF where it lives.
When you should convert the PDF instead
If any of these describe why you opened the Insert menu, embedding will not get you there.
You need to total a column
Amounts inside an embedded object are pixels. Converted, they are numbers, so SUM, SUBTOTAL, and a pivot table all work on the first try.
You need to search or filter it
Ctrl+F does not look inside embedded objects. Once the rows are cells, you can filter by vendor, date, or amount like any other list.
You are reconciling against other data
Matching a statement to your ledger needs lookups. Convert first, then XLOOKUP or compare two columns.
The PDF is a scan
A scanned page has no text layer at all, so even Power Query returns nothing. OCR reads it and writes out real values.
The workbook is getting heavy
Every embedded PDF adds its full size to the file. A dozen statements make a workbook that crawls and clogs email. Converted rows cost kilobytes.
You have a stack of them
Embedding is one file at a time. The batch converter takes the whole folder and returns one workbook.
The documents people try to insert
| Document | Why it ends up in a workbook | Embed or convert |
|---|---|---|
| Bank statement | Reconciling the month against the ledger | Convert |
| Vendor invoice | Coding lines to accounts, checking totals | Convert |
| Signed contract | Proof that travels with the deal tracker | Embed |
| Expense receipt | Backup attached to a claim line | Embed, or convert for the amounts |
| Trial balance | Building the working paper it feeds | Convert |
| Price list | Comparing quotes across suppliers | Convert |
| Certificate or permit | Evidence next to a compliance row | Embed or hyperlink |
Rule of thumb: if a human will read it, embed it. If a formula will touch it, convert it. Plenty of workbooks want both, the converted rows for the math and the original PDF embedded alongside as the source of record.
Insert PDF into Excel: common questions
Yes. Use Insert, Object, Create from File, Browse, then pick the PDF. Excel embeds the whole file and shows either its first page or an icon, and a double click opens it. The catch is that it goes in as an object rather than as data, so nothing inside it can be sorted, filtered, or added up. Convert the PDF if the numbers are the point.
Embedding is the same Insert, Object, Create from File path with Link to file left unticked. That copies the PDF into the workbook so it travels with the file when you email it. Tick Link to file instead and Excel stores only a path, which keeps the workbook small but breaks if the PDF moves or the recipient cannot reach that folder.
Because that is what Excel is designed to do. When you embed a file without ticking Display as icon, Excel renders the first page as the preview and stores the rest inside the object. Double clicking opens the complete document in your PDF reader. There is no setting that spreads the remaining pages across the sheet, so a multi-page report needs converting rather than embedding.
You cannot, not through Insert. An embedded object stays a PDF and Excel will not turn it into editable cells. To get editable data, convert the PDF to XLSX or CSV first, then paste or open the result. Upload the file at the top of this page and you get a sheet where each value sits in its own cell, ready to edit, sort, and total. The editable Excel converter covers this route in full.
Excel for Mac has Insert, Object, so embedding works, though the dialog is laid out differently and some builds are fussier about which file types preview properly. The bigger gap on Mac is the Data, Get Data, From PDF connector, which is not included at all. Converting in the browser sidesteps both issues, since the output is a standard XLSX that Excel for Mac opens normally.
Yes. Embedding copies the entire PDF into the workbook, so a 4 MB statement adds roughly 4 MB to the file, and a folder's worth quickly makes a workbook that is slow to open and too big to email. Ticking Link to file avoids the bloat but leaves you dependent on the path. Converting the tables to rows costs a fraction of the size because you are storing text and numbers, not a document.
It depends on who is going to use it. Insert the PDF when a person needs to open and read the original, such as a signed agreement kept beside its deal row. Convert it when a formula needs the contents, which covers statements, invoices, ledgers, and anything you plan to reconcile. Many finance workbooks do both: converted rows for the calculations, the source PDF embedded as evidence.
More PDF to Excel options
PDF to Excel Converter: Convert PDF to Excel Online
Convert PDF to Excel online with a converter built for business. Keeps tables intact and numbers numeric, runs OCR on scans, exports clean XLSX or CSV.
FeaturesAI PDF to Excel Converter: Convert PDF to Excel With AI Accuracy
Convert PDF to Excel with an AI converter that reads tables and scanned files, keeps numbers numeric, and exports clean XLSX or CSV. Free to preview.
FeaturesPDF to XLSX Converter: Convert PDF to XLSX Online
PDF to XLSX converter that writes a native Excel file with real cell structure: numbers numeric, dates as dates, tables aligned. OCR included, free to preview.
FeaturesPDF Table Extractor: Extract Tables From PDF to Excel
Extract tables from PDF to Excel automatically. A PDF table extractor that keeps rows and columns aligned, handles merged and multi-page tables, and reads scans.
Put the PDF's numbers in your sheet
Embedding keeps the document. Converting gives you the data. Drop a PDF at the top of the page and download an XLSX or CSV with the columns mapped and the values ready to total. If you also need the tables out of a mixed document, the PDF table extractor pulls just the grids, and importing PDF data into Excel walks through the Power Query route.