Importing Excel CSV with Dates

2.75K viewsDataLink


I tried to import an Excel csv file with dates as the first column (planning to use it as my category). However, the dates are converted to ‘Thur Sep 30 00:00:00 PDT 2010’ instead of ‘9/30/10’ which I prefer. Is there any way of going around this instead of typing it in manually? I’ve attached both files for reference.



Hi – try this:

– Instead of using 2D import, use Multi-d
– On multi-d, call your first column a category
– On the next screen you will be able to format ‘Column 1’ to the desired date format.