justinclift 2 days ago

No worries at all. I kind of wonder if using LibreOffice for the initial import -> Save to (say) Excel format would work better, than opening that in Excel?

ie might be easier for people who aren't comfortable changing the default settings in things

1
PeterStuer 2 days ago

It is a weird bug given that you explicitly select "Import from CSV file" In Excel, so no guessing should be needed.

And it is not an obscure edge case You find many people across different fora asking about this, and the suggedtions they get are impracticle workarounds (remove the LF before importing) or do not work (add an 'instruction' line to the file explicitly declaring a separator such as sep=;).

Routing through LibreOffice might work, but there could be a large overlap between those unwilling to open the advanced editor and those unwilling to install LibteOffice.

Google sheets could be another option to try, but only for those that do not mind their data leaving premise.