Import (or paste) timecodes from a spreadsheet (Excel) to an Adobe Premiere project

[Walter Soyka]

[Carlos A. Montero] “EPISODE1, EPISODE2 and EPISODE3 are independent files, the second column is the name of the file, third is the description and fourth and fifth are the in and outs.”

Your format is wrong. From the Premiere documentation on batch lists [link]:

When you import a batch list, the order of fields in the list must be as follows: tape name, In point, Out point, clip name, and comment. When you export offline clips as a batch list, Premiere Pro orders the fields as follows: tape name, In point, Out point, clip name, log note, description, scene, and shot/take. Exported field data is exported from the corresponding columns in the List view of the Project panel.

Walter Soyka
Designer & Mad Scientist at Keen Live [link]
Motion Graphics, Widescreen Events, Presentation Design, and Consulting
@keenlive   |   RenderBreak [blog]   |   Profile [LinkedIn]

[Carlos a. Montero]

Hello Walter,

Thanks for the answer.

That’s the excel file i was working on, not the CSV file I’ve imported as Bach list.

The CSV file worked fine until I relinked the material, then all the in and outs were erased and I only had the clip without any marks.

EDIT:

This is how I make the csv file:

Unknown Tape,01:19:26:00,01:22:24:19,SUBCLIP1,,,,,
Unknown Tape,10:11:47:11,10:16:03:19,SUBLCLIP2,,,,,

I have tried to change “Unknown Tape” for the name of the file as well.

Thanks again.

[Walter Soyka]

[Carlos A. Montero] “The CSV file worked fine until I relinked the material, then all the in and outs were erased and I only had the clip without any marks.”

Ah, now I understand.

Pr is treating the clips created from the batch list import as if the in and out points you are specifying were instead the media start and media end points, as they would be from individual tape captures. When it tries to connect to the file and sees different media start and end points, it is resetting these and you are losing your information.

There does not seem to be an easy way to fix this. It could be done by writing a custom application to translate the CSV data to XMP data, but that may take more time than just doing it by hand.

Personally, I’d write a keyboard macro to help you recreate the subclips, since it’s the same set of keystrokes over and over to jump from Excel to Premiere, copying and pasting data from Excel into Premiere.

Walter Soyka
Designer & Mad Scientist at Keen Live [link]
Motion Graphics, Widescreen Events, Presentation Design, and Consulting
@keenlive   |   RenderBreak [blog]   |   Profile [LinkedIn]

[Dina Guttmann]

Hi Carlos –

Did you find a solution to this problem?

Unfortunately, I’ve got too much information logged in excel to use the copy and paste method.

Thanks!
– Dina