I came across this question and the and answers and they were helpful however it didn't give me everything I needed. I was needing to be able to manage and work with CSV Data without destroying the format as Excel is so famously known for. I find the the NEW Import Wizards are not conducive to a basic CSV Import - at least I didn't find it useful due to my not having the ability of importing the RAW Data.
Basically I'm using Excel Office 365 version 16 at the time of writing. I had to turn on the LEGACY CSV/Text Import Wizard... I hope Microsoft NEVER gets rid of this wizard without first providing an easier method to import raw data.
Using the below method I have no issues removing rows or columns after first making sure I have imported ALL columns as TEXT... when you save your changes be sure to save it as a CSV file.
Turn On Legacy Wizard:
In Excel navigate to File --> Options --> Data --> Check the box in the 'Show legacy data import wizards' section 'From Text (Legacy)'
Now to import your CSV or RAW Text File
Navigate to the Data Tab and within the 'Get & Transform Data' section choose Get Data --> Legacy Wizards --> From Text (Legacy).
Gif Showing how to turn on Legacy Import:
Gif Showing how to import CSV Data:
Hopefully this will help somebody else.