How can I identify the cause of an error during a tax spreadsheet upload?

You can review spreadsheet upload errors on the Manage Tax Regimes page.

Just go to the Monitor Upload and Download Processes tab and open the output file and the log file generated for your process ID. All you have to do is just correct the errors in the spreadsheet and upload it again.