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