Can't use my CSV files from bank, how to convert QFX to QIF

Page 1 of 1
4 posts
Can't use my CSV files from bank, how to convert QFX to QIF

April
New MMEX User

Posts: 1
Joined: Fri Dec 02, 2016 8:32 pm
My bank supplies CSV files that have the month in a 3 letter format rather than numbers so unless anyone can tell me how to use those I need to convert the QFX files that they can also supply into QIF files.  The only other download option for this bank is PDF, can that work?
Re: Can't use my CSV files from bank, how to convert QFX to

spoker
New MMEX User

Posts: 14
Joined: Wed Nov 09, 2016 5:24 pm
I don't think pdfs will work.

I would open the csv in excel, and replace name in letters by a number, save it again as csv and import it then.
Re: Can't use my CSV files from bank, how to convert QFX to

Nikolay
MMEX Developer

Posts: 2284
Joined: Sat Dec 06, 2008 8:27 am
Location: Sankt-Petersburg, Russia
spoker wrote:I don't think pdfs will work.

I would open the csv in excel, and replace name in letters by a number, save it again as csv and import it then.
That is smart solution.

This issue looks like feature request.
Re: Can't use my CSV files from bank, how to convert QFX to

Nikolay
MMEX Developer

Posts: 2284
Joined: Sat Dec 06, 2008 8:27 am
Location: Sankt-Petersburg, Russia
Another option is to set cells format for colunm after excel import of a csv file.
Then export it to csv again.

Code: Select all
10-ноя-2016;10.11.16;120;test;
11-ноя-2016;11.11.16;120;test;
12-ноя-2016;12.11.16;120;test;
Attachments
screenshot.307.jpg
(32.08 KiB) Downloaded 3 times
screenshot.305.jpg
(31.74 KiB) Downloaded 3 times
Page 1 of 1
Who is online

Users browsing this forum: No registered users and 14 guests