Skip to main content

Modify the Vainu CSV file to be compatible with Excel

How to prevent decimals from converting to dates when opening a .csv file in Excel.

Updated over 7 months ago

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.

Screenshot 2022-09-02 at 14.43.16

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

Screenshot 2022-09-02 at 14.44.12

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

Screenshot 2022-09-02 at 14.44.23

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

Screenshot 2022-09-02 at 14.44.33

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

Did this answer your question?