Open a QIF file in Excel

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

Related articles

• Convert MNY files to CSV or Excel
• Open an OFX file in Excel
• Open a QFX file in Excel