Published July 2026 by BalanceExtract Team
Lloyds is one of the largest retail banks in the UK, and Lloyds Banking Group's infrastructure also underpins Halifax and Bank of Scotland — over 23 million customers between the three brands eventually need the same thing: their transactions in a spreadsheet, not locked inside a PDF. This guide covers exactly how the Lloyds CSV export works, what the file looks like column by column, where it falls short, and how to get data out of the PDF statements that hold everything the download can't reach.
This article covers Lloyds personal and business current accounts. If you bank with Halifax or Bank of Scotland, the same export mechanics apply — both share the same underlying online banking platform and the same real limits described below.
Getting Lloyds transactions into a spreadsheet without retyping them by hand comes down to two paths. Lloyds lets you download transactions as a CSV from online banking, but only the last 12 months, capped at 150 transactions per download, and only on the desktop site. Lloyds keeps PDF statements for 7 years (10+ years in the app), but offers no native Excel export at all. For anything the CSV export can't reach — older statements, more than 150 transactions, or an Excel file — upload the PDFs to BalanceExtract and export CSV, Excel, Tally XML, or IIF, without typing a single row by hand.
The built-in export works, it's free, and for recent transactions it's the fastest option available. Here's the process on Lloyds Internet Banking.
Sign in to Lloyds Internet Banking at lloydsbank.com. The CSV export specifically is not available in the mobile app — you'll need the desktop site for this step.
Select the account you want, then look for Statement options in the account view.
Pick CSV if you want to work in Excel or Google Sheets. Lloyds also offers PDF statements from the same menu, and Online for Business accounts can export QIF as well as CSV.
You can pick a custom range, but only within the last 12 months — anything older simply isn't offered as an export option, regardless of the range you try to set.
The file saves to your computer. Double-click to open it in Excel, or import it into Google Sheets via File, then Import.
The Lloyds CSV export contains six columns. Unlike some banks that use a single signed Amount column, Lloyds splits money in and money out into two separate columns.
| Column | What It Contains |
|---|---|
| Date | The transaction date, in DD/MM/YYYY format |
| Description | The payee or merchant name as it appears on the transaction |
| Type | A short code for the transaction type (e.g. DEB for debit card, DD for direct debit, BGC for bank giro credit) |
| Money In (£) | Populated only for credits — empty for any row that's a debit |
| Money Out (£) | Populated only for debits — empty for any row that's a credit |
| Balance (£) | The running balance after that transaction |
The Type column is worth paying attention to if you're categorizing transactions — codes like DEB, DD, SO, and BGC map to real transaction mechanisms (debit card, direct debit, standing order, bank giro credit) rather than spending categories, so treat it as a mechanism hint, not a bookkeeping category.
The CSV download is genuinely useful for recent activity. It also has hard edges that show up exactly when the stakes are highest: tax season, a mortgage application, or catching up on a year of bookkeeping.
Lloyds keeps up to 7 years of PDF statements available under Statement options, and even longer in the app. Converting them to a spreadsheet takes three steps.
Log in, open the account, and download each monthly statement as a PDF. For a full year, that's up to 12 files.
Drop your Lloyds PDFs into the converter — batch upload works, and each statement is processed on its own.
BalanceExtract detects Lloyds' layout automatically and shows every extracted transaction with a confidence score before you export, so anything worth double-checking is flagged rather than silently guessed at. Export to CSV, Excel, Tally XML, or IIF.
One accuracy point worth calling out directly: Lloyds statements print dates as DD/MM/YYYY, the reverse of the US convention. A converter that assumes MM/DD would silently swap day and month for any date under the 13th. BalanceExtract infers the real date order from the statement itself rather than assuming one, and normalises output dates to ISO (YYYY-MM-DD) by default — a format Excel reads unambiguously no matter what regional settings your spreadsheet software is using.
QuickBooks Desktop: QuickBooks Desktop has no native CSV import for transactions. Export IIF from BalanceExtract instead — File > Utilities > Import > IIF Files reads it directly.
Excel: Both the Lloyds CSV and the BalanceExtract CSV or Excel export open directly in Excel. If you're combining files from multiple Lloyds CSV downloads, watch for the Money In/Money Out split — summing both columns correctly (rather than just one) is what keeps your total reconciling against the statement.
Google Sheets: Use File, then Import, and let Sheets detect the separator automatically. Dates come through cleanly once normalised to ISO, ready for filtering or a shared budget tracker.
Use the Lloyds CSV export for the last 12 months, and BalanceExtract for everything else. Free to try.
Honest side-by-side write-ups, including where each of them is the better choice.
How NatWest's native export compares, and converting older PDFs.
Turn any CSV export into a QuickBooks Desktop-ready IIF file.
For accounting software that prefers a real transaction feed over a spreadsheet.
Every bank guide and format converter BalanceExtract offers.