Re: [GNC] How to export reports to spreadsheet format(s)?
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 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to export reports to spreadsheet format(s)?
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. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to export reports to spreadsheet format(s)?
OK, sounds like it's doable. Will try. Thank you. Eric On 12/5/23 10:38, Adrien Monteleone wrote: #1 - Run Report, Select-All, Copy, Open Spreadsheet app, Paste #2 - Run Report, Export as HTML, Open resulting file with Spreadsheet app. #3 - Run Report, Export, Use 'Insert from File' in Spreadsheet app. With the last two, you will likely be asked to confirm formatting ala importing a CSV file. Modern versions of spreadsheet apps are pretty good at recognizing HTML tables. Those two options also use your default styling of the spreadsheet whereas #1 will preserve the styles of the original report from GnuCash. Regards, Adrien On 12/5/23 7:57 AM, Eric Chapman wrote: How do I export data from reports to csv files or Excel/LibreOffice Calc files? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to export reports to spreadsheet format(s)?
OK, thank you! I will try it. On 12/5/23 10:41, Maf. King wrote: On Tuesday, 5 December 2023 15:11:26 GMT Eric Chapman wrote: When I try to print to file from GnuCash 4.14, I only see the three options in the screenshot attached: PDF, PostScript, and SVG. Hmmm… On 12/5/23 10:08, Eric Chapman wrote: I did find this, but it does not appear to have any solution: https://lists.gnucash.org/pipermail/gnucash-user/2023-March/106080.html Is it true that GnuCash only exports to HTML? Most spreadheet programs can read the HTML saved by GC. I know for a fact that LibreOffice is quite happy with it. Or, you can select all the text in a report and copy/paste into a blank spreadsheet. HTH, ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to export reports to spreadsheet format(s)?
On Tuesday, 5 December 2023 15:11:26 GMT Eric Chapman wrote: > When I try to print to file from GnuCash 4.14, I only see the three > options in the screenshot attached: PDF, PostScript, and SVG. Hmmm… > > On 12/5/23 10:08, Eric Chapman wrote: > > I did find this, but it does not appear to have any solution: > > https://lists.gnucash.org/pipermail/gnucash-user/2023-March/106080.html > > > > Is it true that GnuCash only exports to HTML? Most spreadheet programs can read the HTML saved by GC. I know for a fact that LibreOffice is quite happy with it. Or, you can select all the text in a report and copy/paste into a blank spreadsheet. HTH, https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to export reports to spreadsheet format(s)?
#1 - Run Report, Select-All, Copy, Open Spreadsheet app, Paste #2 - Run Report, Export as HTML, Open resulting file with Spreadsheet app. #3 - Run Report, Export, Use 'Insert from File' in Spreadsheet app. With the last two, you will likely be asked to confirm formatting ala importing a CSV file. Modern versions of spreadsheet apps are pretty good at recognizing HTML tables. Those two options also use your default styling of the spreadsheet whereas #1 will preserve the styles of the original report from GnuCash. Regards, Adrien On 12/5/23 7:57 AM, Eric Chapman wrote: How do I export data from reports to csv files or Excel/LibreOffice Calc files? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to export reports to spreadsheet format(s)?
When I try to print to file from GnuCash 4.14, I only see the three options in the screenshot attached: PDF, PostScript, and SVG. Hmmm… On 12/5/23 10:08, Eric Chapman wrote: I did find this, but it does not appear to have any solution: https://lists.gnucash.org/pipermail/gnucash-user/2023-March/106080.html Is it true that GnuCash only exports to HTML? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to export reports to spreadsheet format(s)?
I did find this, but it does not appear to have any solution: https://lists.gnucash.org/pipermail/gnucash-user/2023-March/106080.html Is it true that GnuCash only exports to HTML? On 12/5/23 08:57, Eric Chapman wrote: How do I export data from reports to csv files or Excel/LibreOffice Calc files? -- Eric Chapman GnuCash 4.14 (probably soon to be 5.4) on MacOS 14.1 Sonoma running on an Apple M3 Max computer. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
