Export Clip Details to Spreadsheet

In the Adobe forum Emily asked how to export the in and out points and other details of all clips of a sequence to a spreadsheet.

Since this is a perfect job for Automation Blocks, I created a ten minute tutorial showing how to create an Automation Blocks tool for this purpose. You learn how to create a spreadsheet, how to choose which data to put in which column and also how to convert between time and timecode values to get exactly the spreadsheet you want.

Here is the full code of the tool:

Existing Spreadsheet File

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.