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

Blaniac
Blaniac Quicken Windows Subscription Member ✭✭
edited May 2021 in Download, Add/Update Accounts (Windows)
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.
Tagged:

Best Answer

Answers

  • Chris_QPW
    Chris_QPW Quicken Windows Subscription 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:
    This is my website (ImportQIF is free to use):

    http://www.quicknperlwiz.com/

  • Blaniac
    Blaniac Quicken Windows Subscription 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 Quicken Windows Subscription 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 Quicken Windows Subscription Member
    tried to access the link and it was not available
  • Greg_the_Geek
    Greg_the_Geek Quicken Windows Subscription SuperUser ✭✭✭✭✭
    http://www.quicknperlwiz.com/
    Quicken Subscription HBRP - Windows 10
  • Chris_QPW
    Chris_QPW Quicken Windows Subscription 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:
    This is my website (ImportQIF is free to use):

    http://www.quicknperlwiz.com/

This discussion has been closed.

Categories