Excel (XLSX) to QIF Converter

Excel (XLSX) to QIF Converter

A lot of personal and small-business bookkeeping lives in Excel long before it reaches Quicken: a budget workbook, a sheet of cash expenses, a statement the bank only offers as .xlsx. Quicken cannot open any of those. It imports QIF, a line-based text format from the 1990s that is still the most reliable way to load historical transactions into a Quicken account. This converter reads the first sheet of an Excel workbook and writes a QIF file from it.

Excel dates are the reason a spreadsheet-to-QIF step is worth having. In a workbook, a date is a number with a display format, and the same cell can look like 05/01/2026, 1-May-26, or 2026-05-01 depending on who formatted it. The converter reads the underlying date value, so real date cells always come out correctly whatever the display format. Only dates typed as text go through the same guessing logic as a CSV.

The workbook is opened in your browser with a JavaScript spreadsheet parser. It is not uploaded anywhere.

Key features

• Reads .xlsx and .xls files, including real Excel date cells and formula results, in the browser.
• Matches common bank and bookkeeping header names and merges Debit and Credit columns.
• Carries Category, Memo, and Check No columns into QIF L, M, and N lines.
• Previews the parsed transactions as a table and the QIF text before download.

About the XLSX to QIF format

Only the first worksheet is read, and the first row must be the header. Column names are matched against common variants, so Posting Date, Transaction Date, Payee, Narration, Particulars, Details, and Amt are all recognised without renaming. Blank rows are skipped.

A Debit column and a Credit column are merged into one signed amount, debit negative. A single Amount column is used as-is, with currency symbols, thousands separators, parentheses, and a trailing minus all handled. Formulas are read as their last calculated value.

Date cells are exported as YYYY-MM-DD regardless of their display format, then written to QIF as MM/DD/YYYY, which is what Quicken for Windows expects on a US-region machine. Dates stored as text are parsed like CSV dates; an ambiguous text date such as 03/05/2026 is read month-first unless another row in the sheet proves the file is day-first.

Each row becomes a QIF record under a !Type:Bank header: D for the date, T for the amount, P for the payee or description, then optional N (a Check No or Id column), M (a Memo or Notes column), and L (a Category or Account column), closed by a caret on its own line.

QIF has no encoding declaration. The file is written as UTF-8, which most current Quicken versions read correctly; older versions on Windows assume the system code page and may garble accented or non-Latin payee names.

Columns the converter does not know are ignored. A sheet with extra columns for running balance, notes to self, or receipt numbers converts without cleanup.

How it works

The workbook file is parsed, the first sheet is selected, and its cells are serialised row by row with dates rendered as YYYY-MM-DD.

The header row is matched against known column names to locate the date, description, amount or debit/credit, category, memo, and id columns.

Each data row is normalised: the date is resolved to a single calendar date, the amount is cleaned and signed, and empty rows are dropped.

The rows are written as QIF records under !Type:Bank and offered as a .qif download.

Common use cases

• Moving a household budget workbook with years of categorised spending into Quicken, keeping the Category column as Quicken categories.
• Importing a bank statement that a smaller bank or credit union only provides as an Excel download.
• Loading a cash expense log kept by a travelling employee into a Quicken Home & Business account.
• Recreating transactions for a closed account from an old Excel export when the bank's own download window has expired.
• Converting a shared expense tracker with Debit and Credit columns into a single QIF for a joint account.

How to use this tool

1. Open the workbook and make sure the transaction sheet is first and its first row holds the column headers.
2. Upload the .xlsx or .xls file.
3. Check the preview table: row count, that debits are negative, and that the dates match the sheet.
4. Download the .qif file.
5. In Quicken for Windows choose File → File Import → QIF File, pick the destination account, and import.

Example

Posting Date | Narration      | Debit  | Credit  | Category
2026-04-01   | Rent - Flat 4B | 950.00 |         | Housing
2026-04-02   | Salary April   |        | 3100.00 | Income

!Type:Bank
D04/01/2026
T-950.00
PRent - Flat 4B
LHousing
^
D04/02/2026
T3100.00
PSalary April
LIncome
^

Tips for best results

• Keep dates as real date cells. If a column shows dates aligned to the left, Excel is storing them as text; select the column and use Data → Text to Columns with the right date order to convert them.
• Put the sheet you want to convert first in the workbook, or copy it into a new file. Summary and chart sheets ahead of the data sheet are a common cause of an empty result.
• Use a Category column with names that match your Quicken categories exactly. Quicken creates unknown categories on import, and a near-miss spelling creates a second category you have to merge later.
• Delete total rows at the bottom of the sheet. A row with a date but a totals amount imports as a transaction.
• Export one account per workbook. QIF cannot say which account a record belongs to; Quicken asks for the account at import and applies it to every record in the file.

Common errors and how to fix them

The converter reports that the workbook has no sheets or that the first sheet is empty.

The data is probably on a later sheet. Move it to the front, or copy the transaction sheet into a new workbook and upload that.

Missing required columns, with a list of the headers that were found.

The header row is not the first row, or the columns use names the converter does not know. Delete any title rows above the headers and rename unusual headers to Date, Description, and Amount.

Dates in the QIF are a month off.

The dates were typed as text in day-first order and no row had a day above 12, so they were read month-first. Convert the column to real date cells in Excel, or reorder the text to month/day/year, and convert again.

Quicken imports the file but every transaction lands in a new account.

You are on a Quicken version that blocks QIF import into bank accounts, or the account prompt was skipped. Import into a Cash account and move the transactions, or update to a subscription version of Quicken for Windows.

Payee names with accents look garbled in Quicken.

Older Quicken versions read QIF in the Windows code page rather than UTF-8. Replace accented characters in the sheet before converting, or open the .qif in Notepad and save it with ANSI encoding.

Best practices

• Add a Category column in Excel before converting; categorising there with fill-down is faster than editing in Quicken.
• Keep the workbook with the .qif it produced, named by account and period.
• Back up the Quicken data file before importing. Quicken has no undo for an import.

Frequently asked questions

For more background on data formats and conversion workflows, read our format guides.