4 ms·
>Even then, a scientist might fix their data but export it as a CSV file without saving the formatting. Is this supposed to be a joke? Since when does excel su
by imtringued 5y ago
>Even then, a scientist might fix their data but export it as a CSV file without saving the formatting.
Is this supposed to be a joke? Since when does excel support CSV files? Yes you can import and export CSV files but that is just there to check a box. That feature doesn't actually work. Just import and export .xlsx files in your applications directly.
CSV is such a bad format because it's not even a standard, there is RFC4180 but most people have never heard of it. CSV is complicated enough that anyone who thinks they can implement it will get it wrong on their first attempt but simple enough that people believe they can implement it on their first attempt.
- rini17 5y agoOpening CSVs in Excel almost never worked for me. Good thing there's LibreOffice Calc with spiffy import dialog with all the csv options/variants where you can preview the result.
- joenathanone 5y agoExcel has exactly the same functionality.
- rini17 5y agoGood, since when? Last used it 10ish years ago.
- joenathanone 5y agoHere is the feature in Excel 2007 https://youtu.be/ML0VDMpWllM https://youtu.be/ML0VDMpWllM around 2:45, could have also been there in earlier versions too.
- prepend 5y agoI think the import wizard was added in office 2000.
- dwringer 5y agoIt was there, the problem is that by default if you open files the way most people do (double-clicking or dragging) then Excel decides you must not want to be bothered by the options so it fills them in for you. "Helpfully" not even using the most basic inference to assign types in a way that doesn't destroy the data.
- humanistbot 5y agoI love how you gave advice in your parent post as if you knew what Excel's current features are, then admitted you haven't used it in 10 years.
- rini17 5y agoI meant to describe what I do and why, sorry if I offended you by unsolicited wrong advice. And as others say, nothing changed during that time - the import function is/was always there but it's still hidden somewhere.
- joenathanone 5y ago>but it's still hidden somewhere. It's the second button on the data tab, you are still spreading misinformation.
- max599 5y agoat least 20 years, probably more.
- jasode 5y ago>Since when does excel support CSV files? Yes you can import and export CSV files but that is just there to check a box. That feature doesn't actually work. Just import and export .xlsx files in your applications directly. You're being hyperbolic and your .xlsx advice doesn't apply to other systems we don't control that only offer .csv files. Examples... my credit card website and Ebay only offer csv downloads of data. I use MS Excel to import those csv files all the time and it works well enough. Yes, I'm aware of potential data-conversion flaws with importing csv files. (My previous comment: https://news.ycombinator.com/item?id=25017116 https://news.ycombinator.com/item?id=25017116 ) All those caveats with csv are irrelevant when the system that has the data people want only offers csv. Using Excel's feature to import csv -- and being aware of the format dangers -- is more practical than manually retyping all the data from scratch.