Question: how to open qif file in excel?
Answer: Download and install 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.