How to Convert PDF Bank Statements to CSV in the UK
To convert a PDF bank statement to CSV, download the original statement from your bank, upload it to a PDF-to-CSV converter, and download the extracted transaction table. Check the dates, amounts, and totals before importing it into a spreadsheet or bookkeeping system.
For UK users, date interpretation deserves particular attention: a day/month date can be misread when imported with different regional settings. This guide walks through preparation, conversion, and review so you can work with the statement data while keeping the original PDF as your reference.
Have the PDF ready? Open the PDF to CSV converter for bank statements and follow along.
1. Check whether your bank already offers a CSV export
Look at the statement and transaction download options in your bank's official website or app. If a CSV export is available for the required period, it may save you a conversion step. Check its coverage: a transaction download may not include the same period, descriptions, or balances as a monthly PDF statement.
When you only have a PDF, download the original file rather than taking screenshots. Check that all pages are present and readable. Keep an unchanged copy and use a filename that identifies the account and statement period without exposing unnecessary account details.
2. Upload the PDF bank statement
Visit the PDF-to-CSV conversion page. Sign in if prompted, then select your file or drag it into the upload area. The output on this page is already set to CSV. Start with one statement so you can inspect the output before working through a longer history.
If the document does not open, check that it is a complete PDF and opens locally. Password protection can prevent processing. Use a version you are authorised to access and that the converter can read. Never provide your online banking password to convert a statement.
3. Convert and download the CSV
Click Convert to CSV beside the uploaded statement. When conversion finishes, download the .csv file and keep it alongside the PDF. CSV is a plain-text table: it stores fields and rows, rather than Excel styling, multiple worksheets, or a page-by-page reproduction of your statement.
The extracted headers depend on the source statement. Inspect them before assuming a fixed column order. Look for dates, descriptions, amounts, and balances where present. A statement with separate debit and credit columns may require different mapping from one with a single signed amount.
4. Open the file and check date interpretation
Use your spreadsheet application's CSV or text import options if opening the file directly produces unexpected results. Check the preview, delimiter, and column types before loading the data. If the whole row appears in one column, the importer may be using a different separator.
Confirm that dates mean the same thing as in the PDF. For example, 06/07/2026 can be interpreted as 6 July or 7 June. Choose import settings that match the source, and check against unambiguous dates and the statement period. Applying a date display format afterwards does not necessarily fix a value that was interpreted incorrectly.
Check that transaction amounts are numbers rather than text, that decimal places are intact, and that any negative signs have been preserved. Keep currencies separate. A currency symbol or display format does not convert one currency into another.
5. Reconcile the extracted data with the PDF
- Review every page boundary. Check the first and last transaction on each PDF page for missing or repeated rows.
- Check wrapped descriptions. A second line of payment text should not become an extra transaction.
- Compare money in and money out. Confirm the sign convention and compare totals with the statement's summary where available.
- Check balances. For a deposit account, opening balance plus money in minus money out should equal closing balance. Follow the statement's own convention for other account types.
- Investigate differences. Compare the disputed rows with the original rather than changing an amount just to make totals match.
Matching totals do not prove every row is correct: two errors can offset each other. Likewise, two payments with the same date and amount are not automatically duplicates. Review descriptions and references before removing an entry.
6. Prepare a working copy for import or analysis
Keep the downloaded CSV unchanged and prepare a separate working copy. Use the receiving application's current import instructions to map the fields and confirm its required date and amount conventions. A CSV file is not automatically compatible with every accounting import layout.
Try a small, checked batch before importing a full statement history, and check existing records to avoid importing transactions twice. For spreadsheet analysis, retain the original description and add your own categories separately. Save as XLSX if you need to keep workbook formatting or formulas; you can also use our PDF-to-Excel converter when a workbook is the output you need.
Frequently asked questions
Does this guide confirm support for my UK bank?
This is a conversion workflow, rather than a bank-by-bank compatibility list. Layouts and document quality vary. Start with one statement and verify the extracted rows against it before processing more files.
Can I use a scanned statement?
Scanned pages need text recognition before their contents can become structured data. Clear text and complete pages matter. Prefer the bank's original downloadable PDF where available, and inspect any output carefully for misread characters or amounts.
Should I keep the PDF after converting?
Keep the original as a reference for checking your spreadsheet and tracing transactions. Store financial files with restricted access. Read our bank statement security guide for practical handling advice.
For more ways to use the resulting table, explore the benefits of converting bank statements to CSV.
Convert your PDF statement to CSV
Extract a transaction table, review it against your statement, and prepare a checked copy for your spreadsheet or bookkeeping workflow.
Open the PDF to CSV converter