Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Convert Quicken files to Excel

This is a discussion on Convert Quicken files to Excel within the Excel Questions forums, part of the Question Forums category; Hello friends: How would I convert Quicken files to Excel? My bank provides information in .qfx files. I do not ...

  1. #1
    New Member
    Join Date
    Jan 2011
    Posts
    7

    Default Convert Quicken files to Excel

    Hello friends:

    How would I convert Quicken files to Excel?

    My bank provides information in .qfx files. I do not own a Quicken program and I cannot locate a conversion tool.

    There must be thousands of people with the same dilemma...can someone please give me some advice and direction?

    Thanks in advance.

  2. #2
    Board Regular
    Join Date
    Apr 2010
    Posts
    750

    Default Re: Convert Quicken files to Excel


  3. #3
    New Member
    Join Date
    Jan 2011
    Posts
    7

    Default Re: Convert Quicken files to Excel

    Thanks Brian, for your quick response. Unfortunately, both of those links are dead.

  4. #4
    MrExcel MVP
    Moderator
    xenou's Avatar
    Join Date
    Mar 2007
    Location
    Clev. OH, USA
    Posts
    14,103

    Default Re: Convert Quicken files to Excel

    It's seems possibly that qfx is an xml-based format. What does it look like in notepad? I saw one reference that an ofx reader might work - not sure though.

    If you post sample data enclose it in noparse tags:
    [NOPARSE]your file data without sample data (not actual)[/NOPARSE]
    Last edited by xenou; Nov 4th, 2011 at 04:36 PM.

    Using: Office 2007/Win7 (work) Office 2010/Win7 (home)

    You are rich in proportion to the number of things you can let alone.
    -- Henry David Thoreau

  5. #5
    MrExcel MVP
    Moderator
    xenou's Avatar
    Join Date
    Mar 2007
    Location
    Clev. OH, USA
    Posts
    14,103

    Default Re: Convert Quicken files to Excel

    It's seems possibly that qfx is an xml-based format. What does it look like in notepad? I saw one reference that an ofx reader might work - not sure though.

    If you post sample data enclose it in noparse tags:
    [NOPARSE]your file with sample data[/NOPARSE]

    dummy up actual financial figures.

    Using: Office 2007/Win7 (work) Office 2010/Win7 (home)

    You are rich in proportion to the number of things you can let alone.
    -- Henry David Thoreau

  6. #6
    New Member
    Join Date
    Jan 2011
    Posts
    7

    Default Re: Convert Quicken files to Excel

    Quote Originally Posted by xenou View Post
    It's seems possibly that qfx is an xml-based format. What does it look like in notepad? I saw one reference that an ofx reader might work - not sure though.

    If you post sample data enclose it in noparse tags:
    [NOPARSE]your file with sample data[/NOPARSE]

    dummy up actual financial figures.
    Here is a tad of the stuff from .qfx to Notepad:

    OFXHEADER:100
    DATA:OFXSGML
    VERSION:102
    SECURITY:NONE
    ENCODING:USASCII
    CHARSET:1252
    COMPRESSION:NONE
    OLDFILEUID:NONE
    NEWFILEUID:NONE





    0
    INFO

    20111104025820
    ENG

  7. #7
    MrExcel MVP
    Moderator
    xenou's Avatar
    Join Date
    Mar 2007
    Location
    Clev. OH, USA
    Posts
    14,103

    Default Re: Convert Quicken files to Excel

    That appears to be a header of some kind. This is interesting:

    DATA:OFXSGML

    Do you see the data? It appears it may be be a form of ofx (ofxsgml) so there still hope an OFX reader would work, or we can parse the sgml markup.

    Using: Office 2007/Win7 (work) Office 2010/Win7 (home)

    You are rich in proportion to the number of things you can let alone.
    -- Henry David Thoreau

  8. #8
    New Member
    Join Date
    Jan 2011
    Posts
    7

    Default Re: Convert Quicken files to Excel

    Hi X...and thanks.

    I downloaded BRC OFX Reader. The final product looks like the notepad version...here's a sample:


    SRSV1>


    0
    INFO

    2.01E+10
    ENG

  9. #9
    MrExcel MVP
    Moderator
    xenou's Avatar
    Join Date
    Mar 2007
    Location
    Clev. OH, USA
    Posts
    14,103

    Default Re: Convert Quicken files to Excel

    Afraid you have to use the no parse tags to display the data in html (see my first post), or it comes out as garbage in a browser window.

    Using: Office 2007/Win7 (work) Office 2010/Win7 (home)

    You are rich in proportion to the number of things you can let alone.
    -- Henry David Thoreau

  10. #10
    New Member
    Join Date
    Jan 2011
    Posts
    7

    Default Re: Convert Quicken files to Excel

    Well, I do not understand how to use parse tags, so I have a couple of choices...

    1) a time-consuming work-around.

    or

    2) ask for advice and direction on parse tags.

    If you have the time and inclination, I would certainly follow up.

Page 1 of 2 12 LastLast

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com