FastBankConvertFastBankConvert home

PDF to Excel Add In: Converting Inside the Workbook

By FastBankConvertPublished March 17, 2025Updated March 17, 2025

A PDF to Excel add-in is a small tool you install from Excel's add-in store that opens a side panel, takes a PDF from you, and writes the extracted table into your sheet. Most of these add-ins are web apps, so check where they send the file and which workbook permissions they ask for before you install one.

What does a PDF to Excel add-in do inside the workbook?

A PDF to Excel add-in puts a button on the ribbon and opens a task pane beside your sheet. You pick a PDF in the pane, the add-in extracts the table, and it pastes the rows into the active sheet or a new one. The conversion itself usually runs on the add-in maker's servers, not inside Excel.

That last point surprises people. Microsoft describes an Office add-in as a manifest file that points to a web application holding the code and logic, in its guide to deploying Office Add-ins in the Microsoft 365 admin center. The pane you see is a web page running inside Excel. The same page notes that the web application behind an add-in can change at any time.

The benefit is convenience. The result lands where you are working, so you skip a download and a copy step. The cost is that you now trust a third party with both the PDF and some access to your workbook.

A PDF to Excel add-in compared with Get Data from PDF

Excel already has a built-in PDF import under Data, Get Data, From File, From PDF. It reads text-based PDFs on your own computer and lists the tables it found. An add-in is worth adding only if it does something that import cannot, such as reading scans or merging a statement's pages into one clean list.

The built-in import has limits worth knowing. It finds tables, not transactions, so a bank statement often comes back as one table per page with headers repeated. It cannot read a scanned page with no text layer. If you are unsure whether you need anything beyond Excel at all, whether you need a PDF converter if you have Excel goes through the cases one by one.

Language is another gap. Files in other scripts can come through the import with broken characters, and an add-in may or may not do better. How Chinese PDFs behave in Excel, with their fonts and dates shows what to test if your PDFs are not in English.

Which add-in permission levels should you read before installing?

Every Office add-in declares a permission level in its manifest, the file that describes the add-in to Office. Microsoft defines five levels, from restricted up to read/write document. A converter that pastes rows into your sheet needs to write, but you should still know what each level allows.

The levels come from Microsoft's page on requesting permissions for API use in add-ins. The right-hand column is our reading of what each means for a PDF converter.

Permission level What Microsoft says it allows What it means for a converter add-in
Restricted Settings and the active view only Cannot insert rows, so too little for a converter
Read document Read the selection and the document's text Can see your data but not write the result
Read all document Adds the full underlying file contents Can read the whole workbook, more than a converter needs
Write document Write to the current selection Enough to paste a converted table where you click
Read/write document All remaining add-in APIs, including events Full access to the open workbook

Do not be alarmed if a converter asks for read/write. Microsoft notes that add-ins using Excel's own application APIs must declare read/write even when they only read, and that most marketplace add-ins sit at that level. The level tells you what the add-in could do, not what it does. That is why the next question matters.

Does a PDF to Excel add-in send the PDF to a server?

Most PDF to Excel add-ins send the PDF to a server, because the pane is a web app and the extraction runs in the maker's cloud. Read the add-in's privacy policy for three answers: where the file goes, how long it stays, and whether anything from your open workbook is sent along with it.

Before you install, run this three-question check:

  1. Who publishes it? A named company with a support address is better than an anonymous listing.
  2. What is the retention rule? Look for a plain statement, such as deleted after conversion.
  3. Does it need my workbook? If the add-in only inserts rows, there is no reason for it to read other sheets.

If your file must stay on your machine, an add-in that uploads is the wrong choice. The routes in converting PDF to Excel without uploading the file keep the PDF local from start to finish.

When a PDF to Excel add-in is not worth the install

A PDF to Excel add-in is not worth installing when Excel's own import already handles your files, when you convert a PDF only now and then, or when your company blocks add-ins. In those cases the extra permissions buy you a few saved clicks and nothing more.

Work laptops are the common blocker. Admins can deploy add-ins centrally to chosen users and groups through the admin center, so on a managed laptop the add-in you want may simply not be offered. If you cannot add it yourself, ask IT to deploy it rather than looking for a way around the block.

For bank statements, a dedicated converter that checks the balances often beats an add-in that only finds tables. What separates a good PDF to Excel converter from a bad one gives the tests to run on any tool, add-in or not. FastBankConvert takes the website route rather than an add-in: you drop a statement on the page and download Excel, CSV or JSON. It is getting ready to open, and Get started puts you on the list for trial conversions.

All posts in Choosing a converter