Yeah excel silently mangling csv files has always infuriated me
Just gave this program a try and it lets me save changes without removing any of the double quotes, yay!
Just gave this program a try and it lets me save changes without removing any of the double quotes, yay!
The crazy part is that it wouldn't be all that hard to handle it properly. Excel could examine each column and apply a uniform transform on each column instead of applying transforms on a cell by cell basis. They could even put in real effort and let the user choose the format for each column as part of the import process. You know, like being able to specify "text" for columns like SSNs or Credit cards that you aren't going to do math on anyway.