3 ms·
One small tip if you receive a CSV with a non-default separator (like ;): * Open it in a text exitor * Add "sep=;" on the first line (without the quotes) * N
by leokennis 6y ago
One small tip if you receive a CSV with a non-default separator (like ;):
* Open it in a text exitor
* Add "sep=;" on the first line (without the quotes)
* Now at least Excel will open it as intended
- BlueTemplar 6y agoIIRC Excel will ask for the separator anyway when you open the file?
- hnick 6y agoIt does not, at least not anymore.
- brewmarche 6y agoIt does not and actually assumes locale-dependent separators (usually semicolons if your locale uses a comma as a decimal separator and comma otherwise). If you want to specify separators you have to go via Text Import.
- lucb1e 6y agoCalc just asks upon opening, no hidden tricks needed. Whenever I see people struggling with Excel and CSV, also when pasting CSV data into Excel, I can't stop wondering why people still bother with the Office suite. It has zero advantages aside from the cost of change (time spent on re-learning where things are), yet we teach it to kids in school and send them reminders that Microsoft benevolently gives them very steep discounts to reduce piracy (never mentioning that you could also just use this other free thing...), never mind the legislation saying governments and schools should use free software unless there is some strong and documented reason to divert from the rule.