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

[Eric Chapman]

Hi, Michael,

Some others responded also, so now I have successfully exported to HTML 
and opened the files in a spreadsheet. I didn't know that was possible. 
Now I do. All's well, and I'm thankful for your help!

Eric

On 12/5/23 16:16, Michael or Penny Novack wrote:
> 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