To get a Lloyds statement into CSV, look in your own online banking for an option to download or export transactions, and pick a spreadsheet or CSV format if one is offered. If only a PDF is offered, copying it into a sheet is error-prone, so check the rows against the original. we cannot describe the bank's menus, because they differ by account, so look at what your own screen offers.
What a good CSV looks like
Open the file in a spreadsheet or plain text editor. You want one row per transaction with a date, a description, money out and money in, and perhaps a balance. If the first rows are titles, delete them so that the headers sit in row 1.
| Date | Description | Money out | Money in |
|---|---|---|---|
| 02/05/2026 | Supermarket | 42.50 | 0.00 |
| 04/05/2026 | Mobile bill | 18.99 | 0.00 |
| 05/05/2026 | Coffee | 6.20 | 0.00 |
| 06/05/2026 | Salary | 0.00 | 2100.00 |
| 09/05/2026 | Rent | 1250.00 | 0.00 |
| 11/05/2026 | Gym | 35.00 | 0.00 |
Check the dates and decimals first
In British files, dates are usually day first. A line dated 02/05/2026 is 2 May. If your spreadsheet is set to month first it reads 5 February, so check a few rows against the statement. Also check that amounts have a full stop for decimals and no pound symbol inside the number, or they will be stored as text.
Totals with simple formulas
Put money out in column C and money in in column D, rows 2 to 7. Then:
- =SUM($C$2:$C$7) gives total out.
- =SUM($D$2:$D$7) gives total in.
- =SUM($D$2:$D$7)-SUM($C$2:$C$7) gives the net change.
Use the example amounts: out are £42.50, £18.99, £6.20, £1,250.00 and £35.00, which add to 42.50 + 18.99 + 6.20 + 1,250.00 + 35.00 = £1,352.69. In is £2,100.00. The net change is 2,100.00 - 1,352.69 = £747.31.
What if the export misses something?
- Check the date range you asked for, including both end dates.
- Compare the number of rows with the number of lines on the PDF.
- Add the opening balance and the net change, and compare with the closing balance on the statement.
- If a line is missing, look for a pending item that had not yet posted.
What if the CSV looks right but the totals do not?
Hidden problems are common. A description with a comma inside it can push amounts one column to the right, so a payment lands under the wrong heading. Scan the money columns for text that is not a number, and use a filter to see any row where the money out is empty and money in is empty as well. Fix those rows by hand, then rerun the totals.
How often should you export?
Monthly is a good rhythm. Download the file in the first week for the previous month, save it with the month in the name, and keep the original untouched in one folder and your working copy in another. When you need a figure from last March, you will know where to look.
Taking it further
Once the file is clean, you can use it in a sheet, or upload it to SpendixAI, which accepts CSV, Excel and PDF statements and shows the rows to review before saving. You pick the account first, and each transaction keeps it. It is built around India and INR, and the base currency has to be chosen before you import, so it suits you best if your money is mainly rupees.
- Dates read the right way round.
- Amounts are numbers, not text.
- Totals reconcile with the bank.
- A copy of the original file is kept.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


