How to convert timestamp to a Date/Time format in the exported CSV file?


I've exported a filtered Activity Log into a CSV file and when I open it I only see a timestamp for each Activity Log record. How can I get a date instead of a timestamp there? 


For example, your timestamps are located in column A and A1 is a column title "timestamp". Create a new column, name it "Date/Time"  and set values there by the formula: 


Then format the value to Date/Time. 

Was this article helpful?
1 out of 2 found this helpful



Please sign in to leave a comment.