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

Blaniac

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.

Chris_QPW

You can use my program for that purpose (ImportQIF).
You can find it here:
QuicknPerlWiz - Use ImportQIF to import transactions into Quicken

Chris_QPW

You can use my program for that purpose (ImportQIF).
You can find it here:
QuicknPerlWiz - Use ImportQIF to import transactions into Quicken

Blaniac

Thank you @Chris_QPW!!! That worked perfectly and was immensely helpful! The UI and instructions are well executed and easy to follow.

Blaniac

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

tried to access the link and it was not available

Greg_the_Geek

http://www.quicknperlwiz.com/

Chris_QPW

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.