PDF 转 Excel

这款工具的作用

This finds the tables in a document and writes them into an .xlsx workbook. A PDF never records that something is a table, so the columns are located geometrically, from the vertical gutters that survive every row. Values that read cleanly as numbers are written as numbers, which is the difference between a column you can sum immediately and one Excel refuses to add up.

Bank statements, invoice line items, a supplier price list published only as a PDF, the results table in a report you need to chart - anywhere the figures are visible on the page and retyping them is the only other option.

工作原理

1. Drop the PDF onto this page. One file at a time, up to 200 MB.
2. Leave the confidence threshold at 55%. Lower it if a table was missed, raise it if something that is not a table came out as one.
3. Leave joining across pages on for a table that continues overleaf, or switch on a sheet per page to keep them separate.
4. Leave the header row option on so a heading repeated on a continuation page is not written in as data.
5. Press Convert to Excel.
6. Check the first and last rows of each sheet, where detection is least certain.

Two facts drive the detection. The first is that numeric columns align on their right edge, not their left, so a detector clustering only the start of each run reads 12.00 and 1,234.00 as two different columns - exactly on the financial statements that are most of what anyone converts. Alignment here is scored on the best of the start, end and centre consistency, so a left-aligned description column and a right-aligned money column both score well in the same table.

The second is that a wrong table is worse than no table. Two columns of prose have pin-sharp left edges and a wide gutter down the middle, and by alignment alone they look better than most real tables. Geometry cannot separate them, so there is a further gate on what the columns contain, and it rejects outright rather than quietly lowering the score. That is why a page of newspaper-style text does not arrive as a two-column spreadsheet.

Numbers keep the formatting they were printed with, and it has to come off before a cell can hold a real number: thousands separators, currency symbols, trailing percent signs, and negatives written in accountancy brackets, which become a minus. A comma is only removed when exactly three digits follow it, because it is a thousands separator in English and a decimal point in Indonesian. Anything still ambiguous stays text on purpose - a misplaced decimal point is worse than an unformatted cell.

When nothing reads as a table, the tool says so and points at PDF to text rather than handing you an empty workbook, which would imply the document had nothing in it. Lowering the confidence threshold is the first thing to try; reading the page with PDF to text is the second.

Detection and the writing of the workbook both happen on your device, the OOXML built and zipped in the browser, so a bank statement is never sent anywhere to be read. That matters more here than on most tools: the documents people convert to spreadsheets are usually the ones with account numbers on them.