Importing Data from Excel

[Lincoln A. Baxter]

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.
>