Convert NatWest Excel to QBO / QFX / OFX

NatWest says it no longer offers a midata download. The replacement they document is an Excel or PDF export of the transactions you searched for. The help page does not mention CSV, QBO, QFX, or OFX. Excel is enough for the converter.

Convert your file now: open the converter. It runs in your browser, your statement is never uploaded, and it's free up to 30 transactions per file.

Export to Excel

Do you offer the ability to obtain midata? says:

  1. Select Statements & transactions from the main menu, then View transactions under Your transactions.
  2. Choose the account, set any fields that narrow the search, and press View transactions.
  3. When the results are on screen, select Export to Excel or Download PDF.

Choose Export to Excel. The PDF is not a file this converter reads. The article does not say how far back the search can go, so use the range on the screen rather than a number from somewhere else.

CSV columns

The source linked below does not publish the column headings in the file. After you download it, use the header row you actually see. In the converter, map a date, a description, and either one signed amount or separate money-in and money-out columns. The preview rewrites dates as YYYY-MM-DD so you can confirm the day and the month before you download.

Convert it

  1. Open the converter and drop in the CSV or Excel file. Excel (.xlsx or .xls) is fine.
  2. If the bank put your name or account number above the table, set the header row to the row that names the columns.
  3. Map the date, the description, and either one signed amount or separate paid-in and paid-out columns. Confirm the dates in the preview, which shows them as YYYY-MM-DD.
  4. Choose QBO for QuickBooks Desktop, QFX for Quicken, or OFX, and download.

Import the converted file

FAQ

Where did midata go?

NatWest says midata was removed because Open Banking and the Excel or PDF export replaced it.

The file is .xlsx, not .csv.

That is what you want from Export to Excel. Drop the .xlsx file on the converter. You do not have to save it as CSV first.

Can I send the PDF to QuickBooks instead?

QuickBooks Online's upload article mentions PDF statements. Rowbridge does not read PDFs. The Excel export is the file to convert if you want a QBO or QFX file.

Sources

Last checked: 2026-10-28. Menus move. If a label on this page does not match what you see, use the bank's own help page linked below.