Import CSV or Excel into Microsoft Money: convert CSV or Excel to QIF
Microsoft Money imports OFX and QIF files. Convert your CSV or Excel file to QIF first, then import it. Read the full Microsoft Money import guide.

What is a CSV file
CSV (comma-separated values) is a plain text file with one transaction per row and columns for date, amount, description and other fields. Every bank and payment service uses its own column names and layout, so no two CSV files look exactly the same. An Excel file (XLS or XLSX) works the same way here.
CSV column mapping
Different CSV files use different column names. A PayPal export uses different headers than a bank export. ProperConvert detects the columns automatically in most cases. If your CSV has unusual column names or splits amounts into separate debit and credit columns, use the manual mapping option to tell the app which column contains which value. Once mapped, the app remembers the layout for the next file from the same source. See CSV column mapping.
Can any CSV file be converted?
Most bank and credit card CSV files can be converted. The file needs at least a date column and an amount column. Files that put deposits and withdrawals in separate columns, or use unusual date formats, may need manual column mapping before converting. Remove any summary rows above or below the transactions.
What is a QIF file
QIF is an older plain text format for transactions, with a line for each date, amount, payee, memo, check number and category. It has no transaction IDs and no currency. More about QIF.
Why convert CSV to QIF
A bank's CSV or an Excel file has its own columns, while QIF has a fixed line for each detail. QIF is a plain text format that apps without OFX support often import, and it can carry categories. It has no transaction IDs, so import each period only once.
Before you import: back up Microsoft Money
Back up your Money file before you import any file, so you can restore it if the transactions come in wrong.
Step by step: convert CSV or Excel to QIF
- Download, install and start ProperConvert. The trial is free.
- Open your CSV or Excel file.
- Review the transactions to see how the app read your file. Check that the dates are correct, and that expenses are negative and deposits (payments to the account) are positive. The "Change +/-" button reverses the signs for the whole file, for bank and credit card accounts alike.
- Set the QIF settings below.
- Click Convert, then confirm the file name and location.
Set the QIF output settings
In the QIF tab on the right sidebar, set:
- QIF target: MS Money or other. For an older non-US Money, select old MS Money non US.
- Output date format: the format of the country settings of your Money installation.
See all QIF settings.
Import the QIF file into Microsoft Money
QIF imports work better through Recover Accounts than through Downloaded Statement.
- Start Money and select File > Import > Recover Accounts.
- Select the QIF file and open it.
- Review the imported transactions. QIF has no transaction IDs, so import each period once.
See the Microsoft Money import guide for more.
Microsoft Money QIF questions
OFX or QIF for Microsoft Money?
OFX is the preferred format, and its transaction IDs let Money skip transactions you already imported. QIF works too, but it has no IDs, so import each period once.
Which date format should a QIF file use?
The format of the country settings of your Money installation. Set it as the output date format in ProperConvert.
Which import command should I use for QIF?
Recover Accounts. QIF imports work better there than through Downloaded Statement.
Related Microsoft Money conversions
- Import PDF into Microsoft Money: convert PDF to QIF
- Import CSV or Excel into Microsoft Money: convert CSV or Excel to OFX
- Import OFX into Microsoft Money: convert OFX to QIF
- Import QFX into Microsoft Money: convert QFX to QIF
- Import QBO into Microsoft Money: convert QBO to QIF
- Import MT940 into Microsoft Money: convert MT940 to QIF