When you export CSV the Date Columns have Time Attached any way to remove the Time.

[Ashish Dobriyal]

When you export Trello Board to CSV when viewing it Dates (Start, Due, etc) look something like:

2024-04-16T14:28:00.000Z

Is there anyway to export it without the time component so I would just get 2024-04-16 or I will need to to do it on Excel? If it's on Excel what's the best method to split the data.

Thanks

[Lam · Accepted solution]

Hi @Ashish Dobriyal - We don't currently have a way to modify the date format, however you can try formatting it automatically in Excel as you've mentioned. Here's some information from an article I found with a similar request: https://superuser.com/questions/1455511/how-to-convert-utc-to-typical-date-format-in-excel

[Ashish Dobriyal]

That's what I ended up doing, created a macro for it on excel. Thanks