Skip to content

Bank statement to Excel, without uploading it anywhere

By the getPDF team · Published 11 October 2026

The short answer

Drop the statement PDF on the converter below and download the .xlsx: each transaction becomes a row with the date, the description, the amount and the balance in their own columns, and the amounts arrive as real numbers you can sum. It runs on your device, so the statement is never uploaded. Check the result once by summing the amount column against the closing balance. A scanned or photographed statement needs OCR first.

Convert the statement now

Try it here, nothing is uploaded

PDF · any size · many at once

Before you go looking for a converter at all: check your online banking. Many banks offer a transaction export as CSV or Excel, and that is the bank’s own data with nothing reconstructed. Convert the PDF when the export does not exist, does not reach back far enough, or when the PDF is all you were sent.

Why a bank statement should not go to an upload converter

A statement is the most revealing document most people own. It carries your account number and IBAN, your balance, your salary and your employer, your rent and your landlord, and every shop, doctor and subscription you paid that month. An online converter that uploads it hands all of that to a server you know nothing about, often under a free tier that keeps files “for 1 hour”.

The converter on this page runs in your browser. The file is read in your tab and the spreadsheet is written there; you can test that by converting once (the first file fetches the engine, which your browser then keeps), turning Wi-Fi off and converting again. The wider story is in PDF privacy and protection.

The steps, with a real result

  1. Drop the PDF on the tool above. A statement downloaded from online banking has real text in it, which is what the converter reads.
  2. Pick the sheets. The default is “One per page”. For a statement of several pages, choose “All on one”, so the transactions run in 1 list (pages are separated by an empty row).
  3. Keep “Excel (.xlsx)” as the format unless you are importing into accounting software; for CSV, pick the separator that matches your Excel (below).
  4. Convert and open the file. The result card says how many rows it wrote and how many cells became numbers.

We ran an invented October statement for Jana Čermák in Linz through the converter: an opening balance, 6 transactions with European decimal commas, and a closing balance. The card said “Put 12 rows into a spreadsheet, with 14 numbers as numbers you can add up”. The transaction part of the sheet looked like this:

A B C D
4 Date Description Amount Balance
5 01.10.2026 Opening balance 2140.55
6 02.10.2026 Rent October, Graz Lettings -1250 890.55
7 05.10.2026 Salary Studio Lumen 3412.8 4303.35
8 09.10.2026 Card payment Spar Linz -64.19 4239.16
9 14.10.2026 Direct debit Energie -118.4 4120.76
10 21.10.2026 Transfer from Karol Michał 45 4165.76
11 28.10.2026 Card payment Łódź Books -23.9 4141.86
12 31.10.2026 Closing balance 4141.86

The statement printed “-1.250,00”; the sheet holds the number -1250, which Excel shows in whatever number format you give the column. The header lines above row 4 (title, account holder, account number) come along as single cells, so nothing on the page is lost. The result was the same whether the statement drew lines between its columns or only left gaps.

Check it in 30 seconds: sum against the balance

Never trust a converted statement until it adds up. In the sheet above:

  1. In an empty cell, type =SUM(C5:C12). It gives 2001.31.
  2. In the next cell, type =D12-D5, the closing balance minus the opening balance. It also gives 2001.31.
  3. If the 2 match, every amount arrived, with the right sign. If they do not, the difference is the size of the missing or misread amount, which tells you which row to look at.

This check catches every kind of miss at once: a skipped row, an amount in the wrong column, a minus sign lost. Do it on the first statement from each bank; after that the layout is known and you can spot-check.

Several months in 1 sheet

  1. Convert each month’s statement to its own .xlsx, with “All on one”.
  2. Make a new workbook with the same 4 columns, plus a fifth called Statement.
  3. Paste each month’s transaction rows under the last, without the header rows and without the opening and closing balance rows, and fill the Statement column with the month (2026-10, 2026-11).
  4. Run the sum check per month before you paste, not on the combined sheet: a miss is far easier to find in 1 month than in 12.

