.QIF

Файл QIF

Quicken Interchange Format
Задать вопрос
БЫСТРЫЙ ОТВЕТ

A QIF (Quicken Interchange Format) file is a plain-text export of bank or credit-card transactions, originally made by Intuit for Quicken. It is meant to be imported into personal-finance software, not opened as a document. To open it free, use GnuCash on Windows, Mac, or Linux. To get the data into Excel, convert QIF to CSV first.

Разработчик: Intuit Inc. Категория: Файлы данных Открыть стандартное MIME: application/qif
ОТКРЫВАЕТСЯ НА Windows macOS Linux
Связанные: .PKPASS · .DAT · .JSON · .RIS

На этой странице

Проиндексировано расширений: 19k+
Последняя проверка: Jul 22, 2026

Не знаете, что это за файл?

Перетащите любой файл в наш идентификатор - мы прочитаем первые байты, чтобы определить формат.

Идентифицировать файл

Что такое формат файла QIF?

.qif files are used by financial software Quicken. QIF files contain data related to a user's financial accounts stored in plain ASCII text format, which is commonly supported by other software.

QIF format is used for transferring transaction data from a financial institution's website to a user's hard drive, or as a means of exchanging data between Quicken data files. Each record uses single-character field tags - D for date, T for amount, P for payee, M for memo, L for category - terminated by a ^ caret on its own line, with the record set identified by a header such as !Type:Bank or !Type:CCard.

The .qif format was developed by Intuit. It is now regarded as largely obsolete for bank downloads, replaced by .QFX and .OFX since the late 1990s, though it persists for app-to-app account migration. A known limitation is that QIF carries no running-balance reconciliation data, and its ambiguous date format (M/D/Y vs D/M/Y) is a frequent cause of import errors. GnuCash, KMyMoney, and other open-source finance tools still support it.

Безопасность и защита

РИСК: LOW

A QIF file is plain text with no executable code, so opening it cannot harm your computer. The real concern is privacy, not malware: QIF contains account numbers (in transfer references), payees, balances-by-transaction, and full statement history. Don't email it unencrypted, upload it to untrusted online converters, or leave it in shared folders. Prefer offline importers (GnuCash, KMyMoney, Quicken) for sensitive statements, and delete the file once imported.

Детали формата

в двух словах
ПОЛНОЕ НАЗВАНИЕQuicken Interchange Formatтакже известен как QIF file, Quicken Interchange Format file
РАЗРАБОТЧИКIntuit Inc.с early 1990s (Quicken for DOS/Windows); Intuit no longer endorses or supports the format
КАТЕГОРИЯФайлы данных
MIME-ТИПapplication/qif
ТИПFinancial transaction data; plain-text tag/value records (ASCII)
СТАНДАРТОткрытый · без роялти
СВЯЗАННЫЕ.pkpass.dat.json.ris
Это расширение также используется в…
  • QuickTime Image File - Older Apple QuickTime still-image format (.qif); now obsolete and unrelated to the financial Quicken format.
  • DR-DOS QInstall script - Legacy installer/queue file seen on some DR-DOS systems; rare and unrelated.

Программы, открывающие файлы QIF

