You can use a batch list that creates a CVS file you can import into Excel. Unfortunately, it only exports in/out points, not durations. You can figure out durations using a formula to make calculations on timecodes in excel, which is time-consuming.
Resolve (even the free version) has a metadata export function that is really convenient, exports in/out timecodes, durations and other infos as well.
Its seems that export of batch list is no longer an option in PR CC 2018. I used this function all the time to create spreadsheet logs of my clips. Not sure why it was taken out (unless it's hidden deep somewhere else).
Just an FYI.
One option, in response to the first question, is you could drop all the clips one after the other in a sequence and then export an EDL. Excel can open EDL files and it has TC in/out and durations. The formatting isn't great but it's all there.