How to get a table or bank statement out of a PDF and into Excel

Copying a table out of a PDF and pasting it into a spreadsheet usually produces one long column of jumbled values. The table looks like a grid, but the PDF does not store it as one — and understanding that is the key to getting clean data out.

Why PDF tables are hard to extract

A PDF has no concept of rows, columns or cells. It stores pieces of text at exact positions on the page, plus lines drawn between them. A table is simply text that happens to line up. To rebuild it, a tool has to group text that sits on the same line into rows, then find the horizontal positions where most rows agree a column begins. That works very well on tables generated by software and less well on hand-designed ones with merged cells.

Before you start: is there a better source?

Check whether the data exists in a spreadsheet format already. Most online banking services let you download transactions as CSV or Excel, and accounting systems, shops and reporting tools usually export data directly. A direct export is always more reliable than extracting from a PDF. When the PDF is all you have, read on.

Check that the PDF contains text

Try to select a figure in the table with your mouse. If individual numbers highlight, the PDF contains real text and can be extracted. If nothing highlights, the page is a scanned image. Text recognition can read the numbers out of a scan, but the table structure is lost along the way, so expect to rebuild the columns by hand.

Which tool to use

• PDF Table Extractor — for a table that runs across many pages, like a bank statement. It stacks the pages into one sheet, removes the header row when it repeats at the top of each page, and turns figures such as 1,234.50 or (45.00) into real numbers.
• PDF to Excel — for documents with separate tables on separate pages. Each page becomes its own sheet, and you can preview the detected grid before downloading.

Extract a bank statement step by step

1. Add the statement to the PDF Table Extractor.
2. Choose only the pages that contain the transaction table. Summary pages, adverts and notes add stray rows.
3. Choose One sheet, so the pages are stacked into a single table.
4. Look over the preview, then download it as an Excel file or as CSV.

Bank statements are among the most private documents most people own. The extraction runs in your browser, and the statement is not uploaded anywhere.

Check the result — properly

An extraction can look right and still be wrong in one row out of two hundred. A few checks catch nearly every problem:

• Add up a column and compare it with a total on the statement. If the sum of money in and money out matches the statement's own totals, no amounts have gone missing or moved column.
• Check the running balance. Opening balance plus the transactions should equal the closing balance printed on the statement.
• Count the rows on one page against the PDF.
• Look for split rows. A long description that wraps onto a second line in the PDF can become a row of its own with no amount. Merge it into the row above.

Numbers, dates and codes

• Brackets mean negative. Accountants write −45.00 as (45.00), and the Table Extractor converts it that way. Check that this matches your document.
• Leading zeros are kept. Account codes and reference numbers such as 00123 are kept as text, because turning them into numbers would drop the zeros.
• Ambiguous decimals are left alone. A figure like 1.234,50 means one thousand two hundred in much of Europe and something else in the UK and US, so it is not guessed. Convert those cells in your spreadsheet once you know which convention the document uses.
• Dates can be misread by spreadsheets. 03/04/2026 is 3 April in most of the world and 4 March in the United States. If your spreadsheet's regional settings differ from the statement's, check a date with a day above 12 to see which way round it was read.

Excel file or CSV?

Choose the Excel file when you will work in Excel, Google Sheets, Numbers or LibreOffice. Choose CSV when the data is going into another program — accounting software, a budgeting app or a database — since almost everything can import it. If CSV columns arrive merged when you open the file, your spreadsheet may expect a semicolon instead of a comma, which is common in regions that write decimals with a comma.

When you only need the words

For a table you only want to read or quote, not calculate with, PDF to Text gives the contents line by line without any spreadsheet in between.