To get a Starling statement as a CSV, look in your Starling app or online account for the statement or export option and see which file formats it offers. If CSV is listed, download it. If only PDF is offered, you will need to convert it, which takes more care. we cannot describe Starling's menus, so treat the bank's own help pages as the final word on where the button sits.
Which format should you ask for first?
Always prefer a file the bank generated as CSV or Excel over a converted PDF. A native export keeps each transaction on its own row with the date, description and amount in separate columns. A PDF converted by a tool can merge two lines into one, split a long merchant name across rows, or drop a minus sign.
| Format | Good for | Watch out for |
|---|---|---|
| CSV from the bank | Sorting, filtering, importing elsewhere | Dates may arrive as text; check the order of day and month |
| Excel from the bank | Same as CSV, plus keeps number formats | Amounts stored as text show a green corner or left-align |
| Proof and archiving | Needs conversion; totals must be re-checked |
What should the finished sheet look like?
Aim for one header row and one transaction per row, with these columns: date, description, amount (money in as positive, money out as negative) and, if the bank provides it, a running balance. Delete any title lines, page footers or blank rows above the header, because they break sorting and imports.
Worked example: checking a small export
Say the file shows an opening balance of £1,250.00 for the month and three rows: a salary credit of £2,100.00, a grocery payment of -£62.40 and a rent payment of -£850.00. The closing balance should be 1,250.00 + 2,100.00 - 62.40 - 850.00 = £2,437.60. If the bank's own closing balance says something else, a row is missing or a sign has flipped. Fix that before you do anything else with the file.
In Excel or Google Sheets you can test this with one cell. If the amounts sit in C2:C200, then =1250+SUM($C$2:$C$200) gives the closing balance to compare with the statement.
Why do the dates or amounts look wrong after opening the CSV?
- Dates in the wrong order: the sheet may read 03/04/2025 as 4 March when the bank meant 3 April. Import the column as text and convert it with a known day-month-year pattern.
- Amounts that will not add up: they are probably stored as text. Replace stray currency symbols and commas, then convert the column to numbers.
- Lost leading zeros or long references: format the reference column as text before you paste.
- Garbled symbols such as the pound sign: reopen the file as UTF-8 text rather than double-clicking it.
What if the account is in pounds but you live in India?
Keep the original currency on each row instead of converting by hand. If you later load the file into SpendixAI, pick the base currency before the first import, because it cannot be changed once transactions exist. Each expense can carry its own currency, and totals use the rate saved with each transaction, so a pound account and rupee accounts can sit in one workspace. Statements can be uploaded as PDF, CSV or Excel, and you review the rows before saving. A very unusual layout may not parse perfectly, so scan the preview.
A short checklist before you close the file
- Download the statement from your own logged-in bank account, never through a third-party site that asks for your login.
- Keep the original untouched in a folder and work on a copy.
- Confirm the date range covers the whole month with no gap at either end.
- Check the closing balance as shown above.
- Name the file with the account and month, for example starling-2025-04.csv, so next year's you can find it.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


