The first method you can click on Batch Update located in the bottom of the page and then Copy to Clipboard
For the API method, you can refer to this discussion API using excel
However, the more I think about it, the less it looks like a trivial task because you will only get the UUIDs in place of customers, items, accounts, tax codes, etc. You will need to do the same to each of the tabs and then use that to lookup the name from the UUID.
I have thought about GL report, but you cannot use customer or transactions as parameters, at least for now. The same thing applies to report transformations.
Maybe you can do something with custom reports.
Anyway, you will either have to take the time to setup an excel power query or use simple copy paste from the browser.
I would suggest adding more parameters and filters for report transformations because that would be the optimal solution.