Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
We're not quite done with importing techniques. I want to show you a special technique that involves a quick spreadsheet and allows you to import directly from the information imported on that spreadsheet. The file type is called a CSV file, which stands for comma separated values. It's a file that Excel or many standard spreadhsheets can make. And the idea is that someone could either export that out of a different logging program, or just by hand, use a spreadsheet to make a log and then we could import that log as a bin.
It's going to make more sense if I show you. So let's take a look. As you can see I'm in my exercise files, and I've provided this file for you. So you can follow along and do this. This is a CSV file and you can see its a very simple setup. We have the tape name, which is unknown in all of these cases, time code in, time code out and the file name. This CSV file describes a bin that we can make inside Premier Pro. It takes a couple steps, so let me show you.
I've switched over to Premiere Pro and I'm on a blank project now. This is not the one we've been working on. I think it would be confusing and start to get a little mushy if we kept adding the same things back by different techniques. So I just want to show you this technique. By itself and import a bin based on a CSV file. So, into a blank project, I'm just going to go, File>Import Batch List. It's not under import or command I.
It's, it's own command import batch list. Now, navigate to the CSV file that I showed you or if you are using your own, one that's been prepared by the same specifications and click Open. I have a choice for the video settings that the batch list should contain. These, for the most parts, should match your project and It's going to be fine. As you can, see I have a brand new bin, and it's based on the name of the batch list. If I scroll down and make the window bigger, you see that I've imported all of the information, but these little question marks tell me that I don't actually have good links to the video files.
What I understand this to mean is that all of the data that was on that sheet has been brought in as metadata into the project, I see the name of the file, I see the in and the out point and if I had tape names, I would see them there. In order to actually link these to the media files I need to select them and link media. Of course, this assumes that I actually have files by all of these names on the drive and I should.
Lets see, so I've already selected all of these files, it's also going to be important that I have mostly video files, but also one audio file. So we're going to have be careful where look for these. Now just right click and Link Media, now you see you I have my whole list of media to be linked. I'm going to start with one of my video files and locate where it is. So that's locate and navigate to the exercise files. A little bigger, so we can see inside media and inside footage.
And now, because display, only exact name is checked. I see only the matching name. When I select it and click OK. Almost all the files relate. I say almost all because it only linked the once in that directory. Because our audio file was organized in a separate audio folder, we need to carefully go back and also relink that one. So I locate. And then, I go to the Audio directory, I've got the name match, select and OK.
Now, everything is relinked with audio and video and I've successfully made a complete bin from a CSV file. Now, this depends on a couple things to work well. One is a properly formatted CSV file, and you can see that, by using the model that I gave you. And the other is, that the actual footage is available. Having a good CSV file without the footage to re-link to is really not that worthwhile.
Get unlimited access to all courses for just $25/month.Become a member
110 Video lessons · 51149 Viewers
86 Video lessons · 14356 Viewers
79 Video lessons · 15227 Viewers
350 Video lessons · 101441 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.