PDF to Excel Converter

A table in a PDF is not stored as rows and columns. The file only knows that a string of characters sits at a certain position on the page, and that some thin lines are drawn nearby. When you copy and paste from a PDF viewer, Excel receives lines of text with spaces between them, and every value ends up in column A.

The converter does the opposite of pasting. It looks at how text lines up vertically and horizontally, uses ruling lines where they exist, and works out which values share a row and which share a column. Each detected table is then written as real cells, with header rows kept at the top.

This works best on tables with a clear grid: bank and card statements, invoices, price lists, timetables and financial reports. Tables drawn as pictures, for example in a scanned fax, go through OCR first, which makes clean source pages more important.

XLSX is the workbook format Excel has used by default since 2007, and it opens in Google Sheets, Apple Numbers and LibreOffice Calc as well. Microsoft's Excel specifications page lists 1,048,576 rows by 16,384 columns per worksheet, so even a year of daily transactions fits on one sheet.

Each workbook is a normal Office Open XML file with no macros, so it opens without security prompts. The first row of each table stays a header row you can freeze or turn into a filter, and the sheets are named in the order the tables appear in the PDF.

Once the workbook is open, apply your own number formats, currency symbols and column widths. Those choices depend on how you plan to use the data, and setting them yourself takes seconds once the values sit in the right cells.

Before you rely on the workbook, compare one total with the PDF. Most statements and invoices print a closing balance or a grand total; add up the converted column with a SUM formula and check that the two match. If they do, the rows were split correctly.

When a total is off, the usual causes are a row that wrapped onto two lines in the PDF, a value in brackets meaning a negative amount, or a thousands separator that differs from your Excel settings. Each of these is quick to fix with a filter on the affected column, and a cleaner scan avoids most of them in the first place.

A monthly statement that spans twelve pages is easiest to work with on one sheet, where a single filter covers every transaction. A quarterly report with a balance sheet, an income statement and a cash flow table reads better with one sheet per table. You can convert the same PDF twice with different settings and keep whichever workbook suits you.

If you need the paragraphs rather than the numbers, the PDF to Word tool keeps the full text, and the PDF Converter page lists every other output, including CSV and JSON for feeding tables into other software. Workbooks saved in the old .xls format can be brought up to date with XLS to XLSX.