Convert .qif or .ofx to .xls or Open Office format?

T

Tmuldoon

Hello,

My bank allows me to download transactions but only in .qif or .ofx
formats (Quicken and MS Money). Any way to get into Excel or Open
Offices Calc?

The .qif format looks like this in Word (2 records shown)

D01/02/2006
T-15.70
MPOS MERCHANDISE;COMPOOTER WARE #2173;
^
D01/02/2006
T-14.52
MPOS MERCHANDISE;CHEVRON 89002074;
^

I would like to see each line in separate filed - so I would have two
records like

D01/02/2006 T-15.70 MPOS MERCHANDISE;COMPOOTER WARE #2173;

D01/02/2006 T-15.70 MPOS MERCHANDISE;CHEVRON 89002074;


Since the 2nd filed is a number - any way I could strip out the 'T-'
so I could do calculations?

I don't have Perl or any scripting language on my XP home setup - any
suggestions?

Thanks,

Tmuld.
 
T

tom.ballantine

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
 
Top