An internal tool I'm responsible for maintaining (that coworkers at my company use) consumes CSVs, and a lot of the time they're made by less-technical employees who use Excel to create/edit them. Very often Excel causes unexpected bugs that baffle me when the tool can't parse it. One time it surprised me when all the cells looked right in Excel itself, but when I popped it into Emacs, there were ~15 extra commas at the end of every row. Don't know what world that would be expected behaviour in, but alright.
Extra commas mean extra cells. There are probably cells to the right of the data that are empty, but have formatting or something so that Excel thinks they are part of what needs to be saved.
Probably, but why would I want to keep formatted blank cells in my CSV data, when it doesn't even represent the style/formatting in any way? If there was any data I'd care about from those cells, it'd only maybe be the styling. But if it's not going to export the styling information, and the content is blank, then don't export those cells.
