How do I open a quicken qfx file on my mac and import it into numbers

I have numbers 3.5.2 (2118) and would like to be able to open qfx files that i download from citibank to keep track of my expenditures.

Numbers does not load them, but at some point it used to.

Thanks for any help

Mac Pro, Mac OS X (10.7.3), last.fm audioscrobbler

Posted on Feb 27, 2015 7:13 AM

32 replies

SGIII

Level 8

37,532 points

Mar 1, 2015 11:04 AM in response to MlchaelLAX

Yes, the security aspects are worrying. Downloading an unencrypted text file (OFX/QFX/QIF or whatever) is perhaps no longer such a great thing to be doing, though I assume it occurs over a secure connection. ... OFX, at least the Citibank flavor, is clearly malformed XML. I found that out when I realized that on our Macs we all have a built-in XML parser associated with "System Events." Very nice. But that parser is *very* fussy, requiring lots of pre-processing in AppleScript to get the format just so. Good to have Lonnie West's post, because in a pinch I would guess Excel's XML import may be more forgiving.

Sep 5, 2015 9:23 AM in response to SGIII

Brilliant. Thank You.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

How do I open a quicken qfx file on my mac and import it into numbers