With the earlier versions of Quicken, if you generate a report and use its
Copy function, you can then paste into Excel (with only minor hiccups like
filling in a few cells which ought to be blank [in total & balance lines, in
my experience] with duplicates of what are in other cells). I would guess a
similar system might apply in later versions of Quicken, so you'll probably
just need to define a report format which suits your requirements.
It's worth looking at the support for your version of Quicken. [Start from
https://quicken.custhelp.com/cgi-bin/quicken.cfg/php/enduser/cci/launch.php]
It seems to recommend using Export Data, and Paste to Clipboard.