How to Export a Monzo Statement to CSV/Excel

By BankStatementReader Team · June 21, 2026

Monzo is an app-based bank with no branches, so everything to do with your statements happens inside the app. If you need to budget, file a tax return, or hand figures to an accountant, you will usually want either a formal statement as a PDF or your raw transactions as a CSV. This guide covers how to get both from the Monzo app, then convert and clean the data so it is ready for Excel or CSV. (Menu labels change from one app version to the next, so treat the steps below as the typical route rather than exact wording.)

Statement versus transaction export

It helps to know the difference before you start, because Monzo offers two related things:

A statement is the formal, dated document covering a chosen period. It usually comes as a PDF and is the file an accountant, landlord, or lender expects to see.
A transactions export is a CSV (or sometimes a spreadsheet) of the underlying rows — dates, descriptions, amounts, and categories. It is the easier format to work with in Excel.

If someone has asked you for "a statement", they almost always mean the PDF. If you want to analyse your own spending, the CSV export will save you a conversion step.

Export a Monzo statement (PDF) from the app

The PDF statement is the one to use for official purposes.

Open the Monzo app and log in.
Go to the account you need a statement for. If you hold more than one Monzo account or pot, make sure you have selected the correct one.
Look for the account's Statements or Export option. Depending on your app version this may sit under the account details, a settings cog, or a documents area.
Choose the statement period you need.
Save or share the PDF — most versions let you save it to your phone's files or email it to yourself so you can move it to a computer.

If you cannot find the option straightaway, search the app's help or account settings; the wording and location move around between releases.

Export Monzo transactions as a CSV

When you want to work with the figures rather than just read them, a CSV is the better starting point.

Open the account in the app and look for an Export or Export transactions option.
Choose the date range you want to cover.
Select CSV (or a spreadsheet format) as the output.
Save or email the file to yourself, then open it on a computer for cleaning.

A CSV opens directly in Excel, Numbers, or Google Sheets, so you often skip the PDF conversion entirely. The trade-off is that you may still need to tidy the columns, which we cover below.

Choosing the right period

For a Self Assessment tax return you may need a full tax year, which runs 6 April to 5 April. Cover the whole range so there are no gaps. You can check the dates and deadlines on GOV.UK.
For a mortgage or loan application you are often asked for the last three to six months — export each period as required.
Keep the original PDF or CSV even after you convert it. It is your source document if anyone needs to verify the figures.

Why convert the PDF to Excel or CSV?

A PDF is fine for reading, but it is awkward for anything analytical. You cannot sort it, total a column, or filter by payee. Once the transactions are in a spreadsheet you can:

Categorise spending and build a monthly budget.
Total expenses for an expense claim or tax return.
Import the rows into accounting software for bank reconciliation.
Spot duplicate or unexpected payments, such as a forgotten subscription.

How to convert a Monzo PDF to a spreadsheet

If you only have the PDF statement, there are three common ways to get it into a spreadsheet, and the right one depends on how many statements you have.

Type it in by hand

For one short statement, you can open the PDF next to a blank workbook and key in each row. It needs no tools, but it is slow and a single mistyped figure in a balance column is easy to make and hard to find afterwards.

Copy and paste

If the PDF has a real text layer (rather than being a scan), you can sometimes select the transaction table and paste it into Excel. Expect to tidy up: columns often collapse together, and longer payment descriptions can break the row alignment. Excel's Data → Text to Columns helps split the pasted text back into separate fields.

Use an automated converter

A dedicated converter reads the statement, detects the transaction table, and exports clean rows straight to Excel or CSV — including scanned or image-only pages that copy-paste cannot handle. This suits anyone who processes statements every month or has several to get through. Drop your file into the free bank statement converter to export tidy rows to Excel or CSV.

For a fuller walkthrough of all three methods and the trade-offs of each, see how to convert a bank statement to Excel.

Cleaning a Monzo CSV for Excel

Even when you start from a CSV, a little tidying goes a long way:

Check that the date column is read as a date, not as text, so you can sort by it.
Confirm amounts are treated as numbers rather than text, otherwise totals will not add up. Watch for stray currency symbols or spaces.
Decide whether incoming and outgoing amounts sit in one column or two — accounting software often expects a particular layout.

Pick a format: XLSX or CSV

Export to XLSX when you want formatting, formulas, or several sheets in one file. Choose CSV when you need to import the data into accounting or bookkeeping software, which usually expects a plain comma-separated file. Either way, once the data is structured you can move on to budgeting, reconciling, or filing with confidence.

A quick recap

Open the Monzo app and select the correct account.
For an official document, use the account's Statements or Export option to save a PDF; for analysis, export your transactions as a CSV.
If you have a PDF, convert it to Excel or CSV — by hand, by copy-paste, or with an automated bank statement converter.
Tidy the columns, then keep the original file as your source document.