The Statement column lets you filter back to a single month later and keeps a trail to the source PDF.

The traps, and what fixes each

  • Dates arrive as text. The converter keeps 01.10.2026 as it is written, on purpose: a US-set Excel would otherwise read it as 10 January. To sort by date, select column A, then Data, Text to Columns, Next, Next, choose Date and DMY, Finish.
  • Account numbers and IDs keep their leading zeros. A value like 0012345678 stays text, so Excel does not shorten it to 12345678, and a long card or reference number is not turned into scientific notation. PDF to Word, Excel and text explains how the converter tells numbers from IDs.
  • A description that wraps onto 2 lines becomes 2 rows. We tested it: “Rent October,” stayed in the transaction row with its amount, and “Graz Lettings” landed in a row of its own in column A. The sum is not affected, because the amount stays in its row, but delete or merge those half rows before sorting.
  • CSV in a European Excel. An Excel set to German, French or Polish expects semicolons between fields and a decimal comma, so a comma CSV double-clicked there lands entirely in column A. When you pick CSV, set Separator to “Semicolon, 1190,50”: the fields are split by semicolons and -64.19 is written -64,19, so that Excel opens it in columns with the amounts as numbers. “Comma, 1190.50”, the default, suits Excel in English, Google Sheets and most software. The .xlsx needs neither: it opens correctly in every language. For accounting software, CSV is usually the format the import asks for.

When the statement is a scan or a photo

A statement you scanned, photographed or received as a picture has no text in it, only pixels. The converter detects this and stops with a pointer: “There is no text in this file to put in a spreadsheet: it is probably scanned. Run OCR PDF first, then convert it.”

OCR PDFSearchable text layer, 100+ languages. Free, runs on your device.

We tested that route too: the same statement rendered as a 200 dpi greyscale scan, run through OCR PDF (94 % average confidence), then converted. Every amount and balance came through as the right number. The difference: the date and the description landed together in column A (“02.10.2026 Rent October, Graz Lettings”), because a scan’s column lines are part of the picture, not drawn lines the converter can use. Two formulas split them again: =LEFT(A6,10) for the date and =MID(A6,12,200) for the description. The sum check matters even more here, because OCR can misread a digit. The full OCR route is in Scanned PDF to searchable.

The honest part

Statement layouts differ from bank to bank, and the converter works out columns from where the text sits on the page. Most statements are a clean grid and convert like the example above. Statements with 2 tables side by side, a running balance printed in the description, or amounts split into separate debit and credit columns convert too, but need a look before you rely on them; the result card warns about this every time. It does not keep colours, fonts or cell borders, and it does not know which column is the amount: you tell Excel that with your formulas. And if your bank offers a CSV export, that file beats any conversion, ours included.

Questions

Will the amounts be numbers I can add up?

Yes. Amounts written 1.250,00, 1,250.00, (12.50) or 12.50- become numbers in the sheet. On our test statement all 14 amounts and balances arrived as numbers, and the sum of the amount column matched the closing balance minus the opening balance to the cent.

Why are the dates text and not dates?

The converter keeps dates exactly as written, so 01.10.2026 is never turned into the wrong day by a US-style Excel. To sort by date, select the column and use Data, Text to Columns, and pick Date with the order your bank uses (DMY in most of Europe).

Does my bank statement get uploaded?

No. The PDF is read and the spreadsheet is written in your browser tab. Convert once, turn Wi-Fi off and convert the next statement: it still works, because nothing needs a server.

My statement is a scan or a photo. Does this work?

Not directly: a scan has no text, and the converter says so. Run OCR PDF first, then convert the searchable copy. Amounts come through well; the date and the description can land in 1 cell, which 2 formulas split.

Can I put several months into 1 sheet?

Yes. Convert each statement, then copy the transaction rows of each under the last, with a column that names the month.

The tools for this job