4
2
I'd like to set Excel 2010 to open the import wizard each time I double click on a CSV file rather than have Excel open the file without the wizard. Previous versions of Excel did this but 2010 immediately opens the file. I deal with CSV files that use different delimeters (pipe, semicolon, etc) so when Excel opens the file without the wizard, I often have to click on a cell and manually open the import wizard. It would be more efficient to simply open the wizard each time.
OpenOffice does this but most of the time I need to export these to an Excel file so using OO isn't really an option. Is there a way to force Excel 2010 to open the wizard each time I open a CSV file? I've read some of the other guides here on SE but those still aim at opening the CSV directly in Excel without using the wizard which isn't what I need.
1
Possible duplicate of Easiest way to open CSV with commas in Excel
– Raystafarian – 2016-02-25T12:14:34.907I don't think it's a duplicate; that one is for eliminating the wizard from coming up. I want the wizard to come up every time. – Tensigh – 2016-02-25T12:46:28.903
I think it's a duplicate because it discusses how you have to use the wizard from the data tab for csv files in 2010, rather than opening them directly. Or change your regional settings. – Raystafarian – 2016-02-25T12:48:22.280
I edited my question so it's unique. The others are about changing regional settings so Excel opens the CSV properly. Mine is about forcing Excel to open the wizard each time, not bypassing it but with correct results. – Tensigh – 2016-02-25T21:42:16.407