After much frustration trying to figure out where the bug might be in a CSV file I was uploading, I decided to do a test and upload it to Google Docs Spreadsheet, clean it up there and then export it as a new CSV. Much to my surprise (and delight!), now the CSV imports correctly. Have no idea what Google Docs is doing differently than Excel, but it works!