import from excel

Geert Janssens janssens-geert at telenet.be
Tue Nov 8 03:32:15 EST 2011


On dinsdag 8 november 2011, George OLson wrote:
> Hi everyone,
> 
> I am wondering if there is a way to import data from Excel. I get a
> report from my office every month with about 50 line items of expenses,
> and I don't want to have to go into GnuCash and manually re-type each
> one when I enter the data in.
> 
> Is there a way to re-arrange my spreadsheet in excel that would make it
> easy to import, and then use one of the import wizards to just bring the
> data directly into gnucash? The items on my spreadsheet are very simple
> - they are just date - description - category - cost.
> 
You could try to save your excel sheet as a CSV file (comma separated values) 
and then use the CSV importer in GnuCash.

Geert


More information about the gnucash-user mailing list