Convert XLSX to QIF
Turn XLSX workbooks into QIF. The first worksheet must have the header row a bank statement converted to xlsx here has, naming only the columns account, date, amount, currency, payee, memo, reference, balance, type, category and id, in any order, with dates as date cells or YYYY-MM-DD text and amounts as numbers in every row; any other sheet fails with unsupported_elements.
Converted in an isolated sandbox on our serversDeleted after 24 hours
Drop XLSX files on the dialor turn it to pick what to do
A QIF file of your transactions.Each row of the sheet becomes a transaction in one file.
What you get
One QIF file with an !Account block and a !Type section for each account in the sheet. Each transaction carries its date, amount, payee, memo and category. The reference is written as the check number.
Dates are written month first as MM/DD/YYYY, whatever form they have in the sheet.
What the sheet must look like
The first worksheet must have a header row that names only these columns, in any order: account, date, amount, currency, payee, memo, reference, balance, type, category and id. Dates are date cells or YYYY-MM-DD text. Amounts are numbers in every row.
Any other sheet fails with
unsupported_elements. If you have several workbooks to combine first, you can merge XLSX files.What is dropped
QIF has no place for currency, balance, transaction type or id, so those columns are not in the QIF file. If you need them, keep the XLSX file.
XLSX and QIF.What each format is.
The formats
Excel Workbook
Excel's workbook format since 2007. Sheets, formulas, formats and charts in zipped XML.
- Extensions
- .xlsx
- MIME type
- application
/vnd .openxmlformats -officedocument .spreadsheetml .sheet - Kind
- Documents
Quicken QIF
Quicken Interchange Format, the plain-text list of transactions with dates, amounts, payees and categories that Quicken, Microsoft Money and many banks export.
- Extensions
- .qif
- MIME type
- application
/x -qif - Kind
- Text and data
In your code.The same XLSX to QIF conversion through the API, for your app or your agent.
$ cv convert sheet.xlsx sheet.qif$ cv convert sheet.xlsx sheet.qifQuestions.What people ask about XLSX to QIF.
The first worksheet. It must have the header row described above.
The sheet does not match the expected layout. This happens when it has columns other than the listed ones, or a different kind of sheet.
Yes. Dates can be date cells or YYYY-MM-DD text. In the QIF file they are written as MM/DD/YYYY.
No. QIF holds no currency, so that column is dropped, along with balance, type and id.