Reports are HTML.
They open quite easily in spreadsheet apps.
You can then massage as needed to remove extraneous spacing columns and
then convert to CSV.
(you can also select-all and then paste non-formatted text into a
spreadsheet if you don't want to save first)
If you do the copy/paste method, most spreadsheets should offer you
options for importing the text so you can clean up a few formatting
issues. (though not all)
You could also export a report and script the stripping of formatting
spaces, converting it to CSV. (I'm pretty sure there is already an app
that can convert HTML tables to CSV, thus saving having to 're-make the
wheel')
There are also ways to get your data outside of the GnuCash GUI.
There is a CLI interface and Python bindings. I haven't used either, but
some here on the list have.
There is also a separate app called Piecash, which can extract data from GC.
Hope one of those will get you what you need.
Regards,
Adrien
On 6/5/22 5:19 PM, Fred Tydeman wrote:
Is there a way to export either the Accounts main screen or an Accounts
Summary report as either a plain text file or a CSV file?
The best I have found so far is Select via mouse the text on the multiple
screens,
then Ctrl-C to copy to clipboard, then Ctrl-V to paste into a file in an
editor.
Unfortunately, that process ends up wrapping lines (to perhaps 80
characters).
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
