[GNC] How to export reports to spreadsheet format(s)?

Michael or Penny Novack stepbystepfarm at comcast.net
Tue Dec 5 16:16:39 EST 2023


On 12/5/2023 8:57 AM, Eric Chapman wrote:
> How do I export data from reports to csv files or Excel/LibreOffice 
> Calc files?
>
a) To use the last (as an example) LibreOffice Calc does NOT require the 
files it opens to be "LibreOffice Calc files" << it of course does 
prefer the open document version, .ods. >>  The same is true of Excel, 
etc. You are confusing the actual data format of a file with the file 
extension (of present).

b) Have you tried? Have you tried exporting a report from gnucash? It 
was exported as .html, yes? And so if you click on that object, it will 
use a browser to open it (because you surely have the extension .html 
associated to a browser. BUT --- have you tired this? Started the 
application LibreOffice and from there the application calc. That will 
assume you are doing a new spreadsheet, but see that "open" in the upper 
left. That lets you choose what file you want calc to open. Did you find 
it was unable to open the .html file? You can then do a "save as" 
choosing the type .ods, .xlsx, etc.

Michael

-- 
There is no possibility of social justice on a dead planet except the equality of the grave.



More information about the gnucash-user mailing list