8

I have a data capture computer that uses Windows. In one directory I have many files captured during an experiment at various times. There are several hundred. The windows File Explorer enables you to see the creation date and time of each file. I need this information. However, when I copy the files to another computer, for data analysis, the creation dates are lost. Can this be avoided?

What I would like to do is make a list of file names and creation dates in a spreadsheet or similar. I could then use this spreadsheet in my data analysis computer to recover the creation dates.

It seems you can't copy and paste the creation date. You can copy the file names (right click selection and use "copy as path") but not further information.

Is it possible to copy both the file name and the creation date? In particular is this possible without buying and installing special software?

Donald Duck is with Ukraine
  • 2,629
Hugh
  • 181

2 Answers2

18

Use Powershell to export the file list and their creation times to a csv file, then you can import the file to Excel.

Get-ChildItem -Path "*.*" | Select Name, CreationTime | Export-Csv myfiles.csv
Reddy Lutonadio
  • 20,570
0

Here's the non-PowerShell answer - you can get the creation date using the dir command in Command Prompt.

dir /tc >myfiles.txt

It's fixed-width rather than comma-delimited, but you can import it into your preferred spreadsheet application just the same.

benshepherd
  • 1,825