Copy from one csv to excel

When I copy date from csv to excel file the date format changes.

CSV date: 9/12/2019
excel date: 12/9/2019

I want the same date in excel as well. How can I do that?


Create one Excel template file with predefined column type and required format and then copy data into it.

1 Like

@lakshman I have column type as “Date” in excel file. Still it displays as 12/9/2019.


  • read range from csv file and output to datatable.
  • append range from datatable to excel file.


In Excel, we can specify date format also which way we want. Change the format according to yours and then try once.

i have changed the format in the excel file. but still it does not work. the source file is :slight_smile:

the destination file is