automating in and out edit points on one clip

[Tom Adams]

I have a 90 min clip that the client has selected a lot of “in and out points” for. How do I take those times from her spreadsheet and make an automated cut in one-fell-swoop. I’d like to find an easier way than manually making these individual cuts. Ok, hope that makes sense…

– seems like something that other editors probably do frequently, I’ve just never really had this specific repetitive workflow …basically like an edl being imported like the old days of analog…but need it to happen within premiere.

hope someone can easily explain to this “veteran” … thank you creative cow people for being around all these years! Cheers. -Tom

[Tom Adams]

no one ? any help here?

[Eric Santiago]

Sadly I can only think of using frame io for this.
However, the issue is you would have to have the markers done in frame io first.

I do this with clients.
Once I import the markers, I just take the blade to them.

Crossing fingers you find a solution.

[Tom Adams]

Here’s a good response I got:

“I would suggest that you convert the spreadsheet to edl, and then import the edl file.
Obviously your spreadsheet needs to be formatted so the converter can read it accurately.

There are plenty of converters around, a quick Google search brought this one in at the top:
https://en.editingtools.io/edl “

[Mads Nybo jørgensen]

Hey Tom,

I recognise that reply… 😉

Hope that it is working out for you.
Do let us know.

Atb
Mads

[Eric Santiago]

Haha, I was going to suggest EDL but man I didn’t know there was a converter.

I cant imagine doing that by hand.

[Tom Adams]

Thanks- much appreciated. Still trying to figure how the edl works. I’ve managed to export to csv and then convert to edl. but I’m confused what happens when I import the edl … Not sure how to “assign” the clip that I want to be used. Hope that makes sense?

[Mads Nybo jørgensen]

Hey Tom,

EDL is the earliest version of a time-line, before the time-line even existed.

You need to identify whether the timecodes are matching between excel sheet and media file?
Then there is the accuracy of the media file name – if that doesn’t match, you’ll need to “force” a match on relinking the files to time-line.

Fastest way around this might be to set up new project -> import edl -> link clips to media – copy linked time-line across into your master project.

But first, you have to ensure that the timecodes are a match.
The next fun thing, is whether your client have given you what they want to keep (In/Out points)?
Or, as some do, only tell you what they want you to cut out…

Atb
Mads

[Tom Adams]

Mads, thanks – yes, this all makes sense. This is going to save me so much time! Thanks!

[Tom Adams]

actually after further investigating… when import the edl: I was able to link media and the files show up properly in the clip window but things are all conjumbled when I click on the sequence. the files are not in order that they’ve been entered on the edl. I noticed that clips are actually being placed on this new timeline according to their timecode in and out points on the edl. EDL are supposed to be a bunch of clips in a new order according to their placement on the csv -> edl.

• Also no audio is being included when I look at the edl

• also the new sequence begins at 6:40 ??? This seems like a bug to me.

now I’m thoroughly perplexed … ugh, this is going to take so long to do manually…