Oh this was fun. Excel has issues with numerical figures greater than 13 digits, and can't distinguish from a serial number in a csv or an integer. Importing

Oh this was fun. Excel has issues with numerical figures greater than 13 digits, and can't distinguish from a serial number in a csv or an integer. Importing a small (30k rows of so) set of of tax information thus became hell. Worst part is that I didn't find it till halfway through the migration. I love excel on average, but that was just a painful fight.