Skip to content

Convert Lloyds statements to Excel or CSV

Every transaction from your PDF statement, in a spreadsheet. Free, no sign-up, nothing stored.

Drop your bank statement PDF here, or choose it

PDF, up to 10 MB. Nothing is stored.

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.

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. 200 pages free, then $0.08 a page. No minimum, no contract.

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 under a minute 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 statement for a spending score, category breakdown and honest AI feedback.