Hacker News new | ask | show | jobs
by onethree 4205 days 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...

2 comments

I'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.

But you could get all those benefits by just testing your csv loads OK into excel.