Convert Excel (.xlsx) to QIF for Quicken

How to convert an Excel sheet to QIF for Quicken

1. Keep the transactions on the first sheet with data, under a heading row such as Date, Description, Amount (or Debit and Credit), and save the workbook as .xlsx.
2. Upload the workbook above. We find the heading row, the date, description and amount columns, and turn Debit and Credit into one signed amount.
3. Check the preview. Withdrawals should show as negative; tick Flip signs if your sheet has them the other way. Pick Credit card when the sheet is a card account so Quicken gets a card QIF.
4. Download the .QIF, then make a backup of your Quicken data file before importing anything.
5. In Quicken for Windows, open File → File Import → QIF File, select the download and choose the Quicken account it belongs to.

Which Excel files work

• .xlsx and .xlsm workbooks. An older .xls needs File → Save As → Excel Workbook first, or save it as CSV and use CSV to QIF.
• The first worksheet that has data is read. A blank cover tab in front is skipped; if two tabs hold transactions, drag the one you want to the front and save.
• Bank or account details above the table are fine when the heading row sits in the first 15 rows. Opening balance, totals and blank lines have no amount or date, so they're skipped and counted.
• Real Excel date cells, or typed dates like 09/30/2026, 2026-09-30, 30/09/2026 or 30-Sep-2026.
• A single signed Amount column, or two columns such as Withdrawal and Deposit or Money out and Money in.
• Free up to 100 rows, and up to 20,000 rows per file.

What the QIF looks like

Our sample workbook's first row (Debit 6,420.18 on 09/01/2026) comes out as:

!Type:Bank
D09/01/2026
T-6420.18
PACH DEBIT GUSTO PAYROLL 0912
MACH DEBIT GUSTO PAYROLL 0912
^

A Category or Notes column in the sheet isn't written to the QIF, and neither is the Balance column. Quicken's renaming and category rules apply once the transactions are in.

Every QIF record letter, including ones this converter does not write, is explained with a real sample on QIF file format.

Common problems

Other conversions

• Have a CSV instead? The CSV to QIF converter writes the same QIF from a .csv download.
• Going to QuickBooks rather than Quicken? Excel to QBO for Online or a Desktop version with Web Connect, or Excel to IIF for QuickBooks Desktop.
• QIF back to a spreadsheet: the QIF to Excel converter keeps Quicken's categories in their own column.
• Need an OFX for Xero, Sage or GnuCash instead? Excel to OFX.
• Have a bank .ofx or .qfx? The OFX / QFX to QIF converter.
• Only have PDF statements? The bank statement PDF to QIF converter checks each one against its opening and closing balance first.
• Not sure QIF is the file you need? See QBO vs IIF vs QIF.