the most solid way to handle it is to use data import from text file (handles csv) so you can configure the columns while looking at them

Which recent excel versions you can bring that data table directly into power query as well, which is useful if youve got multiple csv you are trying to look at that are related