Step 2 – Avoid unwanted – because incorrect – ‘corrections’ by ExcelĮxcel ‘corrects’ all values that resemble a date or a number.

Now all values are enclosed in one pair of double quotes, for example “12-10-2020”. Click the drop down box Save as: and select All files (*. Users of Windows 7 or older Windows versions: select UTF-8ĥ. * Tip: After each step, save the csv file, make a copy of it and do the next step in that copy!īefore you open the CSV file in Excel, you must first ensure that special characters (such as currency symbols or diacritics such as: æ, å, ç) are imported correctly.Ī. When such an export file is opened directly in Excel, this forces all values to still be displayed as text. When we generate exports of data, we enclose each value with a setof 3 double quotes, (for example “””2020.12345″””). We have a work-around for this to be able to edit these files in Excel. Therefore, never save a CSV file if you accidentally opened it in Excel. This causes some data to become corrupt and the entire file to become unusable. Unfortunately, if you open them directly in Excel by double clicking on them, CSV files will not be imported properly. CSV files are intended to exchange data between different platforms.

Csvto excel