View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
[email protected] tom.ballantine@gmail.com is offline
external usenet poster
 
Posts: 1
Default Convert .qif or .ofx to .xls or Open Office format?

I've managed this.

Since its basically a text file, open it in a word processor,
including Open Office. Do a find and replace for "D[hrt]" where [hrt]
is whatever the word processor's code is for a return. In the replace
box, put in a pipe or some other delimeter, I wouldhave said a semi-
colon, but your file seems to already have semi-colon's in it. Then
have it replace all of those. Do the same with the other letters: T
and M.

What you want is a text file that looks like lines like these:

1/02/2006|-15.70|POS MERCHANDISE; COMPOOTER WARE #2173;
1/02/2006|-14.52|POS MERCHANDISE; CHEVRON 89002074;

Now, save it as a text file, when you open it in the spreadsheet, it
should guide you through confirting the pipes "|" into columns and
you'll be all set.

-TTB