Can't use my CSV files from bank, how to convert QFX to QIF
Moderator: Renato
-
April
- New User
- Posts: 1
- Joined: Sat Dec 03, 2016 2:32 am
- Are you a spam bot?: No
- Contact:
Can't use my CSV files from bank, how to convert QFX to QIF
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?
-
spoker
- New User
- Posts: 14
- Joined: Wed Nov 09, 2016 11:24 pm
- Are you a spam bot?: No
- Contact:
Re: Can't use my CSV files from bank, how to convert QFX to
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.
I would open the csv in excel, and replace name in letters by a number, save it again as csv and import it then.
-
Nikolay
- Developer
- Posts: 1506
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
- Contact:
Re: Can't use my CSV files from bank, how to convert QFX to
That is smart solution.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.
This issue looks like feature request.
-
Nikolay
- Developer
- Posts: 1506
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
- Contact:
Re: Can't use my CSV files from bank, how to convert QFX to
Another option is to set cells format for colunm after excel import of a csv file.
Then export it to csv again.
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 7032 times
-
- screenshot.305.jpg
- (31.74 KiB) Downloaded 7032 times
Who is online
Users browsing this forum: No registered users and 2 guests