Hacker News Reader

I ran into a nasty bug(?) recently in the way Excel processes CSVs. I create a well formed CSV from a Java Web app which the user downloads. They open the CSV up in Excel and modify the data for an eventual upload. However, during the save process, Excel truncates trailing commas. Which causes my well formed CSV to be a poorly formed CSV during upload and parsing. Not fun.

View on HN

For such type of thing you should always have something at the last column, even return might be enough

A,B,,,,,,,," " C,D,,,,,,,," "

That's newline there between " and "

I guess Excel loads that internally through a convertor, trims the rightmost unused columns, and then saves it that way.

Never knew that. Once I cut a CSV for someone else, I never wanted to see it again. Now I know why.

Reply on news.ycombinator.com