This lesson is exclusive to members

Adobe Premiere Pro - Advanced Training

How to use a CSV data driven infographic in Premiere Pro

Daniel Walter Scott

Download Exercise Files Download Completed Files

Contents

Certificates

We’re awarding certificates for this course!

Check out the How to earn your certificate video for instructions on how to earn yours and click the available certificate levels below for more information.

You need to be a member to view comments.

Join today. Cancel any time.

Sign Up
Hi everyone, in this video we're going to create this infographic. This one's special because it's connected to a spreadsheet, like something made out of Excel, or Apple Numbers, or Google Sheets. It connects to an sv, not an svg, a csv, and it will update automatically here in Premiere Pro. Why is that so close? Look, I've already rendered it, already done the intro, we have to live with it now. All right, let's jump in and make it. 

So to connect up our csv data driven infographic, we need to find the right kind of a template. So not all of them will do it, and you find that's one, that's kind of pre-done for us. So under 'Essential Graphics', find 'Browse' let's go to 'Adobe Stock', remember, you don't have to find it from Adobe Stock, they've got some good free ones though, you want to look for like data driven, or csv, or try and use those sorts of search terms. Data driven is what Premiere Pro have got a bunch of ones in here. 

We're going to use this one here, click it to download it, or just click and drag it, into your Timeline, give it a second, it'll wait, it'll download the pieces it needs. I've already pre-downloaded mine, so it went real fast, and it's pretty cool, let's have a little look. 

Actually, clear my In and Out, I'm going to set a new In and Out over here, In, Out, hit my 'Return' key. It's going to render it in here, so it looks nice. I'll speed this up, I'll get bored halfway through, hit 'Cancel', and we'll just watch it in the slo-mo version, look at that, kind of all speeds around, and kind of goes, pretty nice, huh. 

So we need to update this, how do we update it? With it selected we go over here, in our 'Essential Graphics' panel, under 'Edit', you can see it here, we've got all our chart controls, there's lots to, there's lots of good controls in here, including some of the fonts, which is great. We don't have to go and do anything like that. Ours is all about, I can't remember, Co Working Stats, that's, let's all put in here, using our Stats, and here, like you can manually update it, by just clicking in 'Edit', there's like a default csv or a spreadsheet already attached to it. 

You can say, actually I only want like four rows, you can see four of them disappeared. I want this one to say SMEs, and this one to say Bananas, whatever you want to do, you can make the adjustments here, and manually go and change this here, so that's cool. What we want to do though is attach a csv, or, talking Excel or Apple's Numbers, Google Sheets, the thing for this to work though, it has to be a csv or a tsv, like a comma separated values or a tab separated values. 

So I've got one ready to go. So I'm going to go to 'Browse', under your 'Exercise Files', under 'Co Working', there's one in here called 'Co Working Stats', and it is a csv, very common kind of database output. Let me show you what it looks like. It looks like that, it's got a column with a name on the top, and it's got all my different data points. If you are creating this, make sure you put a title in the top, or a heading in the columns, because it ignores that first row, and there's all my stats, SMEs - 38. You can read, Startup Teams, I just want you to see that it's going to match in here, hopefully in a second. 

So I'm going to click 'Open', give it a sec, look at that, it knew that it was five rows, let's put them all in here, and there was no column for colors. You could, if you were creating this as a, like a database driven completely, you could create that in your svg, the colors, I've just left mine blank, I'm going to manually change the colors. You can still go and edit it afterwards, you might just use it for the first time to do it, and what we'll do though is, I want to show you how to maybe update it automatically, because now we can just go through and fiddle with them, make it look nice, change the fonts, change the sizing, but let's look at, let's say we want to kind of dynamically update this thing, kind of dynamically update this thing. 

If we want the csv to update, and for this Premiere Pro to automatically update we need to map these. All it means is that this first, this first column here is mapped to that column name of our csv file. Remember, they were named, who are our members, and percentage. You might have more of them and they just become unmapped, but I just want to use these two that match these two. We're going to click 'OK', and because they're mapped, it means that when I change the csv, they're going to change in here. 

So to change the csv the thing you need to remember, is you need to update it. So on a Mac it's very common to use Numbers or Excel, on PC, I think it's the law to use Microsoft Excel, you could be using Google Sheets. You need to do the updates through whatever it is you use. So in this case I'm using Google Numbers, and let's say we change it to two, just because when we change this to, Handsome Daniels, let me click off. 

Now if I hit 'Save' now it's going to save in the native format of Numbers or Excel. It's going to be one of those xls files, Google Sheets, I don't know what it saves as. So you need to export from whatever thing you're changing it in. I'm going to 'File', 'Export', and you'll see this, in Excel, is it Export? It might be Export or Save As, but you're looking for a tsv or a csv, comma separated values or tab separated values, just click 'Next'. 

I'm going to stick it over the top of the original one, so back into my 'Exercise Files', 'Co Working', because this is what, that's what Premiere Pro is currently looking at that file. So I'm going to export over the top of it, it's going to say, "Would you like to replace it?" I'm like, uh, careful, can I go back, I'm going to live life on the edge, I'm going to update the stats, click 'Replace', and over here, oh, did you see it update? Oh, you did. 

So you can be dynamically updating the csv, however way you do it, you might be, might be created via database, maybe a web app, creates it for you, or you might just manually update it. Somebody's job is to update this, and your job is to just watch it update here in Premiere Pro. That might seem a little tricky as in, what if somebody updates it, and it's for an old project? It's probably best just to go through and browse, and bring in the new version. It might be May stats, April stats, and just rename it csv. Doesn't really need to dynamically update, just as long as they keep the same column names, it will update nice and easily. 

All right, so that is an infographic at its maximum, inside Premiere Pro. We've connected it to a spreadsheet via our s-- I can't even do it, svg, I want to say, it's got some of them in there, a csv, and we can update it as long as they're mapped, wonderful. All right, that is it, let's get on to the next video.