Exporting and using Finder Metadata

Question

Exporting and using Finder Metadata

I have an archive of video files that I have been tasked with archiving. Predominately in MP4 format but not exclusively. some have been divided into folders, but at least half have been dumped in a catch all "no idea what this is" folder.

It would be beneficial to export the meta data from finder into a CSV file to be able to sort, tag and review the content.

I want to export the following: Date created, date modified, size and Date last opened data for each individual file.

Is this possible and how can I best achieve this please?

Many thanks!!

Posted on Dec 22, 2025 4:07 AM

Reply

Answer 1

Niel

Community+ 2025

Level 10

741,377 points

Dec 22, 2025 6:44 AM in response to After the Mouse

Select that folder in the Finder, press the Command and J keys or choose Show View Options from the View menu, set it to display those columns, take a screenshot of the window, open it through Quick Look, copy the text. open the Script Editor in the Utilities folder, and run:

set output_string to ""

repeat with this_paragraph from 1 to (count paragraphs of (the clipboard))

if this_paragraph mod 5 is 0 then

set output_string to output_string & paragraph this_paragraph of (the clipboard) & return

else

set output_string to output_string & paragraph this_paragraph of (the clipboard) & ","

end if

end repeat

(262310)

Reply