Open/Import MS Money OFX file into Excel?

J

Joe User

Downloading data from an online banking website. Besides Quicken files
(WebConnect and QIF), the only other file format is MS Money OFX.

That is an ASCII format with HTML-like syntax. I am currently writing a
macro to parse it. But I wonder....

Is there any way to directly input an MS Money OFX file into Excel, other
than purchasing a conversion program?

A Google search reveals that this question has been asked before in other
forums. I did not see a usable solution.
 
R

Ron Rosenfeld

Downloading data from an online banking website. Besides Quicken files
(WebConnect and QIF), the only other file format is MS Money OFX.

That is an ASCII format with HTML-like syntax. I am currently writing a
macro to parse it. But I wonder....

Is there any way to directly input an MS Money OFX file into Excel, other
than purchasing a conversion program?

A Google search reveals that this question has been asked before in other
forums. I did not see a usable solution.

Well, I see there is a free ofx2csv converter available:

http://www.softpedia.com/get/Office-tools/Other-Office-Tools/OFX2CSV.shtml

--ron
 
J

Joe User

Ron Rosenfeld said:

Thanks. I had seen that, too; but I missed the fact that it is free and it
has a seal of safety from Softpedia. What can I say: it was late; I was
under pressure; I had my glassed on upside down; etc etc etc. :)

Oh well, the VBA converter was not difficult to write. And as it turns out,
I am dissatisfied with the content of the OFX file; the bank omitted some
important details that are visible online.

So I might give the QIF format a whirl. There is some chance that the
content is more complete. The bank's web page is titled "Download For
Quicken". So I get the feeling that support of an MS product (namely MS
Money) was an afterthought.

Thanks again.


----- original message -----
 
R

Ron Rosenfeld

Thanks. I had seen that, too; but I missed the fact that it is free and it
has a seal of safety from Softpedia. What can I say: it was late; I was
under pressure; I had my glassed on upside down; etc etc etc. :)

Oh well, the VBA converter was not difficult to write. And as it turns out,
I am dissatisfied with the content of the OFX file; the bank omitted some
important details that are visible online.

So I might give the QIF format a whirl. There is some chance that the
content is more complete. The bank's web page is titled "Download For
Quicken". So I get the feeling that support of an MS product (namely MS
Money) was an afterthought.

Thanks again.

I suppose I'm going to have to figure out how my Money program is going to work
when MS ceases all support for it. I'm not looking forward to it. But I'm
hoping for a viable solution. For me, the quote download issue will be quite
important. And, I'm sure, others will have other priorities.

Good Luck!
--ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top