Import a .csv list directly to Excel by using the Import .csv -file feature. Following these steps, you can prevent Excel's unwanted automatic data conversion.
​
1. Open an empty spreadsheet, and click Import -> From CSV file.

2. Select "Delimiter". If the company names include Scandinavian letters(åäö, etc.) change the File Origin to Windows(ANSI).

3. Change Delimiter to Semicolon - This separates the text into individual columns

4. The most important thing when trying to prevent the decimal conversion to dates. Open Advanced →Decimal separator and change comma(,) to dot(.).

Now save and click Finish. The information should now be visually corrected.