converting .xls or .csv into .qif

Asked by nagaraj on 2009-07-13

my bank accounts details can be downloaded in .xls format. but my accounting software reads .qif format. is there any way of converting .xls or .csv formats into .qif?

Question information

Language:
English Edit question
Status:
Expired
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Last query:
2019-02-06
Last reply:
2019-02-21
Vihar (vmankov) said : #1

There is an application GnuCash that you can try:

http://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_convert_from_CSV.2C_TSV.2C_XLS_.28Excel.29.2C_or_SXC_.28OpenOffice.org_Calc.29_to_a_QIF.3F

You can install it by Synaptic manager. Or find there other similar apps, just type "qif" in the Search field.

nagaraj (hamlet32) said : #2

yes i wanted this information. i am getting stuck at installing the macros. i mean i am not able to do that. eg. calc2qif1.03 zip file has an .sxc file that opens with OO.org calc and shows a button ' install' i click on it - nothing happens. though the documentation says nothing about the OS, i suspect it is an installer for windows. how can install it in linux? i m using ubuntu/hardy, oo.org 2.4.1.

Can you download it in quickbook format. My bank has this and gnucash imported it ok (back when I used to do all this stuff)

The app should have a way to import XLS. Maybe you can download to a non-proprietary format like a comma seperated text file.

nagaraj (hamlet32) said : #4

thanks but that did not seem to help. my bank allows dl in .xls format and
the application kmymoney seems to only take qif format. discussing with
kmymoney forum as well. any other solutions please let me know.
thanks again

On Mon, Jul 13, 2009 at 2:42 PM, actionparsnip <
<email address hidden>> wrote:

> Your question #76815 on openoffice.org in ubuntu changed:
> https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/76815
>
> Status: Open => Answered
>
> actionparsnip proposed the following answer:
> Can you download it in quickbook format. My bank has this and gnucash
> imported it ok (back when I used to do all this stuff)
>
> The app should have a way to import XLS. Maybe you can download to a
> non-proprietary format like a comma seperated text file.
>
> --
> If this answers your question, please go to the following page to let us
> know that it is solved:
>
> https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/76815/+confirm?answer_id=2
>
> If you still need help, you can reply to this email or go to the
> following page to enter your feedback:
> https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/76815
>
> You received this question notification because you are a direct
> subscriber of the question.
>

Launchpad Janitor (janitor) said : #5

This question was expired because it remained in the 'Open' state without activity for the last 15 days.

Launchpad Janitor (janitor) said : #8

This question was expired because it remained in the 'Open' state without activity for the last 15 days.

Launchpad Janitor (janitor) said : #10

This question was expired because it remained in the 'Open' state without activity for the last 15 days.