NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
{{Note | The file format CSV has its limitations. As example is non-Latin characters are not supported. }}
{|
|- 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 to Text''
|}
{{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. A word around for this Excel behaviour is described '''[[Open CSV in Excel | here]]'''.}}
To Export data from the selected row(s) to a file: