StatementBear

PricingAPIDocsAbout
Log In

Convert Barclays statements to Excel or CSV

Barclays statements are PDFs with descriptions spread over two or three lines per payment. Upload one here and get one row per transaction, with the payee and the amount where a spreadsheet expects them.

Drop your bank statement PDF here or click to upload

PDF files only, up to 10MB. Your file is processed securely and never stored.

Where to find your Barclays statement PDF

  1. Log in to Barclays Online Banking or the Barclays app.
  2. Open the account and find Statements.
  3. Choose the month and save the PDF.

How Barclays statements are read

Money out and money in are separate columns

Amounts sit under Money out or Money in, with a running Balance beside them. The column decides the direction, so nothing depends on how the payment is described.

Descriptions wrap over several lines

A row starts with the payment type, such as Card Payment to, Direct Debit to or Received From, and continues with the payee and a reference underneath. Those lines are joined back into one description.

Parse Barclays statements in your own app

Send the PDF to the StatementBear API and get JSON back: every transaction with its direction and category, the account it belongs to, and a check that the totals reconcile. No bank login, no template per bank. The first 25 documents are free, then $0.49 each.

curl -X POST https://statementbear.com/api/v1/documents \
  -H "Authorization: Bearer $STATEMENTBEAR_KEY" \
  -H "Content-Type: application/pdf" \
  -H "Idempotency-Key: $(uuidgen)" \
  --data-binary @statement.pdf
Get an API keyRead the quickstart

Statements from other banks

Chase

Bank of America

Wells Fargo

Citi

Capital One

Amex

HSBC

Lloyds

Halifax

Nationwide

Monzo

Starling

N26

Your bank is not listed? Upload it anyway: the converter reads any bank, in any currency. All banks

Three simple steps

01

Download your Barclays PDF

Log in to Barclays Online Banking or the Barclays app. Open the account and find Statements. Choose the month and save the PDF.

02

Upload it here

Drop the PDF on the box at the top of this page. It is read in a few seconds and nothing is stored.

03

Download the CSV

One row per transaction with date, description, amount, direction and category. Opens in Excel, Google Sheets and Numbers.

Frequently asked questions

Want a complete spending analysis?

Upload your bank statement to StatementBear for AI-powered spending insights, scores, category breakdowns, and honest financial feedback.

Get Started Free

First analysis free

New to this? How to analyze a bank statement

Free Bank Statement Tools

Bank Statement to CSV Converter

Convert your bank statement PDF into a clean, structured CSV file that opens in Excel, Google Sheets, or any spreadsheet app.

Use tool

Bank Statement Redactor

Automatically remove sensitive information like account numbers, sort codes, and personal details from your bank statement before sharing.

Use tool

Subscription Finder

Scan your bank statement to find all recurring charges and subscriptions. See exactly what you pay for each month.

Use tool

Tax Deduction Finder

Identify potential tax-deductible expenses in your bank statement. Find deductions you might be missing at tax time.

Use tool

BNPL Tracker

Find all Buy Now, Pay Later payments in your bank statement. Track spending across Klarna, Afterpay, Clearpay, and other BNPL providers.

Use tool