Importing Data from Excel

Doug Laidlaw laidlaws at hotkey.net.au
Mon Sep 7 00:06:40 EDT 2009


Thanks James.  That is what I would have said.

It may be new.  I must confess that I haven't noticed it previously (I use QIF 
files,) and I am running the latest stable release, not the one from my distro.

Doug.

On Mon, 7 Sep 2009 12:57:43 pm James Raehl wrote:
> In the test version 2.3.5, select File > Import > Import CSV/Fixed
> Width.  It works exactly as you described.  I use it to import CSV files
> from my bank.  There are some bugs: amounts less than a dollar are set
> to 0; the Num often does not get input; the Num column is mislabelled on
> one of the screens.
>
> Jim Raehl
>
> Lincoln A. Baxter wrote:
> > On Wed, 2009-09-02 at 13:18 +1000, Doug Laidlaw wrote:
> >> GnuCash will import a comma-separated spreadsheet (.csv files.)
> >
> > Really?  Can you tell the list how to invoke it?  The best I could find
> > was some suggestions for converting a spreadsheet to QIF (or QFX)
> > format...
> >
> > Such an import would have to provide a way to define which account to
> > import into, which columns respresent descriptions, check numbers, and
> > debits and credits on that account (or whether do treat
> > positive/negative numbers as debit or credits (or vise versa), and
> > ideally, a way of identifying the account for the balancing
> > transactions... though, it could just default to one of Imbalance
> > accounts that are auto created.  It could also use the same dialog for
> > assignment of balancing transations that the other imports use.
> >
> > But I think I have just described something that does not exist.
> >
> > Lincoln
> >
> >>  You could tell
> >> Excel to save as .csv and import that.
> >>
> >> HTH,
> >>
> >> Doug.
> >>
> >> On Tue, 1 Sep 2009 03:29:29 pm gmail wrote:
> >>> Hi,
> >>>
> >>> I've just started learning GNUCash.  Is there some way to import data
> >>> from Excel files? _______________________________________________
> >>> gnucash-user mailing list
> >>> gnucash-user at gnucash.org
> >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >>> -----
> >>> Please remember to CC this list on all your replies.
> >>> You can do this by using Reply-To-List or Reply-All.
> >>
> >> _______________________________________________
> >> gnucash-user mailing list
> >> gnucash-user at gnucash.org
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> -----
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
> >
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.




More information about the gnucash-user mailing list