Show "Data" > "From-Text"-Wizard by default when double-clicking *.csv files...
When double-clicking CSV-files Excel automatically tries to guess the column formats and assumes the default field seperator.
But this often wrong column-types are guessed and it fails for *.csv-files with unusual field seperators.
It would be better if double-clicking a .csv file would open an import-wizard (like the existing one from "Data" > "From Text").
- The types for the columns should default to a text-type.
- It should not try to guess column-types automatically, but one might let excel guess manually via a button "Guess column types" in the wizard
- The most probable field seperator should be pre-selected
- It should remember the settings used when opening the same file again.
*counting the most common field-seperators (semicolon, comma, tab, pipe-character) in the first line works in most cases just fine ;D
Germán Vicencio L. commented
I support this idea.
I often get CSVs from the softwares I use and some of these use comma for decimal separator (eg. 0,06) and others use dots (eg. 0.06).
Excel will always use my system default so half the time I need to do the long run:
1. Open the CSV in notepad
2. Ctrl+A, Ctrl+C
3. Paste in Excel (cell A1)
4. Select first column
5. Text to data wizard
Steps 1, 2, 3 and 4 are too slow.
If Excel always prompted with the Text to data wizard I'd lose less time in total
Colin Scroggins commented
Could not agree more with everything in this request from the recommended opening behavior to defaulting text file formatting to text unless the user selects otherwise!
Due to all the special steps required for Excel to not mess up commonly used CSV files, I have to recommend Libre Office to customers wanting to make basic edits, over Excel. These defaults would change that.