How to Convert a CSV File to QIF
Many banks only export account information and history in a comma-separated values (CSV) database format. If you want to manage the data from the popular Quicken financial management software, you'll need to convert the CSV file to Quicken Interchange Format (QIF). You can do this with a free Microsoft Excel add-in that provides enough customizable options to ensure smooth data transition to Quicken.
- Difficulty:
- Moderate
Instructions
Things You'll Need
- Microsoft Excel
- XL2QIF
Installation
- 1Download and unzip the XL2QIF application from the link in Resources.
- 2Double-click the "Install" icon in the folder that downloads to open the installation window in Microsoft Excel.
- 3Click the "Install" button in Excel. Choose your language (English or French) and restart Excel.
Conversion
- 1Open your CSV data file in Excel and highlight all the data you wish to convert.
- 2Click the "Add-Ins" tab at the top of the Excel window. Click the XL2QIF button and select "Save to QIF."
- 3Select the appropriate "Account Type" under "Options" in the window that pops up. It is "Bank" by default, but options like "Credit Card" and "Liabilities" exist.
- 4Find the "Standard Field" box and check the fields in your CVS file in the order that they appear. For instance, a bank account might have the date, then the amount, then the category, etc.
- 5Click the "Browse" button and select where you would like to save your QIF file. Click "Save" and then, back in the main window, "Convert."
Resources
How to Convert a CSV File to QIF
- Difficulty:
- Moderate
Instructions
Things You'll Need
- Microsoft Excel
- XL2QIF
Installation
- 1Download and unzip the XL2QIF application from the link in Resources.
- 2Double-click the "Install" icon in the folder that downloads to open the installation window in Microsoft Excel.
- 3Click the "Install" button in Excel. Choose your language (English or French) and restart Excel.
Conversion
- 1Open your CSV data file in Excel and highlight all the data you wish to convert.
- 2Click the "Add-Ins" tab at the top of the Excel window. Click the XL2QIF button and select "Save to QIF."
- 3Select the appropriate "Account Type" under "Options" in the window that pops up. It is "Bank" by default, but options like "Credit Card" and "Liabilities" exist.
- 4Find the "Standard Field" box and check the fields in your CVS file in the order that they appear. For instance, a bank account might have the date, then the amount, then the category, etc.
- 5Click the "Browse" button and select where you would like to save your QIF file. Click "Save" and then, back in the main window, "Convert."
- 1
Tidak ada komentar:
Posting Komentar