Difference between revisions of "Open CSV in Excel"
From IMSMA Wiki
(Created page with "{{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...") |
(No difference)
|
Revision as of 13:06, 5 April 2015
 |
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
