Importing Data from Excel

[James Raehl]

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

-- 
--------------------------------
Jim Raehl
jim at raehl.us
Choose the Opera browser (http://www.better-browser.com/).  Tabs, sessions, notes, Email, newsfeeds, RSS, chat, all instantly available at a click, keypress, or mouse gesture.