It's sad that on the Windows side, Excel has somehow become the defacto editor of CSV files, even though it does a sub par job at it. I had the same experience as you as I was merging two speadsheets of contacts and importing them into Google.
The problem you are having is since CSV files contain no formatting metadata, Excel loads the text file with all default formats. If it detects date on the load, guess what? If it detects leading zeros, guess what??
I gave up with Excel. And you should too!
Access is a far better tool. For one, Access, by defaults, imports all data into as text. It doesn't do any gimmick formatting unless you tell it to. Two, it actually formats CSVs correctly by allowing you to surround all fields with quotation marks. It all leave untouched leading spaces. Spread the word.
Saves lives!! Spread the word!! Don't use Excel for CSVs!!! Use Access!!
Relevant: http://www.eusprig.org/stories.htm (My favorite horror story is #39)
– pavium – 2011-07-01T14:28:28.1702Again, PLEASE PLEASE don't use Excel for CSVs!!!! – surfasb – 2011-07-03T05:52:59.460