[GNC] Tip: Transaction Report to Spreadsheet - Quick & Easy - Yes?

[Adrien Monteleone]

Thanks Fran!

I had previously resorted to Account Report or Transaction Report with copy/paste, but I hadn’t noticed the Export > Active Register option. I wonder how new that is?

I see it could be quite useful as it includes data that is otherwise hidden from the Register tab. (transaction ID, Currency, Rate/Price, Reconcile Date) While most people might not have a use for them, I could see they might come in hand when trying to solve a problem —say with an import. I also like that you get a column both with and without currency symbols. (some spreadsheets don’t play nice with the symbols, so you have to remove them. This saves a step)

I don’t use Excel, but some years ago, I recall a few threads where there were quirks. It seemed OOo or LO (and I suppose Google Sheets) were better suited, or at least didn’t require extra hoops to get to the end result. I can’t remember what Excel was choking on though.

Regards,
Adrien

> On May 19, 2020 w21d140, at 11:55 AM, Fran_3 via gnucash-user <gnucash-user at gnucash.org> wrote:
> 
> To get a register, or part of a register out of GC and into  a spreadsheet you can...
> File > Export > etcThen import the csv file into the spreadsheetthen dink with it to delete or hide unwanted columns, etc...
> Or do it faster and with more control via...
> 
> Open the registerClick Reports Transaction ReportEdit Report Options
> And then just highlight the transactions with the mouse and paste them right into a Google Sheet !
> Much quicker (to me) and you have more control in that you can select the columns you want and more.
> I wonder if this works in Excel too?