Quicken permits the user to download data to "Excel" as a file. Of course excel files can be opened with star, open, libre, GNumeric and many other linux compatible "office" packages.

So - particularly if it is a one off task,
1. Upload the qif data to quicken,
2. download it in "excel"
3. Upload to an office package and
4. Download to csv format.

You might also find that the download excel format is really just a csv file.

AP

2 members found this post helpful.

Actually, in the third link offered by TB0ne there's a ready-made Perl script using the library I suggested.

And a quick search shows that besides GnuCash, Grisbi, KMyMoney and Skrooge all can import QIF, and at least Skrooge, but I guess others as well, can export to CSV.

2 members found this post helpful.

Great!

And I should have noted that TB0ne also identified the GNUCash option, where that one should be "right there" in most distributions' repos and software managers.

So, at this point, not that I had much true suggestions, I guess it's up to the OP.

I tried Gnucash. It did a good job at importing the qif file, but a very bad job when trying to export it as a csv file. The csv file was about six times bigger than the qif file, and most of the characters in it were " for some reason. So while nominally it was a csv file, in actuality it was useless.

Perl, awk etc. I think it is unreasonable to expect non-programmers to spend weeks or months leaning a new language. It would be quicker to replace the characters by hand in a text file.

Please do not be so unfriendly and critical of people who ask for help here.

But great thanks to people who did try to help, much appreciated.

Solution not found, but I want to close this thread and try another approach.

The manual page for Finance::QIF has a simple example program which will be easy to modify, even without much perl scripting experience.

2 members found this post helpful.

I think you ought to consider that CSV is not a format you should use then, or perhaps you decided you wanted that, but didn't evaluate the need fairly.

For most people, the selection of CSV is so that it can be more universal, versus proprietary or rare of a file form.

It was already noted that the QIF file format is ASCII, and thus read-able, given the caveat that one needs to understand how Quicken represents data.

I also submit that a lot of data in a QIF file, is going to result in a lot of data in a CSV. So the complaint seems rather, "summary dismissive" about a tool that did what you originally asked.

I feel these types of things are what members like Ondoho and TB0ne are citing. And now include myself. Please realize I'm answering here as a fellow LQ member, I'm not in charge of the Software forum, and even if I were, my intentions here were to answer your question as best as I could.

What I'm thinking now is that you really need to describe better what you wished to result from all this.

To be clear, you've found something to convert QIF to CSV, and now you've made an unclear statement that it's not what you wanted.

Have you explored other options? skrooge, grisbi, kmymoney should be available in Linux Mint repos.

2 members found this post helpful.

Probably because it's easier to write something that always adds quotes than it is to conditionally add them only when strictly needed.

Such output is only useless if your CSV parser is not actually a CSV parser, but you can still easily remove the unnecessary quotes using any of several tools, e.g. XSV or Miller:

2 members found this post helpful.