LedgerPortQIF to CSV converter
Turn a QIF file from Quicken or another finance program into a CSV for Excel or Google Sheets. The file is converted in your browser and never uploaded. Free at any size.
Confirming your payment…
Your licence key. Keep it: it unlocks your other computers, and it is printed on your invoice.
Your file is read on this device. It is never uploaded.
| File | Transactions | Status |
|---|
More than one account? Give each its own number, and reuse it every time, so your software files each statement under the right account.
More file details (optional)
These only label the file. The default bank ID 3000 is one QuickBooks recognises; you still choose your real account during import.
Columns (change these if the preview looks wrong)
| Date | Description | Amount |
|---|
Not reading your file correctly? Send us the column names
Your pass has ended. Lifetime keeps you going for good, and the pass you bought is deducted from its price.
Your 10 free documents have been used. Unlock this file, and every file after it:
Pay with CardApple PayGoogle PayLink
14-day refund if it does not work with your file. Secure checkout by Stripe: card, Apple Pay or Google Pay, with an invoice by email. Your file stays open here while you pay.
Buying for a team? Firm plans start at 3 users, at $69 per user a year.
Your licence
- Never uploaded. The file is converted on your device; it works with the internet off.
- See it before you pay. Every transaction is previewed for free.
- 10 documents free. No card, no account, no key.
- 14-day refund if it does not work with your file.
- Add your QIF file Drop it on the box above or click to choose it.
- Check the preview Confirm the dates, payees and amounts look right.
- Download Save the CSV file.
Reading QIF in a spreadsheet
QIF stores each transaction as a short stack of lines. The converter reads the bank, cash and credit card registers in the file and writes one row per transaction. Investment registers and category lists are left out.
Using the CSV
The CSV has three columns: date, description and amount, with money out as negative numbers. It opens directly in Excel, Google Sheets and Numbers, and it is the layout QuickBooks Online and Xero accept for manual bank uploads.
Questions and answers
The dates came out wrong. Why?
QIF does not say whether dates are month-first or day-first. The converter works it out when it can; otherwise set Day and month order yourself and check the preview.
Is my file uploaded?
No. The file is read and converted by this page on your own device. It works with your internet connection switched off.
Is it free?
Yes. Turning a QIF file into a spreadsheet is free, with no limit on the number of transactions and no account.