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

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