Importing Data from Excel

Lincoln A. Baxter lab at lincolnbaxter.com
Sun Sep 6 23:58:56 EDT 2009


Hmmmm... Something to look forward to, in the 2.4 series... (at least
for those of us who prefer to stay on stable verions of GC.  ;-)

Thanks.

Lincoln

On Sun, 2009-09-06 at 20:57 -0600, 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.
> >>>
> >>> !DSPAM:4a9d24a9109471538515978!
> >>>       
> >> _______________________________________________
> >> 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