Forum Discussion
CSV file date format
Hello! We have a problem with a csv file. We have a column which needs the formatting tt.mm.jjjj hh:mm Currently it is tt.mm.jj hh:mm (the year only has two digits instead of four). If we change it i...
Yes, CSV is actually text file. However, if open CSV in Excel, apply custom format to data, save file as CSV it shall save the data (as text) in the form of applied format. Another story is that if you open file again in Excel it could show you some data in your default locale format, but that's only visualization. You may check in Notepad that is the actual data.
So, depends on goals - to change the data or to show the data. If former it works. If latest it depends, when Excel format is most reliable.
See for example Formatting Dates for CSV Imports – Administration (echo360.com)