Opening .CSV Files with Excel - Quick Tip on Delimited Text Files

[@nubbit4782]

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

[@FlexibleAssembly]

That is an awesome tip that saves some time! Thank you for adding that.

[@ensayogymequipment6458]

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

[@Alphacentaurizero]

Thank you so much!