Windows4 apps
Quicken Платно File > File Import > QIF File - imports into cash/asset/liability accounts (modern Quicken blocks QIF for bank/credit accounts).
GnuCash Открытый код File > Import > Import QIF, pick the .qif, set the date format, match it to an account and confirm. Free, full-featured accounting.
Notepad Открытый код Open as text to inspect the raw tagged records (read-only understanding; won't reconcile it).
ProperSoft QIF2CSV / Transactions Платно Open the QIF to view it and convert to CSV/Excel for spreadsheets or other apps.
macOS3 apps
GnuCash Открытый код File > Import > Import QIF, pick the .qif, set the date format, match it to an account and confirm. Free, full-featured accounting.
MoneyWell Платно File > Import to bring in QIF transactions (verify the current vendor/build before recommending).
Quicken (Mac) Платно Import the QIF where supported; current Quicken for Mac replaces the discontinued Quicken Essentials.
Linux2 apps
GnuCash Открытый код File > Import > Import QIF, pick the .qif, set the date format, match it to an account and confirm. Free, full-featured accounting.
KMyMoney Открытый код File > Import > QIF... to load transactions. Free KDE finance app (current site is kmymoney.org).

Технические подробности

глубокая спецификация
File encodingPlain ASCII text; occasionally Windows-1252 for accented characters in payee names
MIME type`application/qif`; also `application/x-qw` and `text/plain`
File signatureNo binary signature - first line is a `!Type:` or `!Account` header (e.g. `!Type:Bank`, `!Type:CCard`, `!Type:Invst`)
Record delimiterEach transaction block is closed by a `^` caret character on its own line
Bank/Cash/CCard field tags`D` date · `T` amount · `P` payee · `N` check number · `M` memo · `L` category · `C` cleared status
Investment field tagsAdds `Y` security name · `I` price per share · `Q` quantity · `O` commission · `$` transfer amount
Account-type headers`!Type:Bank`, `!Type:Cash`, `!Type:CCard`, `!Type:Invst`, `!Type:Oth A`, `!Type:Oth L`
Date formatAmbiguous - `M/D/Y`, `M/D'Y`, or `D/M/Y` depending on locale; no enforced standard, a frequent source of import errors
Running balanceNot stored - QIF records individual transactions only; no reconciliation totals or end-of-period balances
CompressionNone - files are uncompressed plain text
EncryptionNone - account numbers, transaction amounts, and payee names are exposed in plain text
Typical file size1 KB to 5 MB (from a few transactions to several years of statement history)
Specification statusUnversioned; de facto frozen since the late 1990s - Intuit no longer endorses or maintains the format
Superseded byOFX / `.qfx` for bank-to-software downloads (from 1997); QIF persists for manual account-migration workflows
DeveloperIntuit Inc.
Выпущенearly 1990s (Quicken for DOS/Windows); Intuit no longer endorses or supports the format
Последняя версияNo formal versioned spec; de facto frozen since the late 1990s
Открыть стандартноеДа · без роялти
Спецификацияweb.intuit.com

Конвертации QIF

Вопросы и ответы сообщества

спрошено пользователями
Задать быстрый вопрос
Получите помощь от людей, работающих с файлами QIF. Будьте конкретны - укажите вашу систему и версию ПО.
Аккаунт не нужен · ответы обычно в течение дня

Вопросов пока нет - станьте первым, кто спросит о файлах QIF.

Часто задаваемые вопросы

How do I open a QIF file for free?
Use GnuCash (Windows/Mac/Linux): File > Import > Import QIF, choose the file, set the correct date format, and match it to an account. KMyMoney on Linux/Windows also imports QIF. Both are free and open-source.
How do I import a QIF file into Excel?
Excel can't read QIF directly. Convert it to CSV first (with ProperSoft QIF2CSV, GnuCash, or a QIF-to-CSV converter), then open or import the CSV in Excel or Google Sheets.
Why won't Quicken import my QIF file?
Modern Quicken only imports QIF into cash, asset, and liability accounts - not bank or credit-card accounts, where it expects OFX/QFX 'Web Connect'. It also fails on wrong date formats. Use GnuCash, or convert the QIF to QFX.
What's the difference between QIF and OFX/QFX?
QIF is the older, plain-text Quicken format with no balance/reconciliation data; OFX (and Intuit's QFX flavour) is the newer bank-download standard with account identifiers and validation. Banks moved to OFX/QFX; QIF survives mostly for app-to-app migration.
Can I edit a QIF file in a text editor?
Yes - QIF is plain ASCII with one tag per line (D date, T amount, P payee), records ending in '^'. You can fix dates or amounts in Notepad++/TextEdit, but keep the tag structure intact or importers will reject it.
How do I convert a bank CSV statement into QIF?
Use a CSV-to-QIF converter (ProperSoft, or online tools) that maps your CSV columns to the D/T/P fields. This is common when a finance app only imports QIF but your bank exports CSV.

Ссылки

1Wikipedia - Quicken Interchange Formaten.wikipedia.org
2Intuit QIF File Format FAQ (archived spec)xl2qif.chez-alice.fr

Узнать больше

по всей базе данных

Популярные расширения на этой неделе

1.AQQAQQ Instant Messenger File
2.CRDOWNLOADChrome Partial Download File
3.PARTPartial Download File
4.DATProgram Data File (generic)
5.EXEWindows Executable (Portable Executable)
6.NOMEDIAAndroid No-Media Marker File
7.BINCD/DVD Disc Image (BIN/CUE)
8.RPMSGRestricted Permission Message
9.TMPTemporary File
10.XDWDocuWorks Document

Похожие расширения

.PKPASSApple Wallet Pass (formerly Passbook)
.DATProgram Data File (generic)
.JSONJavaScript Object Notation file
.RISResearch Information Systems citation file
.OFXOpen Financial Exchange
.CSVComma-Separated Values

Бесплатные инструменты для файлов

Идентификатор файлов и конвертер изображений в браузере - все работает на вашем устройстве.

Открыть инструменты

Обзор расширений файлов A-Z