
How to Convert Revolut Statements to CSV (2026)
Revolut offers some export options, but full statement CSVs aren't always available. Here's how to get your data into a spreadsheet that actually works.
How to Convert Revolut Bank Statements to CSV (2026)
Revolut has become one of the most popular digital banks in the UK, but when it comes to getting your transaction data out of the app and into a spreadsheet, things aren't always as simple as they should be. Whether you're a freelancer preparing for self-assessment, a small business owner reconciling monthly accounts, or someone who just wants to track spending in Excel, this guide covers every practical method for converting Revolut statements to CSV.
What Revolut Offers Natively
Revolut provides several ways to access your transaction data, though the options differ between personal and business accounts.
Personal Accounts
From the Revolut app, you can generate account statements in PDF or CSV format. The process is:
- Open the Revolut app and go to the Home tab
- Select the account you want to export
- Tap More, then find Statement
- Choose your time period and format (PDF or Excel)
- Generate and save the file
The CSV/Excel export from the app typically covers transaction lists rather than formal bank statements. It includes the date, description, amount, and currency for each transaction, which is useful for budgeting but may not match the formal statement layout your accountant expects.
Business Accounts
Revolut Business offers a more robust export through the dashboard. You can download statements in PDF or CSV format, filter by date range, and — on the desktop version — filter by transaction type such as card payments, transfers, or FX conversions. Business CSV exports include additional detail like local and UTC timestamps, which is helpful for reconciliation across time zones.
The Limitations
Revolut's built-in exports don't always cover full historical statement periods, and the CSV format can need cleanup before it imports smoothly into accounting software. Multi-currency accounts add another layer of complexity — you may need to export each currency separately and consolidate the files yourself. The default timestamps use UTC, which can shift transactions across month-end boundaries if your working timezone differs.
The Fastest Method: Convert Your PDF with BankToFile
If you have Revolut statement PDFs that need converting — or if the in-app export doesn't produce the format your accounting software needs — a dedicated converter is the quickest solution.
BankToFile handles Revolut PDF statements and converts them to properly structured CSV or Excel files in seconds:
- Download your statement PDF from the Revolut app (go to your account, tap More > Statement, select PDF)
- Upload the PDF to BankToFile — works directly in your browser, no installation needed
- Choose CSV or Excel as the output format
- Download your file — transactions are extracted with correct dates, descriptions, and amounts in clean columns
This is especially useful if you're converting multiple months at once for tax season, or if Revolut's native CSV export produces formatting that trips up your accounting software during import.
Importing Your CSV into Accounting Software
With a clean CSV in hand, importing into your accounting tool follows a familiar pattern.
Xero: Go to Accounting > Bank Accounts, select your Revolut account, and click Import a Statement. Map the date, amount, and description columns. Xero remembers your mapping for future imports.
QuickBooks: Navigate to Banking > Upload transactions. QuickBooks previews the data before committing, so you can verify everything looks correct.
FreeAgent: Head to Banking > Bank Accounts > Import. FreeAgent's guided column mapping makes the first import straightforward.
If you're using BankToFile's output, the columns are already structured for clean import — dates, descriptions, and amounts in separate, correctly formatted columns.
Tips for Revolut Users
Export each currency account separately. If you hold multiple currencies in Revolut, each balance has its own transaction history. Export and convert each one individually to avoid mixing GBP and foreign currency transactions in the same file.
Watch for UTC timestamps. Revolut defaults to UTC for transaction times. If you're in the UK during BST (March to October), some late-evening transactions may appear dated to the following day. Check your settings — Revolut Business lets you add local time to CSV exports.
Align to the UK tax year. For self-assessment, export statements covering 6 April to 5 April. This saves you from having to splice together calendar-month exports later.
Exclude internal transfers. Transfers between your Revolut accounts, vaults, or savings pockets appear as separate transactions. When importing into accounting software, categorise these as internal transfers to avoid inflating your income and expense totals.
Keep original PDFs. HMRC and mortgage lenders want to see the original bank statement document. Retain the PDF as your official record and use the CSV for analysis.
Common Issues and Fixes
CSV opens with garbled characters. Revolut's exports use UTF-8 encoding. When opening in Excel, use Data > From Text/CSV and select UTF-8 as the encoding to ensure special characters display correctly.
Dates in the wrong format. Revolut may export dates in a format your spreadsheet doesn't auto-recognise. Select the date column, use Format Cells > Date, and choose your preferred format. Or use =DATEVALUE() to convert text strings.
Amounts showing as text. If values are left-aligned and won't sum, select the column, go to Data > Text to Columns, choose Delimited, and click through to force numeric parsing.
Missing transactions. Double-check your date range and ensure you've selected the correct currency account. Vault or savings pocket transactions may not appear in the main account export.
Conclusion
Revolut gives you more export options than many traditional banks, but the native CSV output doesn't always arrive in a format that's ready for accounting software. Multi-currency complexity, UTC timestamps, and vault transfers all add wrinkles that need attention.
For a clean, reliable spreadsheet from any Revolut statement, try BankToFile's free converter. Upload your PDF, choose your format, and have accounting-ready data in seconds.