Bank statement to Excel › Guides
Convert a bank statement PDF to Excel without uploading it
A statement lists your employer, your landlord, your doctor and every shop you use. Many "free PDF to Excel" sites send the file to their servers to convert it. You can get the same list of transactions without the file ever leaving your computer.
Verified sample The sample below was produced by running this site's converter on a synthetic statement. It is not real data.
Steps
- Download the statement as a PDF from your bank. Use the PDF the bank generates (online banking, "Statements"). A photo or scan of a paper statement has no text layer and will not work.
- Open the bank statement converter and drop the PDF on it. Several statements can go in together, for example twelve months for a tax return.
- Read the balance check. The converter adds up the running balance row by row and says how many rows reconcile. All of them reconciling means every amount and balance was read correctly. A mismatch means a row was misread, so look at that row in the preview.
- Check the dates. Statements that print dates such as 03/04/2026 are ambiguous (3 April or March 4). The converter works it out from the other dates where it can, and says so when it had to assume. Change the date-order setting if the preview looks wrong.
- Download Excel or CSV. Money out is negative, money in is positive. With several files you get one list, sorted by date, with repeated rows from overlapping statements removed only when date, text, amount and balance all match.
- Check that nothing was sent. Open your browser's developer tools (F12), choose the Network tab, then convert a file. You will see the page's own files load, and no request that carries your PDF. The page's security policy also blocks connections to other sites.
Sample: a synthetic statement, converted
Date Description Amount Balance 2025-12-15 TRANSFER TO SAVINGS -300.00 950.00 2025-12-16 TRANSFER FROM SAVINGS 36.50 986.50 2025-12-17 INTEREST PAID 1830.25 2816.75 2025-12-18 RENT PAYMENT LANDLORD LLC -4.75 2812.00 2025-12-20 COFFEE HOUSE 0098 -62.18 2749.82 2025-12-21 ELECTRIC UTILITY AUTOPAY REF 8841-22 CARD ENDING 4021 -54.32 2695.50
40 transactions from 2 pages. Running balance: 40 of 40 rows reconcile.
When this will not work
Scanned statements, statements that are password protected, and layouts that put several transactions on one line are not handled. The converter is tested on synthetic statements in six common layouts, not on every bank, so always read the balance check before you import the result into accounting software.