Convert QIF to ODS
Turn QIF files into ODS. Every transaction of the bank, cash, credit card and other asset or liability accounts gives a row with the account's name, the date, the amount, the payee, the memo, the check number and the category, and the categories of split lines are joined when the transaction names none.
Converted in an isolated sandbox on our serversDeleted after 24 hours
Drop QIF files on the dialor turn it to pick what to do
Your Quicken transactions in a spreadsheet.Each transaction becomes one row in an ODS sheet you can open in LibreOffice Calc.
What you get
One ODS file with one sheet, named after the QIF file. The sheet has a bold header and one row for every transaction of your bank, cash, credit card and other asset or liability accounts.
Each row holds the account's name, the date, the amount, the payee, the memo, the check number and the category. The columns are the same as in the CSV conversion. When a transaction has split lines and names no category itself, the categories of the split lines are joined into the category column.
How cells are typed
Dates are date cells shown as YYYY-MM-DD. Amounts and balances are number cells shown with as many decimals as the file wrote.
Every other column is text. Account numbers and ids keep their leading zeros and all their digits.
What is left out
QIF holds no currency, so the sheet has no currency column and amounts carry no currency. Investment transactions are left out, so they do not appear in the sheet.
For other targets, see every ODS conversion.
QIF and ODS.What each format is.
The formats
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
OpenDocument Spreadsheet
OpenDocument spreadsheet, the native format of LibreOffice Calc.
- Extensions
- .ods
- MIME type
- application
/vnd .oasis .opendocument .spreadsheet - Kind
- Documents
In your code.The same QIF to ODS conversion through the API, for your app or your agent.
$ cv convert report.qif report.ods$ cv convert report.qif report.odsQuestions.What people ask about QIF to ODS.
No. Investment transactions are left out. Only bank, cash, credit card and other asset or liability accounts give rows.
No. QIF holds no currency, so the amounts are numbers without one.
Yes. Account numbers and ids are stored as text, so leading zeros and all digits stay.
Each transaction is still one row. If it names no category, the categories of its split lines are joined into the category column.