Bank statements and invoices arrive as PDFs, but the work you want to do with them happens in a spreadsheet: categorizing expenses, preparing figures for an accountant, reconciling invoices or building a budget. Copying a few hundred rows by hand is slow, and pasting from a PDF usually lands everything in one column.
A table converter rebuilds the rows and columns for you. It gets you most of the way there, quickly. The remaining work is cleaning a few columns and proving that the numbers match the original, which is the part you should never skip with financial data.
Try it: PDF to ExcelConvert tables in PDF bank statements, invoices and reports into an editable Excel (.xlsx) spreadsheet with rows and columns rebuilt automatically.
Open tool — freeBefore converting, look for a better source
Check your online banking first. Many banks let you download transactions directly as CSV or a spreadsheet file, and that’s always cleaner than anything extracted from a PDF. Accounting and invoicing software often offers CSV exports too.
If you already have a CSV and simply need it as an Excel file (or as JSON for a budgeting script), our CSV, JSON and Excel converter handles that, with automatic delimiter detection and a preview. Our guide to CSV vs JSON vs Excel explains the differences.
PDF conversion is the right move when the PDF is all you have: older statements, documents someone emailed you, or invoices from suppliers.
How to convert a statement PDF to Excel step by step
- Confirm the PDF contains real text. Try selecting a transaction line. If you can highlight individual words and numbers, it’s text-based and will convert well.
- Open our PDF to Excel converter and add the file. It works in your browser, so the statement never leaves your device. With bank data, that matters.
- Convert and download the .xlsx file. The tool rebuilds rows and columns from the tables it finds.
- Open it in Excel, Google Sheets or LibreOffice Calc and save a working copy, keeping the raw conversion untouched for reference.
- Clean the columns as described below.
- Verify the totals against the statement before you use the data for anything.
Cleaning up the columns
Statement layouts vary a lot between banks, so expect some tidying. These are the usual suspects.
Repeated headers and page furniture
Each page of a statement typically repeats the column headings, plus a page number, account details and maybe a running “balance carried forward” line. Filter the date column for non-dates and delete those rows, or sort temporarily and remove them as a block.
Descriptions split across lines
Long merchant descriptions sometimes wrap onto a second line in the PDF and come through as an extra row with only text in it. Join them back to the row above, or delete the overflow if the first line identifies the transaction well enough.
Amounts stored as text
If a SUM gives zero or a cell is left-aligned, Excel is treating the amount as text. Common causes:
- Currency symbols or codes in the cell. Use Find and Replace to remove them.
- Thousands separators that don’t match your system’s settings.
- Negative amounts written as
(45.00),45.00-or with CR and DR labels. Convert them to a consistent minus sign. - Stray spaces. The
TRIMfunction or Find and Replace fixes these.
Dates in the wrong format
A statement from one country may use day/month/year while your spreadsheet expects month/day/year, or the reverse. Watch for dates like 03/04 that are ambiguous. Excel’s Text to Columns feature lets you tell it the source date order, which is more reliable than retyping.
Separate debit and credit columns
Many statements have money out and money in as two columns. For analysis, a single amount column (negative for debits) is usually easier: =C2-B2 or similar, depending on which column is which.
Checking that the numbers are right
This is the step that makes the spreadsheet trustworthy. Converters are good, but a single misread digit or a dropped row can throw everything off, and you won’t spot it by eye.
| Check | How to do it |
|---|---|
| Balance check | Opening balance + total credits – total debits should equal the closing balance on the statement |
| Row count | Count transactions on a page of the PDF and compare with the same date range in the sheet |
| Running balance | If the statement has a balance column, recompute it and flag any row where yours differs |
| Spot check | Compare the largest few amounts and a handful of random rows with the PDF |
If the balance check works to the cent, you can be confident the data is complete. If it’s off, the running balance comparison usually pinpoints the exact row where things went wrong.
Scanned statements need OCR first
If you couldn’t select any text in step 1, the PDF is a scan: a picture of a statement. There are no numbers in it for a table converter to read.
Your options, in order of preference:
- Get a digital copy. Download the statement again from online banking, or ask the bank for one. This is almost always worth the effort.
- Run OCR. Recognize the text first, then rebuild the table. Our guide to OCR for scanned PDFs covers how to get the cleanest result.
- Check everything twice. OCR can confuse 1 and 7, 5 and 6, or drop decimal points. With scanned financial data, the balance check above isn’t optional.
Invoices and reports work the same way
The same process applies to invoices, price lists and reports with tables. Invoices tend to be easier because they’re shorter, but each supplier’s layout differs, so converting a batch from several suppliers will give you slightly different columns for each. Standardize the columns before combining them into one sheet.
Keep a note of which file each row came from, too. A “source” column with the invoice number or file name makes it easy to trace a figure back later.
The bottom line
Use the bank’s own CSV export if it exists. Otherwise, convert the text-based PDF, strip out repeated headers, turn amounts and dates into proper numbers and dates, and then prove the data with a balance check before you rely on it. If the numbers reconcile to the cent, your spreadsheet is ready to use.
Frequently asked questions
Can I convert a scanned bank statement to Excel?
A scanned statement is an image, so a table converter has no text to read. Run OCR first or, better, download the statement again from online banking as a text PDF or CSV, then expect to check every figure.
Why are my converted amounts not adding up in Excel?
Usually some amounts came through as text instead of numbers, often because of currency symbols, thousands separators, or minus signs written as CR, DR or parentheses. Clean those columns and convert them to numbers before summing.
Is it safe to convert bank statements online?
It depends on the tool. Many converters upload your file to a server; a browser-based converter processes it on your own device so the statement never leaves your computer.
