Help! I used to read a QIF files with Numbers 2.3 so many years ago. As time has passed and I'm on macOS Sierra 10.12.6 and Numbers 4.2. So I suppose that Numbers 2.3 will not work on current config. Quicken 2007 will read QIF but that was there source of the snip-it of data I'm trying to reads hopefully into Numbers. Any ideas will be helpful.
thanks Stowell
Mac mini, macOS Sierra (10.12.6), Numbers 4.2
What are you doing after you right-click? Just right-clicking won't give an error, it will give you a menu of choices. My guess is that you are choosing "Open with…" & selecting an app that can't open the file. My Mac, running Sierra, macOS 10.12.6, gives me lots of choices, most of which can't open a QIF file. For me, choosing Numbers 4.2 gives an error. Choosing Numbers 2.3 does open the file but it puts everything in the first column. The file I chose took over 22,000 rows. TextEdit will do a better job than Numbers 2.3. EDIT: LibreOffice gives the same result as TextEdit does, as it opened it as a text file.
So, I don't think you will have any luck with Numbers 4. You really need a finance program to open the file. There are quite a few free or trial ones available for you to try.
Hi, Thanks for reaffirming that's the way I have don't it years ago. When I right click the QIF file I get error message essentially saying I need to reinstall N4+ which I will do tomorrow. Thanks again
I do not understand your problem with Quicken 2007 and QIF.
However have you tried the products of Propersoft.net?
Ever since American Express stopped offering a QIF download, I use their csv2qif product for Mac to download my monthly American Express transactions (my principal charge card) in csv format, use csv2qif to convert it to QIF and then import it into my Quicken 2007 master file!
It works like a charm!
They offer many other translators too; worth the Thirty something dollars they each cost!
Numbers 2.3 should work on Sierra. It coexists happily with Numbers 4. For reading QIFs Numbers 2.3 is still your easiest solution. From there you can copy-paste to Numbers 4.
SG
I use Numbers 2.3 as well as Pages 4.3 in Sierra 10.12.6 daily without significant issues. Actually no issues for me but I know some people do have some issues.
I still open files from my bank in Numbers version 2.3.
Reading QIF format
