> 7. Save as CSV, then reopen the CSV in Excel. Lots of magical things happen there. Indeed. My favorite one is accounting spreadsheets tending to export acco

> 7. Save as CSV, then reopen the CSV in Excel. Lots of magical things happen there. Indeed. My favorite one is accounting spreadsheets tending to export accounting numbers as text columns with trailing whitespace. That was off a recent version of excel for the Mac. I understand it's a cute convention for currency formatting but it makes data transformation in a database very, very annoying.