Convert QIF to Excel in seconds. Turn any Quicken .qif export into a clean .xlsx workbook with dates, payees, and amounts split into columns and reconciled.
No account needed for your first conversions. We never store your bank login.
A QIF file will not open in Excel as a spreadsheet. It is plain text, but Quicken stores every field on its own tagged line (D for date, T for amount, P for payee) instead of in rows and columns, so a straight open drops one long single column of tags into the sheet rather than a ledger you can sort or total. A QIF to Excel converter reads those tags and rebuilds them into a real workbook: one transaction per row, with the date, payee, memo, category, and amount each in their own column. Upload your .qif above and you get an .xlsx file back in a few seconds, plus matching CSV and QuickBooks-ready QBO copies from the same run.
Last updated July 2026. This page is for turning a QIF into an Excel workbook you can filter, pivot, and hand to a client or a spreadsheet. If your goal is to load the transactions into QuickBooks instead of into Excel, the QIF to QBO converter writes a Web Connect file that imports as a bank feed. If you want a plain comma file for another accounting tool, the QIF to CSV converter covers that.
Every conversion is reconciled before you download it. The converter adds up the transactions it parsed out of the QIF and matches that against the file total, so splits, foreign date orders, and Quicken's apostrophe two-digit years do not quietly produce a workbook that is short a few rows or a few hundred dollars. You see the parsed rows and the reconciled total on screen first.
Built for the QIF files Quicken and finance tools actually export, checked before it exports.
The converter adds up the transactions it parsed and matches that to your file total before you export, so nothing is silently dropped.
Valid OFX 1.02 with QuickBooks Web Connect headers. Online and Desktop import it as a standard bank feed.
Date, payee, and amount are read straight from the QIF tags, so there is nothing to map and no layout to match.
Bulk upload for catch-up and cleanup work. Each file gets its own reconciliation check and its own exports.
Mixed date formats, apostrophe years, currency symbols, and split lines in a QIF are cleaned up and summed before the .qbo is built.
One conversion, three files: the .qbo for QuickBooks, an XLSX to review, and a CSV for everything else.
Three steps. No column-mapping wizard.
Drag in a .qif export from Quicken, your bank, or another finance tool. Any QIF type works.
Every transaction is parsed and checked against your file total. You see the rows before exporting.
Download the .qbo and import it as a Web Connect bank feed. Excel and CSV are in the same download.
The specifics that decide whether the import is clean. If your case is not here, message us in chat.
No, not as a usable table. Excel opens a .qif file as text, but because QIF puts each field on its own tagged line rather than in columns, you see a single column of values like D01/15/2026 and T-42.19 instead of a transaction grid. You can walk it through the Text Import Wizard by hand, but you still have to reassemble each transaction from its scattered tag lines, which is exactly the work the converter above does for you in one step.
Upload the .qif to the converter at the top of this page, wait a few seconds while the tags are parsed, check the transactions and the reconciled total on screen, then download the .xlsx workbook. There is no column mapping to set up and no template to pick, because the converter reads the QIF tags directly. The same screen offers CSV and QBO copies of the identical data if you need them.
The workbook has one row per transaction with separate columns for Date, Payee or Description, Memo, Category, and a single signed Amount, with money out shown as a negative. Split transactions are summed into that one Amount so each transaction stays on one row, and the header row is frozen-ready so you can sort, filter, or drop a pivot table on top without cleaning anything up first. Numbers come through as real numbers, not text, so SUM and subtotal formulas work immediately.
QIF carries no date-format declaration, so 03/04/2026 reads as March 4 in a US file and April 3 in a European one, and a plain import has to guess. Quicken also writes two-digit years with an apostrophe, as in D01/15'26, which Excel mangles into text. The converter scans every date in the file to work out the real format before it writes a single row, so the workbook opens with dates that are correct and sortable instead of shifted by nine months or stored as text.
Batch upload takes a set of .qif files at once and converts each into its own reconciled workbook, which is the usual path for catch-up bookkeeping when a client hands over a year or more of exports. Each file keeps its own reconciliation check and its own XLSX, CSV, and QBO exports. See the bulk QIF converter for how batch runs are priced and handled.
It should not, and the converter checks that it did not. Amounts are read from the QIF T tags exactly as written, splits are summed rather than dropped, and the total of every parsed transaction is matched against the source file before export. If the two totals disagree the converter tells you, rather than handing you a clean-looking workbook with rows missing.
Upload a QIF export, get a QuickBooks-ready .qbo back in seconds. No card to try it.
Choose Excel when a person needs to work with the data: reviewing a client's year, cleaning up payee names, building a pivot of spending by category, or splitting a file by date range. Go straight to QBO when the destination is QuickBooks, because a Web Connect file lands in the banking review queue as a native bank feed, keeps the signs and structure intact, and skips the three-column rules QuickBooks Online enforces on manual spreadsheet uploads. QuickBooks does not accept QIF files at all, which is the reason a converter sits between the two.
Related guides: QIF to CSV converter, QIF to QBO converter, QIF to QuickBooks Online, bulk QIF to QBO converter, how to open a QIF file, and what a QIF file is. If you are starting from Quicken itself rather than from a QIF file, see exporting Quicken to Excel.
For the solo bookkeeper running a monthly close in QuickBooks.
USD / month
billed $288 yearly
For a firm or finance team converting across many clients and currencies.
USD / month
billed $888 yearly
For multi-bookkeeper firms managing many client books at scale.
USD / month
billed $2,988 yearly
