Convert Excel XLSX to QIF or QXF for Import into Quicken Bank Account

Blaniac
Blaniac Member ✭✭
Is there a safe and proven method and/or 3rd party program to setup and convert an Excel .xlsx file to .QIF or .QXF for import into a bank account in Quicken (Windows Subscription version)? The goal is to take an Excel transaction register and import it into Quicken to avoid all the manual entry.

Best Answer

Answers

  • Chris_QPW
    Chris_QPW Member ✭✭✭✭
    Answer ✓
    You can use my program for that purpose (ImportQIF).
    You can find it here:
    QuicknPerlWiz - Use ImportQIF to import transactions into Quicken
    Signature:
    (I'm always using the latest Quicken Windows Premier subscription version)
    This is my website: http://www.quicknperlwiz.com/
  • Blaniac
    Blaniac Member ✭✭
    Thank you @Chris_QPW!!! That worked perfectly and was immensely helpful! The UI and instructions are well executed and easy to follow.
  • Blaniac
    Blaniac Member ✭✭
    To be clear for the next person reading this thread, I used an Excel xlsx current MS Office 365 version and mapped all the columns I wanted using your tool to convert to QIF and import into the current subscription version of Quicken. The import was a transaction ledger into a Quicken bank (checking) account.
  • LWLeland
    LWLeland Member
    tried to access the link and it was not available
  • Greg_the_Geek
    Greg_the_Geek SuperUser, Windows Beta ✭✭✭✭✭
    Quicken Subscription HBRP - Windows 10
  • Chris_QPW
    Chris_QPW Member ✭✭✭✭
    LWLeland said:
    tried to access the link and it was not available
    Are you still having problems accessing the site?
    It is working fine for me.

    Note the site is hosted through Weebly/Square so I don't actually control administrate any part of accessing it and keeping it up, but it has been a very reliable web service.
    Signature:
    (I'm always using the latest Quicken Windows Premier subscription version)
    This is my website: http://www.quicknperlwiz.com/
This discussion has been closed.