Barclays · United Kingdom

Barclays CSV Statement: How to Download & Convert to Excel

Barclays gives you two ways to get your transactions out: official PDF statements and a CSV export of your transactions. Here is how to get each one, when the CSV falls short, and how to turn any Barclays PDF statement into clean Excel, CSV, Xero or QuickBooks data.

Last updated 14 October 2026

At a glance

Official statement format
PDF, downloadable from Online Banking and the Barclays app
Spreadsheet export
CSV export of transactions for a date range you choose, in Online Banking
Statements available online
Up to 7 years for open accounts with Online Statements; up to 5 years for closed accounts if you still bank with Barclays
Currency and dates
GBP (£), UK day-month date order
Converts to
Excel (.xlsx), CSV, JSON, Xero CSV, QuickBooks 3- and 4-column CSV

Two ways to get Barclays transactions out

Barclays gives you two different things, and they solve different problems:

PDF statementCSV transaction export
What it isThe official statement for a statement periodA download of the transaction list on screen
WhereOnline Banking and the Barclays appOnline Banking
HistoryUp to 7 years (Online Statements)The date range you search
Best forAccountants, mortgage and visa applications, year-end, auditsQuick checks of the last few weeks
Spreadsheet-ready?No, it's a PDFYes, but not in a statement layout

If a CSV of transactions is all you need, use it. If you need the official statement for a period, with its opening and closing balances, or a file your accountant will accept as matching what the bank issued, start from the PDF.

How to download a Barclays PDF statement

In Online Banking

  1. Log in to Barclays Online Banking.
  2. Open your profile and go to My Barclays documents.
  3. Select the statement you need, then download it as a PDF.

In the Barclays app

  1. Open the app and tap Help/More.
  2. Choose Statements.
  3. Select the statement and download or share the PDF.

If you receive Online Statements, they stay available for up to 7 years while the account is open. For a closed account, they stay available for up to 5 years as long as you still bank with Barclays. That usually covers what an accountant or a year-end needs without ordering paper copies.

How to export Barclays transactions as CSV

  1. Log in to Online Banking and select the account.
  2. Open the account's transactions and set the date range you need.
  3. Use the export option and choose CSV.

Why the CSV often isn't enough

  • It's a transaction list, not a statement. Accountants, lenders and auditors usually want the official statement.
  • It doesn't line up with statement periods. The export covers whatever date range you searched, not the statement period with its opening and closing balances, which makes reconciliation harder.
  • It's one account at a time. Bookkeepers handling several accounts or clients repeat the process for each one.

Converting a Barclays PDF statement

Copying a Barclays PDF into Excel by hand, or pasting it straight in, usually breaks: descriptions wrap onto two lines, money in and money out collapse into one column, and the balance column misaligns.

AI Bank Statement reads the statement the way it is laid out:

  1. Upload one or several Barclays PDF statements. Batch upload handles a year of monthly statements at once.
  2. Pick the output: Excel, CSV, JSON, Xero CSV, or QuickBooks 3- or 4-column CSV.
  3. Download a file with one transaction per row: date, description, money out, money in and balance in separate columns.

UK conventions are kept: dates are read day-first, amounts stay in pounds, and the running balance column lets you check each row against the statement.

Getting Barclays data into Xero or QuickBooks

If Barclays isn't connected to your accounting software through a bank feed, or the feed is missing a period, import the converted statement instead:

  • Xero: choose Xero CSV, then import it as a bank statement for the matching Barclays account.
  • QuickBooks: choose the 3- or 4-column CSV that matches your QuickBooks import settings, then upload it from file.

This is also how bookkeepers fill gaps when a bank feed breaks or a client only sends PDFs.

Barclaycard statements

Barclaycard is managed separately from Barclays current accounts, with its own online servicing and app. Its statements are credit card statements, and they convert the same way with the credit card statement converter: upload the PDF and choose your output.

Choose your output format

Frequently asked questions

Can I download a Barclays bank statement as a CSV file?

Yes. In Barclays Online Banking you can search an account's transactions for a date range and export them as a CSV file. The export is a transaction list, not your official statement, so when you need the statement itself (with its period and balances) or the export won't go back far enough, convert the PDF statement instead.

How far back can I get Barclays statements online?

If you receive Online Statements, Barclays keeps them online for up to 7 years while the account is open. For a closed account, statements stay available for up to 5 years as long as you still bank with Barclays. You can download each one as a PDF and convert it.

Can I convert a Barclaycard statement too?

Yes. Barclaycard is a credit card, managed separately from Barclays current accounts, and AI Bank Statement converts credit card statement PDFs the same way it converts bank statements.

Will dates and pound amounts come out correctly?

Yes. Dates are read in the UK day-month order, so 03/04 is treated as 3 April, amounts stay in pounds, and money in, money out and balance land in separate columns.

Can I import a converted Barclays statement into Xero or QuickBooks?

Yes. Choose Xero CSV or QuickBooks 3- or 4-column CSV as the output, then use the statement import option in your accounting software.

Is it safe to upload a Barclays statement?

Statements contain your sort code, account number and full transaction history, so it matters where they go. Uploaded files are processed for conversion and automatically deleted immediately afterwards, as set out in our privacy policy.

More bank guides

Life's too short to retype a bank statement.

Upload one and see for yourself. Plans from $12 a month.

Secure checkout · instant access · files deleted right after processing