into for older apps
FileInto converts an Excel bank statement (.xlsx) into a .QIF file for older Quicken versions and apps that still import QIF.
- Never uploaded, stays on your device
- Free preview
- Opens in Quicken and more
Have a different file, or need a different one? Click or above.
How to import the QIF file
Quicken (Windows)
- Go to File, then File Import, then QIF File.
- Select the .qif file from FileInto.
- Choose the Quicken account to import into, then Next.
- Review the imported transactions in the register.
Other apps
- Look for Import, then QIF in the File menu (Banktivity, Moneydance, MoneyWiz and others).
- Select the .qif file from FileInto.
- Pick the account to import into.
- Check the date format your app asks for: FileInto writes month first (10/03/2026).
What FileInto looks for in your file
| Column | Examples | Notes |
|---|---|---|
| Sheet | The first sheet in the workbook | Move the transactions to the first sheet if your workbook has several. |
| Date | 10/03/2026, 2026-10-03, Oct 3 2026, 03/10/2026 | Any common date style. If day and month are swapped, change "Dates in your file". |
| Description | STARBUCKS STORE 01234 | Payee or details. Long descriptions are kept in full in the memo. |
| Amount | -5.75, $1,234.56, (12.00), 12.00 DR | One signed amount column, or separate money out and money in columns. |
| Memo, check number, balance | Optional | Used when your file has them. The last balance becomes the statement balance. |
Problems and fixes
- Dates show up as numbers like 46298
- That is how Excel stores dates. FileInto reads real Excel dates, so this only happens when the column is formatted as text. Format the column as Date in Excel and save again.
- Summary rows at the top are counted
- Rows without a valid date are skipped and listed under "rows skipped". Delete totals and notes at the bottom if they have dates.
- Quicken won’t import QIF into a bank account
- Recent Quicken versions only accept QIF for some account types. Use QFX instead: switch "Save as" to QFX for Quicken.
- Transactions are duplicated
- QIF has no transaction ids, so apps can’t tell what you already imported. Import each date range once, or use OFX or QFX, which carry ids.
- Dates are wrong
- QIF dates are written month first. If your app expects day first, check its import date setting.
Questions
- What is a QIF file?
- QIF (Quicken Interchange Format) is an older plain-text format for transactions. Many apps still read it, but it has no ids to prevent duplicates.
- Is my spreadsheet uploaded?
- No. FileInto opens it inside your browser tab.
- Which Excel formats work?
- .xlsx and older .xls files. Only the first sheet is read.
- Can I convert a CSV instead?
- Yes. Drop a .csv file into the same converter; it reads both.
- What are the limits?
- Files up to 25 MB. Every file gets a full preview free. Downloads up to 25 transactions are free, no account needed; a Day Pass ($9 for 24 hours) or Unlimited ($7 a month) has no row limit. It works in current versions of Chrome, Edge, Safari and Firefox, on computers and phones.
Related converters
- CSVintoQIFFor older Quicken and other apps
- ExcelintoQBOFor QuickBooks
- ExcelintoQFXFor Quicken
- ExcelintoOFXFor Xero, Moneydance and GnuCash
Guides: What is a QIF file?
Bank-specific steps and quirks: Bank of America, Chase, Wells Fargo, Capital One and American Express.
Pick a converter
Every converter runs in your browser. Nothing is uploaded.
Turn your Excel file into
- CSVExcel and Google SheetsSoon
- QBOQuickBooksCurrent
- QFXQuickenCurrent
- OFXXero, GnuCash and moreCurrent
- QIFOlder QuickenCurrent
Make a QIF file from
- CSVBank or card CSV
- ExcelExcel statementCurrent
- PayPalPayPal activity
- StripeStripe payouts
- SquareSquare sales
- QBOQuickBooks bank downloadSoon
- QFXQuicken bank download
- OFXOFX bank downloadSoon
Bank and card files
Payment processors
- PayPalintoQBOFor QuickBooks
- StripeintoQBOFor QuickBooks
- SquareintoQBOFor QuickBooks
- PayPalintoQFXFor Quicken
- PayPalintoOFXFor Xero, Moneydance and GnuCash
- PayPalintoQIFFor older Quicken and other apps
- StripeintoQFXFor Quicken
- StripeintoOFXFor Xero, Moneydance and GnuCash
- StripeintoQIFFor older Quicken and other apps
- SquareintoQFXFor Quicken
- SquareintoOFXFor Xero, Moneydance and GnuCash
- SquareintoQIFFor older Quicken and other apps
Bank downloads
No converter for “” yet. Tell us what you need and we will look at it.