Timeline for Excel removes delimiters from first field of "foreign" CSVs
Current License: CC BY-SA 4.0
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 |