PDF to Excel

The sensitivity control, and when to change it

No converter reads a PDF the way you read it. A PDF stores text as items placed at coordinates, with no record of which ones form a table. Detection works by grouping items that sit at the same height into rows, then finding the vertical positions where columns line up.

That guess needs a tolerance, and this is the one tool that lets you set it. Auto is the default and handles most documents. Switch to Conservative when separate columns are being merged into one cell — it demands tighter alignment before treating items as the same row or column. Switch to Aggressive when a table is not being recognised at all, or when one row is splitting across two — it tolerates looser alignment.

If the first attempt looks wrong, changing this setting and converting again is usually enough. That single option is what everywhere else replaces with a support page.

What you get, and what defeats it

Pages that look like tables come out as proper rows and columns. Pages that do not are still included, with each line of text in a single cell, which keeps the content without inventing columns that were never there. That is deliberate — fake columns are harder to clean up than plain text.

Two things this cannot do. A scanned PDF will not work at all: those pages are pictures of text, there is nothing to read, and the tool says so rather than handing you an empty workbook. There is no OCR here. And a table split by a page break becomes two sheets, because the conversion works page by page.

Merged cells, nested headers and tables with heavy styling will need tidying afterwards. Getting the numbers into Excel is the slow part; adjusting a header row takes a moment.

Only the pages you need

By default every page is converted. Choose Specific pages and enter something like 1,3,5-8 to take just the pages with tables on them — useful on a long report where the appendix is the only part you want, and it makes the conversion faster too.

Nothing is uploaded

The extraction happens on your own device. Given that the most common input here is a bank statement, an invoice or a payroll report, that is worth more on this page than on most.

Related tools

PDF to Word converts a PDF to editable text when it is prose rather than tables. Extract Text from PDF pulls out plain text with no structure at all, and Excel to CSV Converter turns the finished workbook into CSV for whatever system needs it next.