Convert your Barclays bank statement to Excel or CSV

Upload a Barclays current-account statement PDF and get a clean spreadsheet that keeps Date, Description, Money out, Money in and Balance values in their correct columns.

  • CSV
  • Excel

Drag & drop or click here

  • Secure encrypted upload
  • We never sell or share your data
  • Totals checked against your statement

Barclays current-account statements use a printed transaction table with separate Money out and Money in columns. The debit column comes before the credit column, which is the reverse of some other UK banks, so a generic PDF copy-paste can sign rows the wrong way.

This converter is tuned for Barclays' statement layout. It reads the Money out and Money in columns separately, keeps the intermittent Balance column tied to the right day, and reconstructs the missing year from the statement period because Barclays transaction rows show dates like 29 Nov or 01 Dec.

How Barclays statements are laid out

A Barclays current-account statement lists transactions in this order: Date, Description, Money out, Money in and Balance. Barclays uses two separate amount columns, never a single signed amount column, and Money out appears before Money in. Transaction rows show day and short month only, such as 29 Nov, 01 Dec or 13 May, so the year is inferred from the statement period printed elsewhere on the statement. The running Balance column is shown intermittently, often on the day's last line or when the balance changes, rather than on every row. Digital PDFs downloaded from Barclays online banking are usually text based and can span several pages.

Transaction columns
Date · Description · Money out · Money in · Balance
Date format
DD MMM with no year on the transaction line, year inferred from the statement period
Length
Multi-page
File type
Digital PDF (text-based)
Password protected
Usually no
Currency
GBP

How to download your statement from Barclays

  1. 1

    Log in to Barclays

    Sign in to Barclays Online Banking in a browser, or open the Barclays app if you normally download documents there. The original online PDF gives the cleanest conversion.

  2. 2

    Choose the account

    Open the current, savings or business account whose statement you need. Check the account name and sort code if you manage several Barclays accounts.

  3. 3

    Open statements and documents

    Go to the account's statements, documents or statement history area. Use the official monthly statement rather than a recent-transactions printout when you need opening and closing balances.

  4. 4

    Select the statement period

    Pick the month or date range you want to convert. Barclays transaction rows only show the day and month, so the statement period is important for assigning the correct year in the exported spreadsheet.

  5. 5

    Download the PDF

    Save the statement PDF to your computer, then upload that file here. Avoid screenshots or printed scans when the original digital PDF is available.

Barclays conversion quirks we handle

  • Money out before Money in: Barclays puts debit amounts before credit amounts. We sign each row from the column it appears in instead of assuming the credit column comes first.

  • Two amount columns: Barclays uses separate Money out and Money in columns, never a single signed amount column. The export preserves that debit and credit split.

  • Dates without a year: transaction rows show day plus short month only, such as 29 Nov or 01 Dec. We infer the year from the statement period, including periods that cross a year boundary.

  • Intermittent balances: the Balance column is not printed on every row. We keep printed balances on the correct transaction and carry context through the spreadsheet for reconciliation checks.

  • Recognisable Barclays descriptions: card payments, direct debits, direct credits, received-from entries and online banking bill payments can include references on the same or following line. We keep those references with the transaction description.

  • Multi-page online statements: repeated Barclays headers, account details and page furniture are skipped so they do not become extra rows in the CSV or Excel file.

Barclays bank statement FAQ

Can I convert a Barclays statement to Excel?+

Yes. Upload the Barclays statement PDF and choose Excel to get a workbook with Date, Description, Money out, Money in and Balance values separated into spreadsheet columns.

Can I convert a Barclays PDF statement to CSV?+

Yes. The same Barclays PDF can be exported as CSV for spreadsheet checks, accountant handoff or accounting-system import preparation.

Does it handle Barclays' Money out and Money in columns?+

Yes. Barclays prints debits in Money out and credits in Money in, with Money out first. The converter signs amounts from the column position so debits and credits do not get reversed.

Why do Barclays transaction dates have no year?+

Barclays transaction rows show dates like 29 Nov or 01 Dec without the year. The converter uses the statement period to infer the correct year for each exported row.

Are Barclays statements password protected?+

Barclays current-account statements downloaded from online banking are normally regular PDFs. If you have a password-protected copy, remove the password before uploading it.

Is it safe to upload my Barclays statement?+

Uploads use a secure encrypted connection. We never sell or share your data, and totals are checked against your statement.

Other United Kingdom bank statement converters

Convert to a specific format

Need a different bank or format? Our bank statement converter converts any bank statement into clean Excel and CSV.

Convert a Barclays statement now