Format for importing CSV into project with Date/Time field?

English Forum Critical Bugs In Progress
, , ,
1

I am doing a CSV import into a project that has a Date custom field. No matter what format I try within the CSV, Asana won’t let me choose the desired Date field during the import step.

My custom field should be a Date format with both date and time, and I’ve tried the following based on various documentation I’ve found:

  • 1/16/2025 2:36 PM
  • 2025-01-16T19:36:00:000Z

Does Asana now even support an import of a date with a time? Looking at the API output, it uses format of:

2025-01-16T19:36:00:000Z

All the import dropdown selection says is “Values must be in date format”… but they are. Not very helpful.

Update: just tried it with Date only (no time), and it works. Lame. Is time not supported in the import, even though it’s clearly supported by both the UI and the API?

2

Did nobody have a ready answer to this reasonable question, now fifteen months old?

3

@Forum-team,

Can you escalate this?

This help page says:

  • Date fields: Enter the values using ISO timestamp. The ISO timestamp format (ISO 8601) is a standardized way to represent dates and times, typically appearing as YYYY-MM-DDTHH:MM:SSZ or similar, ensuring clarity and global consistency by including year, month, day, hour, minute, second, and often timezone information.

I have this csv file:

Task	Custom Date
Task 1	2026-08-19T15:30:00Z

I, and others, have run into this with CSV Import > Make changes:

image
image1942×950 66 KB

Despite what the help says, I think you can only import dates, not times.

Thanks,

Larry

4

Hi @Preston_Lathrop and @lpb, appreciate you circling back on this.

This concern has already been escalated to our product team for deeper review. In the meantime, the current behavior is that the CSV importer only supports date‑only fields, not date+time. That’s why imports succeed when the time is removed but fail when it’s included. I’ll share an update here as soon as I hear back from the team. Thank you for your patience. :folded_hands:

1 Like