Skip to main content
4 events
when toggle format what by license comment
Apr 4 at 18:19 comment added Jack Deeth ha, yes, except that would replace the escaped commas within fields that need to be retained e.g. "oh, no"! In the absence of a solution (preventing Excel from silently, automatically and inconsistently mutilating the data it loads), I think the better workaround is to open the CSV in LibreOffice and then save as .XLSX
Apr 4 at 16:03 comment added Paul Sure, that will work. Or perhaps easier: open it in Wordpad or similar, and replace all commas by semicolons...
Apr 4 at 15:47 comment added Jack Deeth Thanks, I knew the "From text/CSV" process (which overcomplicates things for the user as it's not opening the .csv, it's treating it as a dynamic data source) - I think the simpler workaround is "install LibreOffice Calc, open the CSV there, it will explicitly ask for separator and delimiter characters instead of making numerous opaque assumptions, then save as .XLSX"
Apr 4 at 14:11 history answered Paul CC BY-SA 4.0