data export with Excel 2003

[Jannick Asmus]

Hi,

I am new to this list. I hope the following can be a valuable 
contribution to some of you.

I have attached an Excel2003 file for exporting data out of GC to Excel. 
It works pretty easily - even for non-advanced users. I checked it for 
Excel2003 having some new XML features now and I suspect it is 
compatible with Excel2007 upwards. I did not check whether 
OpenOffice-Calc provides such XML-features.

Once the data are exported from GC to Excel, they can be processed for 
other purposes.

How to export data out of GC to Excel:
- save GC-file in the uncompressed mode
- open GC-export_en.xls (with Excel2003 upwards)
- Excel: Data > XML > Import > choose GC-file (I just guessed the 
translation from German where it is "Daten > XML > Importieren > GX-file 
auswählen"

... done: The sheets with the chart of accounts, transactions, clients, 
tax, billing terms are filled !!! :-) Other categories can be added if 
needed.

It is ok with me if the xls-file is used within the project or amended 
or whatever. As additional features I could think of some macros for a 
simple handling and setting formats for figures (still in text format as 
"1600/100" instead of 16).

Best wishes,
J.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: GC-export_en.xls
Type: application/vnd.ms-excel
Size: 50176 bytes
Desc: not available
Url : http://lists.gnucash.org/pipermail/gnucash-devel/attachments/20080131/673d4419/attachment-0001.xls