Ya, those are basically worthless without giving the credentials.
One option is to build out your spreadsheet where the "download CSV" option on your various sites will drop the data straight in )IE add a tab for each CC / bank / whatever, and match their cell positioning, then it is just a matter of downloading the data.
A more mustachian response would be to ask why you have so many transactions that its hard to keep up with. How much crap are buying on the daily?.... Hmmmmm? (kidding, mostly)
I believe YNAB is that same way, though I may be mistaken.