Home > Support > Importing Data Into Quicken

Importing Data Into Quicken

Updated: 4/27/2012 | Article ID: GEN82389

  • Import a TurboTax data file
    1. Click on File on the top menu bar, select File Import, then click on TurboTax File...
    2. Browse your computer for your .TAX file to import. (If you have not saved a backup of your tax file, see these instructions.)
    3. Once you've selected the file, click on OK.
  • Import data from a financial institution Web site (Your financial institution may refer to this as Web connect.)

    Information is available to learn how to Download transactions, balances, and holdings from my broker.

  • Import data from a QIF file
    1. Backup your Quicken data file.
    2. If the account you want to import data into does not yet exist, create a new one.

      QIF import is available only for asset and liability accounts (including house and vehicle) and cash accounts. If you have purchased Quicken Premier Home & Business, you can use QIF to import transactions into accounts payable accounts and invoice accounts as well. QIF import is also available for any exported list, but the file you want to import the list into must already include a valid account.

      Note: QIF import is not available for checking, credit card, savings, 401(k), or any other brokerage accounts. To import transactions into these types of accounts, see the improved download solution replacing QIF.

    3. If you are importing the data from an external disk, insert the disk and copy the QIF file onto your hard drive.
    4. Select the  File menu and select Import > QIF File.
    5. The Location of QIF file field displays the preset path of the import file. Select the appropriate option:
      • Enter a name for the import file at the end of the existing path (make sure there is a backslash \ before the file name). Quicken will automatically add the correct file extension.
      • Click Browse to select a different location. If you need help determining where a data file is located, Quicken can help you find a file. Enter a name in the File name field, and then click OK to return to the QIF Import window.
    6. In the Quicken account to import into list, select the account you want to import the QIF file into.

      This list is limited to accounts that can import QIF files. QIF import is not available for checking, savings, or credit card accounts, or for 401(k) or any other brokerage accounts.

      Note: To import a list such as the Category List, you must select a valid account.

    7. In the Include in import field, select the checkbox items you want to include in the import process.
      • Select the Transactions checkbox to import data from the account register.
      • Select the Memorized payees checkbox to include items from the Memorized Payee List.
      • Select the Account List checkbox to include items from the Account List.
      • Select the Special handling for transfers checkbox if you have exported to several QIF files from a number of Quicken accounts in the same file and are using Import to re-create all the transactions by importing from several QIF files.
        This choice prevents duplicate transfer transactions when you import data from both the to and from accounts involved with transfers.
      • Select the Category List checkbox to include items from the Category List.
      • Select the Security lists checkbox to include items from the Security List and the Security Prices List.
      • If you have purchased Quicken Home & Business, select the Business lists checkbox to include items from the Invoice Items List and the Business Templates List.
    8. Click Next, and follow the on-screen instructions.

    Notes

    • You can import from lists without importing the transactions at the same time. This is a useful feature when you are setting up a new data file.
    • You can use QIF to import QuickPayroll data only into a new, empty Quicken data file (import into , select the Transactions, Account List, and Category List checkboxes, and click to clear the checkboxes for Memorized Payees and Special handling for transfers). 
  • Import security prices from an ASCII file

    If you have an Internet connection, the easiest way to update security prices is to download them. Otherwise, you can import security prices from a standard, comma-delimited ASCII file.

    1. Select the Investing menu and select Portfolio.
    2. Select the File menu and select Import > Import Prices.
    3. In the File (file name or full path) field, enter the name of the ASCII file that contains the price data. The data must be in an acceptable CSV (comma separated values) format.

      The following examples are all acceptable CSV formats. Note: Quicken can accommodate quotation marks in CSV formats:

      ABC, 123.456

      ABC, 123.456, 12/31/02

      ABC 123.456 12/31/02

      ABC, "ABC", 123.456, "12/31/02"

      "ABC", "123.456", "12/31

      To create a CSV ASCII text file in Microsoft Excel:

      1. Select the File menu, and select Save as.
      2. Click the Save in drop-down arrow and select Local Disk (C:). Saving the file to your local drive makes it easier to manually enter the path when importing the file into Quicken.
      3. Click the Save as  drop-down arrow and select CSV. (Comma delimited *CSV)
      4. Click Save to save the CSV ASCII text file.

      CSV format for security prices:

      The data must be in standard ASCII format with one symbol/price/date per line, separated by either commas or double spaces (using only one type of separator per line).

      If the file is improperly formatted, the following error occurs:

      "Unable to import security prices."

      The example below shows how to properly format security prices in Excel.

      csv format

      To import a CSV ASCII text file into Quicken:

      1. Select the Investing menu and select Portfolio.
      2. Select the File menu and select Import > Import Prices.
      3. Type the name or full path of the CSV ASCII text file and click OK.
    4. In the Date field, change the date information if necessary.

      If the file does not contain specified dates, import the prices to the date entered here. The currently selected date in Portfolio is the preset display in this field.

      Quicken matches prices with your securities if they have the same symbol. If your securities don't have symbols, you'll need to edit them first so they do.

    5. Click OK.

 

 
Community Discussions

Share advice with other Quicken customers about using our products and managing your finances.

Quicken Community
Still Haven't Solved It?
Did this article help you?
Content Article Feedback