Convert QIF files to CSV/Excel (QIF2CSV)
This tutorial shows how to convert a QIF file from your bank or credit card statement to CSV format.
Use the ProperConvert app to convert QIF to CSV. Other formats are supported as well.
Step by step instructions for Windows
Follow the steps below for the Windows version, followed by the Mac version.
Make sure you are using the latest version of QIF2CSV. Download it from the QIF2CSV download page. Start QIF2CSV and select a QIF file.
Review transactions before converting. Check that dates are correct, have the correct year, amount, withdrawals, and deposits are shown in corresponding columns.
Choose the CSV target: Regular CSV, Excel (XLS or XLSX), Quickbooks Online, Xero, Quicken for Mac (CSV Mint), POSH or copy to clipboard to be pasted into any spreadsheet software like Excel.
Click the 'Convert' button to create a CSV file.
Confirm the file name and location.
Now the CSV file is created.
Review created CSV file and import it into Quickbooks Online, Xero or work with the file in Excel.
See this Windows tutorial as a video:
Step by step instructions for macOS
Make sure you are using the latest version of QIF2CSV. Download it from the QIF2CSV download page.
Start QIF2CSV and select a QIF file.
Review transactions before converting. Check that dates are correct, have the correct year, amount, withdrawals, and deposits are shown in corresponding columns.
Choose the CSV target: Regular CSV, Excel (XLS or XLSX), Quickbooks Online, Xero, Quicken for Mac (CSV Mint), POSH or copy to clipboard to be pasted into any spreadsheet software like Excel.
Click the 'Convert' button to create a CSV file.
Confirm the file name and location.
Now the CSV file is created.
Review created CSV file and import it into Quickbooks Online, Xero or work with the file in Excel.
See this macOS tutorial as a video: