Skip to main content
Participant
December 14, 2023
Answered

Metadata

  • December 14, 2023
  • 2 replies
  • 1418 views

I need to export a report with this metadata from my premiere file which has about 300 clips:

- timecode of each clip

- duration of each clip

- start and end time of each clip within the source

 

I'm preparing a spreadsheet in order to have certain assets validated and it's something a computer could do way better and fast then me lol.

 

Please send help.

 

I'll be here until 2025.

 

Thank you.

This topic has been closed for replies.
Correct answer Richard M Knight

Exporting an edl might also give you what you want.

2 replies

Richard M KnightCommunity ExpertCorrect answer
Community Expert
December 14, 2023

Exporting an edl might also give you what you want.

Mathias Moehl
Community Expert
Community Expert
December 14, 2023

This is a perfect job for Automation Blocks.

I recoreded this tutorial for you showing how I created a custom script in 10 minutes, which exports the data you need to a spreadsheet:

The script I create in the tutorial is attached. You can load it in Automation Blocks (also in the free trial) and just run it.

 

Extra tip: make sure the spreadsheet file does not exist, yet, if you run the tool. If it exists already, Automation Blocks will append the new spreadsheet data to the existing file. Of course, you can also add a block to the beginning of the block script, which deletes the file if it exists, but I wanted to keep the block code simple.

 

Mathias Möhl - Developer of tools like BeatEdit and Automation Blocks for Premiere Pro and After Effects
SeeSalt13
Known Participant
December 18, 2023

Amazing.