How to Export Quicken Transactions to Excel or CSV

TL;DR: There are three ways to get Quicken transactions into Excel. Run a Transaction report and use Export to Excel Compatible File, which is fastest but produces a report layout with title rows and subtotals. Copy the register to the clipboard and paste it, which is quick for one account. Or convert the original QFX download to a spreadsheet, which is the only method that gives you a clean transaction table with signed amounts and a running balance that ties to the statement.

Method 1: export a Quicken report to Excel

Open Reports, choose Banking and then Transaction, set the date range and accounts, then use the export control and pick Export to Excel Compatible File. Quicken writes a tab delimited file that Excel opens. This is the built in path and it takes about a minute.

What you get is a report, not a data table. There is a title block at the top, account subheadings between sections, subtotal rows inside the data, and often a blank column or two from the report layout. Before you can pivot or sum anything you have to delete those rows, which is fine once and tedious every month. Amounts usually come through signed correctly, but check a known debit before you rely on it.

One thing to watch: customize the report columns before exporting rather than after. Adding the memo, check number, and category columns in the report settings is much less work than trying to reconstruct them in Excel later.

Method 2: copy the register and paste it

Open the account register, use Edit and then Copy Transactions or the copy to clipboard option in your version, then paste into a blank sheet. For a single account and a short period this is the fastest route of all, and the output is closer to a plain table than the report export.

The limitations show up quickly. It handles one account at a time, split transactions may collapse or paste awkwardly, and the date column often arrives as text rather than real Excel dates, which breaks sorting and month grouping until you convert it. Use it for a quick look, not for anything you are going to report from.

Method 3: convert the original QFX file

If you still have the QFX files you downloaded from your bank, converting those instead of exporting from Quicken gives the cleanest result. A QFX holds the raw transaction data before Quicken applied any renaming rules or categorization, and a converter writes it as one row per transaction with a header row, real dates, signed amounts, and the running balance where the file carries it.

That is the version that reconciles. Because the running balance comes through, you can check the ending figure against the statement and know the export is complete, which neither of the other two methods lets you do easily. Use the QFX to Excel converter for a formatted workbook, or the QFX to CSV converter if another program is going to read the file.

Can you export Quicken data to Excel without Quicken installed?

Yes, if you kept the QFX downloads. The Quicken data file itself is proprietary and needs the application to open, but the QFX files your bank produced are standard OFX data and any converter can read them. That makes conversion the practical route for an accountant handed a folder of downloads, or for anyone whose Quicken subscription has lapsed.

If you no longer have the QFX files, download fresh statements from your bank instead and convert those. The bank statement converter reads a PDF statement directly and gives you the same transaction table without Quicken in the loop at all.

Why does my exported Quicken file look wrong in Excel?

Because Quicken exports a report rather than a data set. The title rows, account headings, and subtotal lines are part of the report design, and Excel has no way to tell them apart from real transactions. The fix is to delete those rows before doing anything else, or to export from the QFX instead, which has no report formatting to strip out.

A second common problem is dates arriving as text. Select the date column, use Data and then Text to Columns, and set the column type to Date with the correct order. Until you do that, sorting puts December before February and no month grouping will work.

Which method should an accountant use?

Convert the QFX. Client bookkeeping work needs a transaction level table that ties to the bank statement, and the report export does not give you that without manual cleanup on every file. Conversion produces a consistent layout every time, which matters when you are processing a dozen accounts rather than one.

The exception is when the value is in the categorization your client already did inside Quicken. In that case the report export is the right choice, because it carries the categories and the QFX does not. Decide by asking whether you need the bank's version of the truth or the client's.

Turning the spreadsheet into something useful

Once the transactions are in Excel with real dates and signed amounts, the rest is ordinary spreadsheet work. Add a category column, use SUMIFS to total by category and month, and build a pivot table over the date and category columns to see where money actually goes. Keep the running balance column and check the last row against the statement each time you refresh the data, because that one check catches nearly every incomplete export.

If the end goal is a formal profit and loss or balance sheet rather than an analysis sheet, it is usually faster to feed the categorized transactions into a tool that builds the financial statements than to lay them out by hand in Excel.

Going the other direction

The reverse trip, spreadsheet back into Quicken, is a different problem. Quicken does not import CSV, so a spreadsheet has to become a QFX first. If that is what you need, the CSV to QFX converter builds the file Quicken accepts, and our guide on importing CSV transactions into Quicken covers the column mapping and the duplicate handling.

Last updated July 2026.