1.. Launch Excel, click "File" and select "Open."
2.. Click the "All Excel Files" drop-down menu and select "All Files."
3.. Navigate to the location of your OFX file, select the file and click "Open." An Excel prompt reporting that the OFX file is a different format will display. Simply click "Yes" to continue.
4.. Select "As an XML table" and then click "OK." An Excel prompt notes that a schema for the table does not exist but that Excel will generate one for you based on the data. Simply click "OK" to continue.
https://www.techwalla.com/articles/how-to-import-ofx-files-into-microsoft-excel