[GNC] Manipulating data extracted from gnucash to Excel

[Stan Brown (using GC 4.14)]

On 2024-05-19 09:39, David Long wrote:
> When I copy data from Gnucash to Excel it arrives on text format along with
> the currency denomination, so I cannot then manipulate it in Excel.
> Is there anyway I can export data to Excel in data format?.
> Thanks
> David

Hi, David!

Which "data" are you copying? Reports? Some stuff you highlighted in an
account register and then copy/pasted? Other?

If it's a report, export it as HTML from GnuCash, then open it in Excel.
Yes, Excel will let you select an .htm or .html file in the File » Open
dialog; you don't even have to fiddle with the file type box in that
dialog because Excel considers .htm and .html as "Excel files".

If it's an account register (or search results), in GC click File »
Export and export in CSV format. (In Windows, remember to put ".csv" at
the end of the filename you specify in the dialog; GC apparently doesn't
do this automatically.) Excel will open CSV files, too; the easiest way
is to double-click the file..

If it's something else, please give us more details of what you're
trying to do. (Also please say which version number of GC, and which
operating system and version -- it's always a good idea to mention those
when asking for help.)

I'm puzzled by your remark about the currency designation. Excel doesn't
have a problem with my pasting an amount with a leading dollar sign ($).
And if I recall correctly, there's also no problem with exporting a
report that contains currency symbols -- again, the dollar sign is the
only one I've tried. Maybe that's different in other currencies? Please
give us more information about what you're doing and what error message
you get.


Stan Brown
Tehachapi, CA, USA
https://BrownMath.com