How do I open a CSV file in Microsoft Excel without changing the column formatting?

To open a comma-delimited (CSV) file properly, use Excel’s Data Import from Text feature to open the import wizard and set all columns as text.

If you click the file and allow Excel to open it automatically, the columns might be reformatted by Excel.