Convert an Excel Workbook to a Web Connect QFX

Excel holds the data, Quicken wants a QFX

A lot of people track spending in Excel, a running sheet of dates, amounts, and descriptions. Quicken cannot open that workbook: for bank accounts it imports a QFX, a Web Connect file, and nothing else. So the data is right there, in the wrong container. Converting the Excel sheet to QFX moves those rows into the format Quicken reads, without you re-entering a single line into the register by hand.

Formulas, serial dates, and formatted cells

Excel is where a spreadsheet differs from a plain file, and those quirks have to be handled. Amounts are often the result of formulas rather than typed numbers, so the conversion takes each cell's resolved value, not the formula text. Dates are stored as serial numbers behind whatever display format you chose, so they are read as real calendar dates rather than the underlying integers. And cells formatted with currency symbols or parentheses for negatives are read as the signed numbers they represent. The point is that what you see in the sheet is what lands in the QFX.

Pick the sheet and the columns

A workbook can hold several tabs and extra columns you use for your own totals, so the conversion needs to know which sheet holds the transactions and which columns are the date, the amount, and the description. Once those are identified, each row becomes one transaction. A tidy sheet, one tab, a clear header row, one row per transaction, converts cleanly, so it is worth removing subtotal rows or side calculations before converting rather than leaving them to be mistaken for transactions.

What the QFX adds on top

A QFX is more than the rows: Quicken expects an identifier on each transaction, a FITID, so it can skip duplicates, and Intuit headers that name the institution. An Excel sheet has neither. The conversion generates a FITID per row and adds the headers, so the file imports as a proper Web Connect download instead of being refused for lack of an institution. Your dates and amounts are untouched; this is scaffolding Quicken requires around them.

Accuracy and privacy

Because a formula error or a misread date would carry straight into Quicken, the transactions are reviewable in the converter before export, resolved values and all. The output is a standard QFX ready for Web Connect. Since the sheet holds real account activity, the file is processed to build the QFX and then deleted automatically, with nothing kept on a server afterward.

Frequently Asked Questions