How do I disable adjusting column positions when opening CSV files?

Go to Tools | Customize… and open the CSV Options page. Uncheck Adjust Separator Positions Automatically.

Customize CSV Options