To get a Revolut statement into CSV, look for the statement or export option in your account inside the app or on the website and choose a spreadsheet-style format if one is offered; the format list can change, so check what your account shows. If you only get a PDF, you can still import it into tools that read PDFs. Then clean dates, signs and currency before you total anything.
What do I do once I have the file?
- Open it in Excel or Google Sheets. If Excel mangles characters, use Data, then From Text/CSV and pick the right encoding.
- Check the first row holds column names and that every row below is one transaction.
- Make sure no column was squashed into a single cell.
- Save a copy before you edit. Keep the original untouched.
- Look for a currency column. A statement with several currencies mixes amounts that cannot be added directly.
How do I fix dates and amounts?
Dates often arrive as text with a time attached, such as 2026-10-14 09:32:11. To get a plain date use =DATEVALUE(LEFT(A2,10)) and format the result cell as a date. Amounts may be negative for spending and positive for money in. To total spending only, use =SUMIFS($D$2:$D$500, $D$2:$D$500, "<0") and remember the result is negative. To flip it to a positive figure, put a minus sign in front: =-SUMIFS($D$2:$D$500, $D$2:$D$500, "<0").
A hypothetical check: rows of -12.50, -8.40, -30.00 and +100.00 in euros. Spending is 12.50 + 8.40 + 30.00 = 50.90, money in is 100.00, and the net is 49.10. If your sheet shows something else, a row is missing or a sign flipped.
What if my statement has several currencies?
Filter by the currency column first and total each currency alone. Adding euro and dollar amounts into one figure is wrong. If you need one total, convert each row at the rate shown for that transaction, and note that rates differ per day.
Can I import it into an expense tracker?
SpendixAI accepts statements as PDF, CSV or Excel, with a review step before rows are saved. Pick the account first, and choose your base currency before importing, because it cannot be changed once transactions exist. Each expense can keep its own currency, and totals use the rate saved with each transaction. Not every layout parses perfectly, so check the rows. Also note the product is built around India and INR.
Safe handling of the file
- Statements show your balance and counterparties, so store the file in a private folder.
- Delete downloaded copies you no longer need.
- Do not upload your statement to random converter sites; use tools you trust.
How do I summarise by category once it is clean?
Add a category column to the sheet and fill it in by hand for the first month, using short labels such as food, travel, subscriptions and transfers. Then total each with =SUMIFS($D$2:$D$500, $F$2:$F$500, "Food") where D holds the signed amount and F the category. Do transfers between your own pots or accounts under one label, so they do not look like spending. After one month, copy the same labels forward, and next month's work is mostly checking, not typing.
What mistakes should I watch for?
- Adding a column of mixed currencies and treating the result as one number.
- Sorting only one column, which scrambles rows against their dates.
- Losing leading zeros or long reference numbers when the sheet reformats them as numbers.
- Deleting pending lines that later settle, then finding the total is short.
Before you rely on the sheet
- Row count matches the statement.
- Opening balance plus net movement equals the closing balance.
- Currencies are separated or converted deliberately.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

