Ask Ubuntu is a question and answer site for Ubuntu users and developers. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have numerous motion detector photos (JPGs) I copy to a DVD every day. I would like to copy the file name, original creation date and time of each of these photos and then extract this information to a spreadsheet to do analysis.

Any help appreciated. Am a new user to Ubuntu 12.04. Thanks.

share|improve this question

Exiftool (libimage-exiftool-perl Install libimage-exiftool-perl)

With this powerfull comand line tool we can manipulate and extract EXIF information of a high variety of files (see here fo all options).

To extract filename and date of all images in a directory in CSV format we may issue

exiftool -csv -r -filename -dateTimeOriginal /full/path/to/directory > output.csv


exiftool -T -r -filename -dateTimeOriginal /full/path/to/directory > output.txt

for text format. Of course we can also browse for all other EXIF tags available.

Install via the software center

share|improve this answer

First go to the directory where all your files are stored and then use this command at the terminal:

ls -lrt | awk '{print $9","$6","$7","$8}' > myfile.csv

It will create your excel file with file name myfile.csv and the order will be fileName createdMonth dayofMonth time.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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