NoPublic, bureaucrat, administrator
4,913
edits
Changes
no edit summary
{{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.}}
{|
|- valign="top"
|
{| class="wikitable"
|-
| [[Image:Csv Excel correct data type.png|250px|center]]
| [[Image:Csv Excel changed to date.png|250px|center]]
| [[Image:Csv Excel changed to date2.png|250px|center]]
|- align="center"
| ''How it should be''
| ''Excel transforms to Date''
| ''Result if you change the column to Text''
|}
Below we describe a workaround for this '''Excel''' behaviour.
<ol>
<li>[[Export Search Result]].</li>
<li>Use function ''Text to columns'' on Data ribbon.</li>
</ol>
<div align="center">
'' Country The first panel''
</div>
<li>Click '''Next'''.</li>Change ''Delimiters'' to '''Comma'''[[Image:Csv wizard2.png|500px|center]]
<div align="center">
'' Country The second panel''
</div>
<li>Click Change ''Delimiters'' to '''NextComma'''.</li><li>Change Click ''Column data format'' to Next''Text'' and verify that the format is set.</li>[[Image:Csv wizard3.png|500px|center]]
<div align="center">
'' Country 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 as 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>
{{NavBox Technical Notes}}
[[Category:NAA]]
