Home Quicken for Mac Product Ideas - Quicken for Mac Manage Accounts and Transactions (Mac)

Import Transactions from CSV file or spreadsheet

I would like to be able to import transactions into an investment account from a csv file or spreadsheet. Since Merrill Lynch does not download cash sweeps as transactions, I have to enter numerous transactions manually in order to reconcile my Quicken balances with the balances at Merrill Lynch. The format for the data could be set by exporting a csv file from the transaction register and setting up the file to be imported to match the format of the exported file.
14
14 votes

Not Planned · Last Updated

https://community.quicken.com/discussion/7720798/importing-csv#latest

Comments

  • FrankxFrankx SuperUser ✭✭✭✭✭
    I think this is long overdue and would actually be a feature that folks new to Quicken would certainly value and appreciate.


    Quicken H&B-Subscription - Ver. R29.20 - Build 27.1.29.20  - Windows 10 Home - Ver. 2004
                                             - - - - Quicken User since 1984 - - - 
      -  If you find this reply helpful, please click "Like" (below), so others will know! Thank you.  -
  • jacobsjacobs SuperUser, Mac Beta Beta
    It's a reasonable request, but… since Quicken's business model is built around having financial institutions sign on to support Quicken, and the software is built to prevent duplicate transactions with a unique identifier for each transaction imported, I think it's pretty unlikely they will ever toss all of that and allow users to upload .csv transaction files.
    Quicken Mac Subscription • Quicken user since 1993
  • hoffmtjhoffmtj Member ✭✭
    edited January 20
    I understand that it is in their interest to not do this, but in a case where they all ready have download capability for transactions from a financial institution I think a restricted ability to load certain historical information would not jeopardize their revenue stream. In my case the information can be downloaded from Chase and with a few minor manipulations in Excel; the data I need to load cost information is available. I can download stocks from Chase directly into Quicken, but than have to deal with the placeholder issue which is not easy.
  • jacobsjacobs SuperUser, Mac Beta Beta
    If Chase works with Quicken, and Chase allows you to download older data in csv format, then the question is why you can’t download the same data in the QFX format which *can* be imported into Quicken. Maybe something to pursue with Chase...
    Quicken Mac Subscription • Quicken user since 1993
  • JEThomJEThom Member
    I would find csv file or spreadsheet input very helpful.
  • jw2991jw2991 Member
    I use my vehicle for a business and have many tolls on an EZ Pass. It's easy to export them to a spreadsheet from EZ Pass. Would love to be able to import rather than hand entering.
  • SloanSloan Member
    It is August 2020 and Quicken is not able to import excel and csv files. My new credit card accounts only export to excel & csv. There too many transactions for my business and rental properties to enter manually.. Any hopes of seeing this option any time soon?
  • Quicken_TykaQuicken_Tyka Moderator mod
    Hello @Sloan

    Thank you for taking the time to visit the Community to post your question.

    The ability to import transactions from an Excel or CSV file is currently not planned.

    To import transactions into Quicken from a financial institution requires that the bank be a participating financial institution.

    If you would like to see your bank added to Quicken, please contact them directly and request this. 

    I apologize for not having better news.

    -Quicken Tyka
    Happy Harvest! Gobble! Gobble!
  • jacobsjacobs SuperUser, Mac Beta Beta
    Sloan said:
    It is August 2020 and Quicken is not able to import excel and csv files. My new credit card accounts only export to excel & csv. There too many transactions for my business and rental properties to enter manually.. Any hopes of seeing this option any time soon?
    @Sloan  It might help if you post which credit cards you have that you are unable to connect with Quicken. Most credit cards do work with Quicken, but there are a variety of connection methods. Some which do not provide a file download in the Quicken-supported QFX format do support directly downloading into Quicken.
    Quicken Mac Subscription • Quicken user since 1993
  • hopewinterhopewinter Member
    I have a business that deals in cash. I have my transactions in Excel. How can I import these into Quicken?
  • jacobsjacobs SuperUser, Mac Beta Beta
    @hopewinter  Unfortunately, there is no way to import transaction entries from an Excel file. You will have to enter the transactions -- or what's meaningful for you to have in Quicken -- manually.
    Quicken Mac Subscription • Quicken user since 1993
  • Jim ThompsonJim Thompson Member ✭✭
    I too would sure like to see the capability of importing transactions from a separate .csv or Excel file!!
This discussion has been closed.