Getting your transactions into a spreadsheet makes budgeting, tax returns, expense claims and loan applications far easier. But a bank statement is one of the most sensitive documents you have, and most “PDF to Excel” websites work by uploading it to their server. This guide covers the ways to do it that keep the statement private, from best to last resort, and how to check the spreadsheet afterwards.
The short answer
- Export from online banking. Most banks let you download transactions as CSV or Excel directly. It’s the most accurate option.
- Convert the PDF statement on your device with PDF to Excel or PDF to CSV, which run in your browser without uploading anything.
- Paper or scanned statements need text recognition first, covered at the end.
Why uploading a statement is a risk
A statement holds far more than a list of payments. It shows your full name, home address, account number and sort code or routing number, your employer (from salary payments), where you shop, when you’re paid and how much you have. That’s exactly the information used for identity fraud and convincing phishing messages (“We noticed a payment to your landlord…”).
When you upload a statement to an online converter, you’re trusting that company to delete it, not to log it, and not to be breached. Many free converters don’t say where files are processed or how long they’re kept. A converter that works entirely in your browser avoids the question, because the file never leaves your device.
How to check a converter yourself: convert any harmless file first, so the page has everything it needs. Then switch off Wi-Fi or mobile data and convert your statement. If it still works, the file can’t have been uploaded. The xconverter tools pass this test.
Option 1: Export from online banking (best)
Banks keep your transactions as data, so an export gives you exact dates, amounts and descriptions with nothing to fix. Look in your online banking website (exports are often missing from banking apps) for wording such as:
- Download transactions, Export or Download statement data
- Usually found on the account’s transaction list or the statements page
- Choose a date range, then a format
| Format | Use it for |
|---|---|
| CSV | Excel, Google Sheets, budgeting apps. The safest general choice. |
| XLS / XLSX | Opening directly in Excel. |
| OFX, QFX or QIF | Importing into accounting software such as Quicken, QuickBooks or Xero. |
Exports have limits. Many banks only offer the last few months or a year or two, and closed accounts often have only PDF statements left. For older history, convert the PDF statements instead.
If your bank’s CSV opens in Excel with everything in one column, or with long reference numbers turned into 1.23E+15, convert it with CSV to Excel. It detects the separator and keeps long numbers and leading zeros intact.
Option 2: Convert the PDF statement privately
Statements downloaded as PDFs from online banking contain real text, so their tables can be rebuilt as rows and columns.
- Open PDF to Excel (or PDF to CSV if you’re importing into other software).
- If the first or last pages are only summaries or terms and conditions, type the transaction pages into the Pages box, for example
1-4. - Choose the statement. It’s processed on your device in a few seconds.
- Download the file and open it.
You’ll get one worksheet with a column for each column in the statement: typically date, description, money out, money in and balance. Amounts become real numbers, so you can total and sort them immediately. Long descriptions that wrap onto a second line in the PDF are joined back into a single row.
Several months at once: combine the statements first with Merge PDF, in date order, then convert the merged file. You’ll get one continuous sheet instead of a file per month.
Password-protected statements: some banks protect statement PDFs with a password, often based on your date of birth or account number. The converter can’t open those. Open the statement in your browser or PDF reader with the password, choose Print and pick Save as PDF (or Microsoft Print to PDF on Windows). That saves an unprotected copy of your own document, which converts normally.
Tidy up and check the spreadsheet
A converted statement keeps everything that was printed on the page, so a few minutes of tidying gives you a clean table:
- Delete the extra rows. Bank name, address, account summary and page footers sit in rows of their own above and below the transactions. Repeated column headings appear where each new page starts.
- Check the balance. This is the most important step. Opening balance, plus money in, minus money out, should equal the closing balance printed on the statement. In Excel,
=SUM(D:D)totals a column. If the figures match, no transaction was missed or misread. - Make one amount column (optional). Many budgeting templates want a single column with negative amounts for spending. If money in is column D and money out is column C, put
=D2-C2in a new column and fill it down. - Convert dates if needed. Dates are kept exactly as printed, as text, because 03/04/2026 means different days in different countries. To sort by date, select the column and use Data › Text to Columns, choosing the date order your statement uses.
- Filter and categorise. Turn on Data › Filter, then filter descriptions containing a shop or company name to see what you spent with them.
Option 3: Paper and scanned statements
A scanned statement, or one photographed on a phone, is a picture with no text in it. A PDF converter will report that it found no text. Your options are:
- Download the PDF from online banking instead. Most banks keep several years of statements available as PDFs, even after paper statements stopped.
- Ask the bank for electronic statements or a transaction export for the period.
- Use text recognition (OCR). Excel’s Data from Picture feature (Microsoft 365) can read a photo of a table, though it uses Microsoft’s online service to do so. Check every figure afterwards: recognition can misread digits, and a 3 read as an 8 is easy to miss.
Summary
The bank’s own CSV export is the most accurate route. When you only have PDF statements, convert them in your browser so they never leave your device, then always check the totals against the balance printed on the statement.