Changes

{{Warning | 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 |- valign="top"|{| class="wikitable"|-| [[Image:Csv Excel filecorrect data type.png|250px|center]]Open the | [[Image:Csv Excel changed to date.CSV file with a text editor epng|250px|center]]| [[Image:Csv Excel changed to date2.g. Notepad++png|250px|center]]|- align="center"| ''How it should be''| ''Excel transforms to Date''Copy| ''Result if you change the column to Text''Select cell A1|}

Method 1Below we describe a workaround for this '''Excel''' behaviour.Click on Paste button<ol><li>[[Export Search Result]].</li><li>Open a new Excel file.</li><li>Open the CSV file with a text editor e.g. Notepad++.</li>[[Image:Csv copy text.png|500px|center]]<div align="center">Select ''Use Text Import Wizard"Copy '''all''' text''</div><li>Copy all rows with Ctrl+A.</li><li>Switch back to Excel and click in cell A1.</li>

Method 2<li>Open the Text import wizard by one of following methods: [[Image:Csv paste method.png|175px|center]]<div align="center">'' Paste method''</div>: '''Paste method'''<ol type="1"><li>Click on lower part of the Paste button.</li><li>Select ''Use Text Import Wizard'' in the drop-down menu.</li></ol>: '''Text to Columns method'''<ol type="1"><li>Paste into Excelwith Ctrl+V.</li><li>Select column A.</li>[[Image:Csv text to columns method.png|500px|center]]<div align="center">'' Text to Columns method''</div><li>Use function ''Text to columns'' on Data ribbon.</li></ol><li>The wizard starts.</li>[[Image:Csv wizard1.png|500px|center]]<div align="center">'' The first panel''</div><li>Click '''Next'''.</li>[[Image:Csv wizard2.png|500px|center]]<div align="center">'' The second panel''</div><li>Change ''Delimiters'' to '''Comma'''.</li><li>Click '''Next'''.</li>[[Image:Csv wizard3.png|500px|center]]<div align="center">'' The third panel''</div><li>Change ''Column data format'' to '''Text''' and verify that the format is set to '''Text''' for the columns that Excel otherwise will change to the wrong data type or data format.</li><li>Click '''Finish'''.</li>[[Image:Csv Excel correct data type.png|250px|center]]<li>Save the file in xlsx.</li><li>Close the Excel file and open the file again before you share it in order to verify that the data still has the correct format.</li></ol>