You can also get the correct data without reopening the file by selecting the column which contains the data(which is the first column when opening a csv from windows explorer) and going to the "Data" tab and press the "text to columns" button which opens the same wizard as shown in the video
Prior to my MS Office update, excel would always pop the "text import wizard" tab first when I open a csv file before showing the data. Now the wizard won't appear anymore when I open the same csv file, and the data are all compiled. I have to manually select the column every time now. Is there a way to reactivate the wizard or an option to make it appear again when opening csv files? Thanks mate
You can also get the correct data without reopening the file by selecting the column which contains the data(which is the first column when opening a csv from windows explorer) and going to the "Data" tab and press the "text to columns" button which opens the same wizard as shown in the video
That is an awesome tip that saves some time! Thank you for adding that.
Prior to my MS Office update, excel would always pop the "text import wizard" tab first when I open a csv file before showing the data. Now the wizard won't appear anymore when I open the same csv file, and the data are all compiled. I have to manually select the column every time now.
Is there a way to reactivate the wizard or an option to make it appear again when opening csv files? Thanks mate
Thank you so much!