Edit - Super User

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

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"
– Jack Deeth
Commented Apr 4 at 15:47
Sure, that will work. Or perhaps easier: open it in Wordpad or similar, and replace all commas by semicolons...
– Paul
Commented Apr 4 at 16:03
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
– Jack Deeth
Commented Apr 4 at 18:19

Add a comment |

Correct minor typos or mistakes
Clarify meaning without changing it
Add related resources or links
Always respect the author’s intent
Don’t use edits to reply to the author

create code fences with backticks ` or tildes ~
```
like so
```
add language identifier to highlight code
```python
def function(foo):
print(foo)
```
put returns between paragraphs
for linebreak add 2 spaces at end
_italic_ or **bold**
indent code by 4 spaces
backtick escapes `like _so_`
quote by placing > at start of line
to make links (use https whenever possible)
<https://example.com>
[example](https://example.com)
<a href="https://example.com">example</a>

formatting help »
answering help »