Import CSV: bad alignment of dates

Last update on November 12, 2009 01:19 PM by jak58
Published by jak58

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
Best answers for « Import CSV: bad alignment of dates » in :
[Ingres] Importing/ Exporting data Show[Ingres] Importing/ Exporting data Making use of these commands copydb unloaddb Notes Ingres allows you to export data from an Ingres installation to another (it is a platform independent procedure). unloaddb copydb The main...
Import contacts from Excel to Outlook ShowImport contacts from Excel to Outlook Issue Solution Issue How to import a contact list from Excel to Outlook and having them in a single list of contact , and not as splited items? Solution By using the software Excel 2000 and...
Connect a database (MDB) to excel Show[VBA] Connecting a database (MDB) to excel Below is a tips of how to connect an Access database (MDB) in an application excel Add reference Microsoft DAO object librairy X.X In a general module (eg Module1) paste the code below...
Download OraLoader ShowOraLoader is a database application conceived for Oracle bases. The application allows to import text file data then to export them into other formats such as: TXT, CVS, HTML, XML. You can use this tool to transfer data from one table to another,...
Download DentiMax ShowDentiMax is an invoicing software for dental surgery. It includes many features to automate the management of medical documents and patient files. Since it is very flexible, it supports the import of external data from many medical applications...
Download Directory Mate ShowDirectory Mate is a software to import or export data into Windows Active Directory. Long scripts and complex programming to import or export your contact list can be avoided now. It lets you create quickly new users and modify information in your...
Data transmission - Cabling ShowCabling types Several physical data-transmission media are available to connect together the various devices on a network. One possibility is to use cables. There are many types of cables, but the most common are: Coaxial cable Double twisted...
Data transmission - The physical connection ShowWhat is a transmission channel? A transmission line is a connection between two machines. The term transmitter generally refers to the machine that sends the data while receiver refers to the one receiving the data. The machines can sometimes be...
Data transmission - Introduction ShowData representation The purpose of a network is to transmit information from one computer to another. To do this, you first have to decide how to encode the data to be sent, in other words its computer representation. This will differ according to...
They need your help