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?

8
  • You could write a program that reads the dates and outputs them to a .csv file which you can open with Excel. Sep 25 at 16:25
  • 1
    Does this answer your question? How to preserve file attributes when one copies files in Windows? Sep 25 at 16:25
  • 1
    oh, I thought the accepted robocopy answers will preserve the attributes Sep 25 at 16:35
  • 2
    Use the command dir /t:c > C:/yer_fldr/files.txtand you can restrict dir to specify a file type, exclude folders, check subfolders, etc. See dir /? for info. See also cyberithub.com/… to select columns. Sep 25 at 16:41
  • 1
    Not the OP's question, but this is a perfect example of a general phenomenon. Is there a name for it? There's some textual information on the screen — in this case, the column of file modification dates/times — but it is "for your eyes only", you cannot select it with the mouse, or copy it, or paste it elsewhere. It's extremely frustrating. Sep 26 at 21:00

2 Answers 2

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
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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.