How to Export a Lloyds Bank Statement (PDF to Excel)

Whether you are tidying up your bookkeeping, preparing a self-assessment return, or applying for a mortgage, the first step is getting a clean copy of your statement. Here is how to download a Lloyds Bank statement as a PDF using Internet Banking or the mobile app, then turn it into a spreadsheet you can actually work with. (Menu labels change from time to time, so treat these as the general steps rather than exact wording.)

Download a Lloyds statement on Internet Banking (desktop)

1. Sign in to Internet Banking from your usual browser.
2. Select the account you want a statement for.
3. Look for Statement options within the account view.
4. Choose the statement period you need from the list.
5. Open or download the PDF and save it to your computer.

Lloyds typically lists statements by their monthly cycle, so pick the month or billing period that matches what you are looking for. The exact wording can vary by version, so labels may differ slightly from the above.

Download a statement in the Lloyds mobile app

1. Open the app and log in.
2. Tap the account you want.
3. Open the three-dot ("more") menu and choose Download or print statement.
4. Select a period, then save the PDF to your phone.

Menu labels can vary between app versions, so treat these as the general path rather than exact wording. If you only need to check a recent transaction, the in-app transaction list may be enough. For anything official — submitting to an accountant, a lender, or HMRC — an official PDF statement is often preferred, as it carries the dates, sort code, and account details in a consistent format.

Pick the right period

How much you download depends on what it is for:

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

Save the original PDFs somewhere safe. They are your source documents, and you may be asked to re-supply them later. The official guidance on keeping records for self-assessment is on gov.uk.

Why a PDF is not the finish line

A PDF is great for reading and for proof, but it is a poor format for analysis. You cannot sort it, total a column, filter by payee, or drop it into accounting software. To do anything useful with the numbers, you need the transactions as rows and columns in a spreadsheet.

That means converting the PDF to Excel or CSV. There are a few ways to approach it, and the right one depends on how many statements you have and whether your PDF has a proper text layer.

Export the statement to Excel or CSV

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

If you would rather understand all the options first, including manual entry and copy-paste and when each one breaks down, read how to convert a bank statement to Excel.

Choosing XLSX or CSV

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

A few things to watch

• Scanned PDFs. If your statement is an image rather than selectable text, you cannot copy-paste it; you will need a converter that can read the page properly.
• Multiple accounts. Download each account's statement separately so the transactions do not get mixed together.
• Check the totals. After exporting, compare the opening and closing balances in your spreadsheet against the PDF to confirm nothing was dropped.

In short

Download the statement as a PDF from Lloyds Internet Banking or the app, pick the period that matches your purpose, keep the original on file, then convert it to Excel or CSV so you can sort, total, and reconcile the data. Once the transactions are in a spreadsheet, the rest of your accounting or budgeting work gets a lot easier.