0
Thanks

A few words of thanks would be greatly appreciated.

Excel - Import CSV: bad alignment of dates


When opening a CSV file with Excel containing a column of dates and they are not well aligned.
It may be that your problem is more serious than you think.

  • Take one example in the following CSV file:
02/07/2005,x1  
04/07/2005,x2  
17/07/2005,x3  
01/07/2005,x4 
  • Now open it with Excel and look at the result:

  • Dates are well aligned,except for one that is left. But what did it really happen?
  • Indeed, the problem goes further: the dates have been changed. 02/07/2005 which was turned into 07/02/2005, except for the date line to the left.
  • In fact, when you export dates under CSV format, Excel expects you to provide it under following format: mm/dd/yyyy.

So if you want to have dates aligned and consistent especially, think about your layout dates in your CSV file.
The file should be:

07/02/2005, x1 
07/04/2005, x2  
07/17/2005, x3  
07/01/2005, x4
0
Thanks

A few words of thanks would be greatly appreciated.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.
This document, titled « Excel - Import CSV: bad alignment of dates », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).