Open a QIF file in Excel

Modified on Mon, Jul 5, 2021 at 2:25 PM

Quicken Interchange Format (QIF)

QIF files are Quicken Interchange Format files containing details about transactions:

Downloaded from your bank, credit card company, investment broker
Created as an export file by Quicken
Created as an export file by some personal finance software

How to view or open a QIF file

Download and install the Transactions app, QIF2CSV or Bank2CSV
Start QIF2CSV and locate a QIF file
Review transactions
Click Save to save a CSV file and then open it in Excel (or other spreadsheet application) or click Copy to clipboard and then switch to Excel and click Paste there

Supported Account types

Bank (Checking/Savings/Credit Line)
Credit Card
Investment