Quicken to Excel: Export Quicken Transactions to Excel with a Quicken to Excel Converter

In Quicken for Windows, open File, then File Export, then QIF File. Choose the account, set the date range, include transactions, and save the .qif. Upload that file to the converter above and download the XLSX. For a single report instead of a whole register, run the report in Quicken and use its export button, which writes an Excel compatible file directly.

Take the register route when you want the underlying data and the report route when you want a finished view. Accountants and bookkeepers almost always want the register: it is the raw ledger, it reconciles against the account, and you can build any report you like from it in a pivot table. A Quicken report export is already an opinion about the data.

Partly. Quicken can export any report to Excel, and Quicken for Mac can export a single account register to CSV. What Quicken cannot do is export the whole file as a workbook with every account and every field intact. That is why the QIF export plus a converter remains the standard route on Windows for anything larger than one report.

The gap shows up as soon as you need more than one account. Report exports let you widen the scope but not the columns, and the register CSV on Mac is one account at a time. If you are pulling five years across six accounts for a tax reconstruction, you feel the difference immediately.

Quicken for Mac has not offered QIF export since Quicken Mac 2007, so use its CSV routes: open the account register and export it to CSV, or run a report and export that. You will repeat the export per account. If you also have access to Quicken for Windows, moving the file there first restores the QIF export and the full register conversion.

That missing QIF export is the single biggest difference between the two platforms for anyone migrating. It is worth knowing before you start rather than after you cancel the subscription, because a lapsed Quicken drops into a restricted mode and exporting anything gets harder. What still works after the membership ends is covered in what happens to Quicken data when your subscription ends.

Each transaction becomes one row with its date, payee, category, memo, check or reference number, amount, and cleared status where the QIF carries it. Split transactions keep their individual lines with their own categories and amounts, so a $2,400 payment split across three expense categories stays visible as three amounts rather than collapsing into one.

Dates are normalized on the way through, which matters more than it sounds. Quicken files written on older versions use two digit years with an apostrophe, a convention nothing else understands, and a naive conversion turns 2003 into 2103 or drops the row entirely. Amount signs are normalized too, so debits and credits stay on the correct side of the ledger.

Export the full year per account as QIF, convert to XLSX, then build a pivot table by category to get totals for each Schedule C or Schedule E line. Keep the converted workbook as your workpaper: it is the readable record of what was in Quicken on the day you exported, which is exactly what you want if a return is ever questioned.

One practical note for landlords and sole proprietors. Quicken categories rarely map one to one onto tax lines, so add a column next to the category and map each one to its tax line, then pivot on that column instead. Do it once and every following year is a copy of the same workbook with new data pasted in.

Treat any financial export the way you would treat the statements it came from. A QIF holds your transaction history: dates, payees, amounts and categories. It does not hold account passwords or full account numbers, because Quicken does not write those into the export. Convert it, check the output, and keep the copies somewhere your bank statements would be at home.

For firms handling client files, the same rule that applies to statements applies here: use the same secure channel you already use to receive client documents, and delete working copies when the engagement closes.