Converter · Excel
Convert a bank statement to Excel
Get your statement into Excel as real dates and real numbers, ready to sort, filter and total. Converted in your browser, never uploaded.
or drop it here
Read in this browser. Your file is never uploaded.
Rows wrong or missing?
Send us the shape of this statement, not its contents. The report below is made in this browser. It keeps where text sits, dates and column headings. Every name, amount, reference and account number is replaced with x and 1, as you can see. Nothing is sent until you send it.
Then email the report to support@statementtocsv.co.uk and say which bank it is from. We’ll add the layout and let you know.
| Date | Description | Paid in | Paid out | Balance |
|---|
| Check | Result | What we found |
|---|
Statements
| Period | File | Opening | Closing | Rows | Used as |
|---|
| Date | Description | Paid in | Paid out | Balance | From |
|---|
Works with text PDFs that have Date, Description, Paid in / Paid out (or Amount) and Balance columns. Scanned or photographed statements are not supported yet. The samples are fictional test data.
From PDF statement to Excel in four steps
- Convert the PDF aboveChoose your statement PDF. Check the result says “Verified”.
- Click “Download CSV for Excel”The file is saved to your Downloads folder with the same name as the statement.
- Open it in ExcelDouble-click the file. Because the file is marked as UTF-8, Excel shows £ signs and accented names correctly.
- Save as a workbookUse File, Save As and choose “Excel Workbook (.xlsx)” so formulas, formatting and extra sheets are kept.
Why a CSV rather than an .xlsx file?
A CSV is the most dependable way to move transactions between programs. Excel, Google Sheets, Numbers, LibreOffice and every accounting package can read it, and there is nothing hidden in it: no formatting, macros or formulas. Excel opens it directly, so for most people there is no difference beyond saving it as a workbook once you start adding your own work.
Getting dates and amounts right in Excel
The two things that usually go wrong when statements reach Excel are dates and amounts. The converter writes dates as dd/mm/yyyy. On a computer set to UK regional settings, Excel recognises those as real dates you can sort and group by month. If your computer is set to US settings, Excel may swap day and month for dates up to the 12th; our guide on opening a CSV without breaking dates shows how to import it safely.
Amounts are written as plain numbers, such as 1250.00, with money in and money out in separate columns. That means =SUM(C:C) gives total money in and =SUM(D:D) total money out straight away, with no text-to-number clean-up.
Useful things to do next
- Turn it into a table (Ctrl+T) to get filter buttons on each column, then filter the description for a supplier’s name.
- Add a Month column with
=TEXT(A2,"yyyy-mm")and build a pivot table of money in and out by month. See splitting a CSV by month. - Add a Category column and group spending for a budget, a tax return or a mortgage application. See categorising transactions.
- Check the closing balance: the last value in the Balance column should match the closing balance on the PDF.
Google Sheets and Numbers
In Google Sheets, open a blank sheet and use File, Import, Upload, then choose the CSV. Leave “Convert text to numbers, dates and formulas” ticked. The CSV is opened by Google Sheets in your Google account, so only import it if you are happy for it to be stored there. In Apple Numbers, open the CSV directly.
Questions people ask
Can I convert a bank statement PDF directly to .xlsx?
The converter produces a CSV, which Excel opens directly. Save it as .xlsx from Excel once it is open. A CSV is used because every spreadsheet and accounting program can read it reliably.
Why do some dates look wrong in Excel?
Excel reads dates using your computer’s regional settings. With UK settings, dd/mm/yyyy dates open correctly. With US settings, import the file with Data, From Text/CSV and choose the date format, as described in our date guide.
Can I put twelve months in one Excel sheet?
Yes. Use “Several statements” in the converter to combine the statements into one CSV. It checks the months join up and counts any overlapping rows only once.
Will the paid in and paid out columns add up?
Yes. Opening balance plus total paid in minus total paid out equals the closing balance. The converter checks this before you download.