5 ms·
its right there in the article: Dates, times, and durations; Percentages; Number formatting the number of times i've opened a csv to find that excel has tried
by onethree 12y ago
its right there in the article: Dates, times, and durations; Percentages; Number formatting
the number of times i've opened a csv to find that excel has tried to determine the dates, and decided that the year thats being referred to is 1914 instead of 2014...
- michaelt 12y agoBut you could get all those benefits by just testing your csv loads OK into excel.
- volker48 12y agoI've never had an issue like you describe with dates before. I've always output them in the csv in Y-m-d format and that has worked as expected. I should have been more precise and said if your data isn't using the set of features described in the article there isn't a big difference. Not all data has dates, time durations, percentages, and number formatting.