Importing data CSV or Other method

Importing data CSV or Other method

Hello,

I want to import data, to my contacts module (to trigger a workflow on a field update). I have a csv available which has a contact email and a list of dates in chronological order. One email could have multiple dates. When uploaded, the dates will update a date field against the contact and trigger a workflow.


Email
Date
a@a.com
01/03/203
b@b.com
03/03/203
a@a.com
05/03/2023



Is there a way in Zoho to upload this CSV and have it only use the last date of an email address? I am also exploring a formula in excel to do this. But I thought I would ask here too.

Thank you
Alex