Open CSV in Excel

When you open the CSV file in Excel, Excel will automatically interpret data like 1-10 as 10-Jan. Therefore check carefully the result in Excel before sharing the export result with others. This page describes a word around for this Excel behaviour.

Export Open a new Excel file Open the .CSV file with a text editor e.g. Notepad++ Copy Select cell A1

Method 1 Click on Paste button Select Use Text Import Wizard"

Method 2 Paste into Excel Select column A Use function Text to columns on Data ribbon.

Same steps

The wizard starts Click Next Change Delimiters to Comma Click Next Change Column data format to Text and verify that the format is set Click Finish Save as xlsx Close and open the file in order to verify that the data still has the correct format