Question: how to open ofx file in excel?
Answer: Select All Files from the drop-down menu on that window. Then select the OFX file, and press the Open button. An Excel dialog box window will then open. ...  Then select the As an XML table option, and press the OK button.