QIF to Excel converter
Turn a QIF file from your bank or Quicken into an Excel spreadsheet, one row per transaction. Your file never leaves your browser.
Excel
Google SheetsDrop a QIF file here
A .qif file from your bank or Quicken, up to 100 MB. It stays on your computer.
No file to hand?
- No sign-up
- Nothing uploaded
- Real dates and amounts
A spreadsheet you can sort and total.
Your file stays on your computer
The file is read and the spreadsheet is built in your browser. Nothing is sent to Mammoth or anyone else.
Dates sort, amounts add up
Dates are Excel dates and amounts are numbers with two decimals, so SUM works the moment the file opens.
Dates read the right way round
The converter works out from the file whether 03/10 means 3 October or 10 March, and you can switch it.
How to convert QIF to Excel
Each transaction becomes a row with its date, payee, amount, memo and category. Columns the file leaves empty are left out.
- 1
Add your QIF file
Drop a .qif file on the box, or choose one from your downloads.
- 2
Check the rows
A preview shows the transactions. Check the date order, or split money in and money out.
- 3
Download
Save the .xlsx file and open it in Excel, Google Sheets or Numbers.
Other ways to do it
Excel opens a QIF file as one line per field, not one row per transaction. The other way is a short Python script.
Python with quiffen and pandas
A script that runs every month
- Works out day or month firstNo
- Dates Excel can sortYes
- Amounts Excel can add upYes
- No code to writeNo
- This page
This converter
A spreadsheet in one step
- Works out day or month firstYes
- Dates Excel can sortYes
- Amounts Excel can add upYes
- No code to writeYes
How to convert QIF to Excel in Python
The quiffen library reads a QIF file into a pandas table, and pandas writes the spreadsheet. Here is the whole script.
Need a CSV instead? The QIF to CSV converter lets you pick the date style. Have an OFX, QFX or QBO file? Use the OFX to Excel converter.
from quiffen import Qif
qif = Qif.parse("checking.qif", day_first=True)
df = qif.to_dataframe()
df["category"] = df["category"].map(lambda c: c["hierarchy"] if isinstance(c, dict) else "")
df[["date", "payee", "memo", "amount", "category"]].to_excel("checking.xlsx", index=False)quiffen 4.0.1 with pandas and openpyxl. You tell it the date order: in our test, a UK file read without day_first=True put 2 January on 1 February. The category is a Python dictionary until the third line turns it into text.
Your file stays private
The converter runs inside this page. Your QIF file is read and turned into a spreadsheet on your computer, and nothing is sent to Mammoth. Your accounts and transactions stay with you.
Once the page has loaded, it works with your internet switched off.
Getting a statement every month?
Mammoth can take it from there. Put each month's Excel file in a folder and the rows are added to one table, ready to filter, total and download.
Bank statements
Drive
DropboxOneDrive
SFTP| August | Aug 01 | Harbor & Pine Payroll | 2,150.00 | |
| August | Aug 14 | City Water Utility | -58.12 | |
| September | Sep 02 | Blue Door Coffee | -4.50 | |
| October | Oct 11 | Corner Market | -83.19 | |
| October | Oct 31 | Interest paid | 0.42 |
Illustration. Every new file in the folder is added to the same table.