Convert Lloyds statements to Excel or CSV

Lloyds statements are a table of dates, descriptions, payment types and three money columns. Upload the PDF here and download exactly that table as a CSV, one row per transaction.

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 Lloyds statement PDF

  1. Log on to Lloyds Internet Banking or the Lloyds app.
  2. Open the account and choose Statements.
  3. Select the month and download the PDF.

How Lloyds statements are read

A type column with three-letter codes

Each row has a type: DEB for a debit card payment, DD for a direct debit, SO for a standing order, FPO and FPI for faster payments out and in, BGC for a bank giro credit such as a salary, TFR for a transfer. The code is kept, and the direction comes from the Money In and Money Out columns.

Own-account transfers are not income

Money moved in from your own savings account is marked as a transfer, so it does not inflate your income if you use the export for a budget.

Parse Lloyds 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

Statements from other banks

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

Three simple steps

01

Download your Lloyds PDF

Log on to Lloyds Internet Banking or the Lloyds app. Open the account and choose Statements. Select the month and download 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.

First analysis free

New to this? How to analyze a bank statement