How to Convert NatWest Bank Statements to CSV (2026)

NatWest is one of the few major UK banks that actually offers a transaction export feature through online banking — but it comes with limitations that catch people off guard. The three-month search window, the unusual file format labels, and the lack of a proper mobile export option mean that getting a full year of clean CSV data still takes more effort than you'd expect. This guide covers every method, from NatWest's built-in tools to faster alternatives.

What NatWest Offers Natively

NatWest's online banking platform provides transaction downloads in several formats, including Excel, PDF, Quicken, and Microsoft Money. Here's how to access them.

Exporting from Online Banking (Desktop)

1. Log into NatWest Online Banking on a desktop or laptop
2. Select Statements & transactions from the main menu, then View transactions
3. Choose your account and click Show search to reveal the date filter
4. Select Search between two dates and enter your start and end dates
5. Click Search to load the transactions
6. Click the Export button and select "Excel, Lotus, 123, Text (CSV file)" from the dropdown
7. Verify the account and date range, then click Download

The "Excel, Lotus, 123, Text (CSV file)" label is confusingly named, but this is NatWest's CSV export option. The resulting file will open in Excel or any spreadsheet application.

Important Limitations

NatWest limits transaction searches to approximately three months at a time. If you need a full tax year of data (6 April to 5 April), you'll need to repeat the export process at least four times and stitch the files together manually. The export is also only available through desktop online banking — the mobile app doesn't offer CSV or Excel downloads.

For formal monthly statements, NatWest provides PDF documents through the Statements section. These are the official records, but they can't be directly imported into accounting software.

The Faster Alternative: Convert PDFs with BankToFile

If you need statement data beyond what the three-month export window covers — or if you'd rather not repeat the export process four times for a tax year — converting your NatWest PDF statements is often quicker.

BankToFile converts NatWest PDF statements to clean CSV or Excel files in seconds:

1. Download your statement PDFs from NatWest's online banking (Statements section)
2. Upload to BankToFile — it recognises NatWest's layout automatically
3. Choose CSV or Excel as the output
4. Download your file — transactions are extracted with properly formatted dates, descriptions, and amounts

This is particularly efficient during tax season when you need 12 months of statements converted. Upload all your PDFs at once instead of running four separate three-month exports through NatWest's online banking.

Importing into Accounting Software

With your CSV ready, here's how to bring it into the major UK accounting platforms.

Xero: Go to Accounting > Bank Accounts, select your NatWest account, click Import a Statement, and upload the CSV. Map the columns on first import.

QuickBooks: Navigate to Banking > Upload transactions. QuickBooks handles standard CSV well and previews before finalising.

FreeAgent: Head to Banking > Bank Accounts > Import. FreeAgent's guided mapping walks you through aligning columns.

Sage: Use the bank statement import feature and select CSV. Sage supports custom column mapping for non-standard file layouts.

BankToFile's output is structured for clean import into all of these platforms — dates, descriptions, and amounts in separate, correctly formatted columns.

Tips for NatWest Customers

Export in three-month chunks. Since NatWest caps searches at roughly three months, plan your exports accordingly. For a full tax year, download April–June, July–September, October–December, and January–March as four separate files.

Use consistent date ranges. Align your exports to the UK tax year (6 April to 5 April) rather than calendar quarters. This saves significant time when preparing self-assessment returns.

Check for overlapping transactions. When stitching together multiple three-month exports, watch for duplicate transactions at the boundary dates. Remove any duplicates before importing into accounting software.

Keep original PDFs. The PDF statements from NatWest are your official records for HMRC, mortgage applications, and visa documentation. Always retain these alongside your working CSV files.

Name files consistently. Use a convention like natwest-current-2026-Q1.csv so you can easily find specific periods later.

Common Issues and Fixes

Can't find the export button. You need to run a search first. Click Show search, enter your date range, and click Search. The Export button only appears after transactions are displayed.

Export option isn't available on mobile. NatWest's CSV export is desktop-only. Log in through a web browser on a computer — the mobile app doesn't support transaction downloads.

File format confusion. The option labelled "Excel, Lotus, 123, Text (CSV file)" produces a genuine CSV file despite the confusing label. It opens normally in Excel, Google Sheets, or any spreadsheet application.

Dates display incorrectly. NatWest's CSV may use a date format your spreadsheet doesn't auto-recognise. Select the column, use Format Cells > Date, and choose your preferred format.

Three-month limit is insufficient. If you need a longer period, either run multiple exports and combine the files, or download the PDF statements and convert them through BankToFile for a faster workflow.

Conclusion

NatWest's built-in CSV export is more capable than what most UK banks offer, but the three-month search limit and desktop-only restriction make it cumbersome for anyone who needs a full year of data. For a quicker, more flexible approach, converting your NatWest PDF statements with a dedicated tool saves real time.

Ready to skip the manual export process? Try BankToFile's free converter and turn your NatWest PDFs into clean spreadsheets in seconds.