Archive for the ‘Export’ Category

Importing into Quicken with QIF files

March 1, 2010 Leave a comment

Intuit is slowly trying to phase out the use of the QIF file format in place of a newer QFX format.  QFX cannot be supported by applications such as iReconcile.

 Why QFX (OFX) cannot be supported

OFX is a format for transmitting financial data.  Quicken does NOT support OFX.  Instead, they use a (slightly) modified version of the format they call QFX (Quicken Financial Exchange).  In short, the reason why iReconcile, and other similar applications, cannot support the QFX format is because Intuit (makers of Quicken) license out a special key that must be present in the QFX file in order to import it into Quicken.  This licensing is given to financial institutions (banks, etc).  Since OFX and QFX are out of the question, the only option left is QIF.

Note: quicken essentials 2010 for Mac does not support QIF format.

How to import QIF into Quicken

The answer to that question depends on which OS you are running:

Quicken for Mac:

Download the .QIF file from the export email.  

  1. Open Quicken and navigate to the account you want to import into.
  2. In the menus, find the option that says “Import” or “Import QIF.”
  3. Select the QIF file and you should be all set
Quicken for PC
Quicken for PC is a bit trickier because of Intuits move to phase out the QIF format.  There is still a way, however.
  1. Import your QIF file into a temporary “Cash” account.
  2. Move the transactions into the account you want (Checking, Credit, etc.)
To import the transactions into the Cash account, do the following:
  1. Open Quicken and navigate to your temporary Cash account
  2. In the menus, choose the “Import” or “Import QIF” option, and select the downloaded file.
  3. Follow the instructions for importing.
Categories: Export, Quicken

Properly import CSV files into Excel

March 1, 2010 Leave a comment

Some users have been having trouble importing CSV files into Excel.  If you are experiencing any difficulties importing info Excel (such as all data in one column), this may help you.  Although this was written to support those using Excel 2007, it applies to all versions (of course, the steps might be slightly different). 

  1. In Excel go to the “Data” tab and click “From Text”
  2. Select the .CSV file that was emailed to you
  3. Check the “Delimited” radio button, and click Next
  4. Check the “Comma” delimiter, and click Finish
  5. Excel will then ask you what cell to start adding the records, so just select the cell you would like to use.
Categories: Excel, Export