Why a Confluence table breaks when pasted into Excel

Random merged cells, lost leading zeros, long IDs in scientific notation and ranges turned into dates. We pasted a test table into Excel and traced each one.