[GNC] Manipulating data extracted from gnucash to Excel

[sunfish62 at yahoo.com]

And if your currency is using character strings ("USD", "CHF", etc.), you can customize the currency designator so that Excel can process them. 

⁣David T. ​

On May 19, 2024, 8:50 PM, at 8:50 PM, "Stan Brown (using GC 4.14)" <stan+gc at fastmail.fm> wrote:
>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
>_______________________________________________
>gnucash-user mailing list
>gnucash-user at 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.