Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

CSV File

0 views
Skip to first unread message

DMc2007

unread,
Sep 8, 2008, 1:58:37 PM9/8/08
to
Hi

My bank only exports statements for CSV. Does anybody know of any free CSV
to QIF converters, or any CSV to OFX converters.

Kind Regards

D

Dick Watson

unread,
Sep 8, 2008, 2:34:10 PM9/8/08
to
Yes.

I haven't updated the links i quite some time, so some may be dead and you
may end up googling. With that disclaimer in mind, see
http://umpmfaq.info/faqdb.php?q=8.

Ken

unread,
Sep 8, 2008, 3:02:39 PM9/8/08
to
Hi,

I use Microsoft Works Database, it will open .csv file.

Example qif report from my database

!Type:Bank
D8/11'2008
C5268
MP&L PLBILL
T-65.57
PPower&Light
LHousehold:Electric
^

This is the formula In Report....

Title: !Type:Bank
Record: ="D"&D Field
Record: ="C"&C Field
Record: ="M"&M Field
Record: ="T"&T Field
Record: ="P"&P Field
Record: ="L"&L Field
Record: ^
Record:

Ken

"DMc2007" <davidmcnau...@hotmail.com> wrote in message
news:558A5522-F0C4-4DD4...@microsoft.com...

John Pollard

unread,
Sep 9, 2008, 9:31:20 AM9/9/08
to
Dick Watson wrote:
> Yes.
>
> I haven't updated the links i quite some time, so some may be
> dead
> and you may end up googling. With that disclaimer in mind, see
> http://umpmfaq.info/faqdb.php?q=8.

I couldn't display that link.

But I can say the free Excel macro, "xl2qif", will do the trick
(Google for it). You just open the .csv file in Excel, tell
"xl2qif" which columns contain which fields, and export to a
.qif file.

--

John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup


Dick Watson

unread,
Sep 9, 2008, 5:02:01 PM9/9/08
to
Hmmm. I get to it. You may be going through a proxy server that white lists
the web. My "heritage" employer has taken to doing that lately. Sucks.

But, yes, that resource is one I list, IIRC.

"John Pollard" wrote:

> Dick Watson wrote:
> > http://umpmfaq.info/faqdb.php?q=8.
>
> I couldn't display that link.
>
> But I can say the free Excel macro, "xl2qif", will do the trick
> (Google for it). You just open the .csv file in Excel, tell
> "xl2qif" which columns contain which fields, and export to a

> ..qif file.

John Pollard

unread,
Sep 9, 2008, 7:59:29 PM9/9/08
to
Dick Watson wrote:
> Hmmm. I get to it. You may be going through a proxy server
> that white
> lists the web. My "heritage" employer has taken to doing that
> lately.
> Sucks.

I think I got one of those 404 errors when I tried it this
morning. But I tried again just now and got there fine (as I
have every other time I tried, except this morning).

John Pollard

unread,
Sep 9, 2008, 8:03:57 PM9/9/08
to
John Pollard wrote:
> Dick Watson wrote:
>> Hmmm. I get to it. You may be going through a proxy server
>> that white
>> lists the web. My "heritage" employer has taken to doing that
>> lately.
>> Sucks.

> I think I got one of those 404 errors when I tried it this
> morning. But I tried again just now and got there fine (as I
> have every other time I tried, except this morning).

Well that's weird. While at the page in your link, I decided to
click on the link to "xl2qif" ... got that old 404 error again.

Dick Watson

unread,
Sep 9, 2008, 8:27:05 PM9/9/08
to
I thought you were talking about a 404 on the umpmfaq site. Yes, the sites
it links too have not been validated/updated in several years. All bets are
off. Google is our friend.

"John Pollard" <inv...@invalid.com> wrote in message
news:OyQV4itE...@TK2MSFTNGP06.phx.gbl...

BrianW

unread,
Sep 10, 2008, 5:14:11 PM9/10/08
to

The link works for me, although many of the links from it are broken.

(Did you mean blacklist? Our proxy at work bans many sites, under
categories such as "sport", "food and drink", "entertainment". But you
get a message saying that the site has been blacklisted - and maybe a
warning from "internal systems" about possible disciplinary action...)

--
Brian

Dick Watson

unread,
Sep 10, 2008, 8:22:45 PM9/10/08
to
By white list, what I meant was that they explicitly deny any site that they
don't have categorized on whatever list it is they are buying from whomever
they are buying it. With hundreds of millions of websites out there, their
list has tens of thousands that are "acceptable".

Whitelist is a term-of-art for an explicitly permitted list when all else is
denied as opposed to a blacklist of things denied when all else is
permitted.

"BrianW" <br...@nospam.net> wrote in message
news:DMWxk.414$XE1...@newsfe11.ams2...

John Pollard

unread,
Sep 11, 2008, 9:28:59 AM9/11/08
to
Dick Watson wrote:
> I thought you were talking about a 404 on the umpmfaq site.
> Yes, the
> sites it links too have not been validated/updated in several
> years.
> All bets are off. Google is our friend.

When I first tried your site I got the 404 error. Then when I
was able to get to your site, the link to "xl2qif" failed with
the same 404 error.

I didn't try to double-check the actual "xl2qif" url at your
site, but I know that the "xl2qif" site - as found with Google -
is still functional.

http://xl2qif.chez-alice.fr/xl2qif_en.php

Philip@KKLTD

unread,
Oct 6, 2008, 7:14:00 AM10/6/08
to
try this link if you are still out

http://kkltd.co.uk/downloads.aspx

to support a *.csv from your bank, send sample csv to icrea...@kkltd.co.uk

0 new messages