How to Download a Barclays Statement & Convert It to Excel

Need a clean copy of your Barclays statement for your bookkeeping, a self-assessment return, or a loan application? The job is two steps: download the statement as a PDF from your online or mobile banking, then convert that PDF into a spreadsheet you can sort, total, and reconcile. This guide walks through both. Bear in mind that banking apps and websites get redesigned, so treat the menu labels below as the general route rather than the exact wording you will see today.

Download a Barclays statement on Online Banking (desktop)

Logging in from a browser is usually the easiest way to grab several statements in one sitting.

1. Sign in to Online Banking from your usual browser.
2. Open the current account, savings account, or card you want a statement for.
3. Look for a statements or documents area within that account view.
4. Choose the statement period you want from the list shown.
5. Open or download the PDF and save it somewhere you will find it again.

Statements are generally organised by their monthly cycle, so pick the month or billing period that matches what you need. Because the layout changes over time, the exact link names may differ from the steps above.

Download a statement in the Barclays mobile app

If you usually bank on your phone, the app can produce the same PDF.

1. Open the app and log in.
2. Tap through to the account you want.
3. Find the statements or documents option within that account.
4. Select a period, then save or share the PDF to your phone.

The in-app transaction feed is handy for a quick balance check, but for anything official — sending records to an accountant, a lender, or as part of a tax return — an official PDF statement is usually preferred. It carries your sort code, account number, and the statement dates in a consistent layout, which is what most third parties expect to see.

Choose the right statement period

How much you download depends entirely on what it is for:

• Budgeting or expense tracking — a single recent month is usually plenty.
• Self-assessment or company accounts — you may need every month across the tax year, so work through the list and download each period one at a time.
• A mortgage or loan application — lenders commonly ask for three to six consecutive months, so pull each statement in the run they have requested.

Keep the original PDFs filed somewhere safe. They are your source documents, and you may be asked to re-supply them later. For tax purposes, the official guidance on keeping records is on gov.uk, and our overview of bank statements for UK taxes covers what a statement does and does not evidence.

Why the PDF is only half the job

A PDF is excellent for reading and for proof, but it is a poor format for actually working with the numbers. You cannot sort it, total a column, filter by payee, or import it straight into accounting software. To do anything analytical, you need the transactions laid out as rows and columns.

That means converting the PDF into Excel or CSV. Barclays statements come as PDFs rather than a ready-made spreadsheet, so this conversion is a separate step you do yourself. How smoothly it goes depends mainly on how many statements you have and whether your PDF contains a proper text layer or is a scanned image.

Convert the Barclays statement to Excel or CSV

The quickest route is to let a converter read the statement, detect the transaction table, and write out clean rows for you. Drop your file into the free bank statement converter and export the transactions to Excel or CSV — the column mapping is handled automatically, which matters most when you have a stack of months to process.

If you would rather understand every option first — including manual typing and copy-paste, and the point at which each one breaks down — read how to convert a bank statement to Excel.

XLSX or CSV?

• Pick XLSX when you want formatting, formulas, or several sheets in one workbook — useful for a running budget or a year-end summary.
• Pick CSV when you need to import the data into accounting or bookkeeping software, which almost always accepts a plain CSV.

A few things to check

• Scanned statements. If your PDF is an image rather than selectable text, copy-paste will not work; use a converter that can read the page properly.
• One account at a time. Download and convert each account separately so the transactions do not end up jumbled together.
• Reconcile the totals. Once exported, compare the opening and closing balances in your spreadsheet against the PDF to confirm nothing was dropped or mis-read.

In short

Download the statement as a PDF from Barclays Online Banking or the app, choose the period that fits your purpose, keep the original on file, then convert it to Excel or CSV so you can sort, total, and reconcile the figures. Bank with more than one provider? The same two-step approach applies — see, for example, how to download a NatWest statement. Once the data is in a spreadsheet, the rest of your accounting or budgeting work gets far easier.