How to use a CSV data driven infographic in Premiere Pro

This lesson is exclusive to members

Course contents
SECTION: 4
Preferences 10:03
SECTION: 10
Freeze, Hold & Pause 7:20
SECTION: 14
Storyboarding / Planning 3:04
SECTION: 21
Workspaces 2:38

Questions

2

Course info

146 lessons / 17 hours 49 quiz questions 14 projects Certificate of achievement

Overview

Hi there, my name is Daniel Walter Scott & I’m an award winning Adobe Certified Instructor. Welcome to the Premiere Pro Advanced Course.

This course is aimed at people who already know the fundamentals of Adobe Premiere Pro. If you have developed your own way of doing things but you realise there are so many tools, updates & time saving techniques that you haven't had time to explore then this course is definitely for you.
• We look at the best productivity hacks & little known features to super speed your timeline editing. 
• We explore color management, color grading, color replacement & skin tone correction.
• You will master all the new Lumetri color methods and harness the power of scopes. 
• You will learn new ways to successfully create traditional & new style transitions. 
• You will quickly become a master at fixing shaky handheld and drone footage.
• There won’t be anything you can’t mask or blur.
• We will get your computer running at warp speed using Proxies, Scratch Disk & Cache management. 
• You’ll master high frame rate footage to enable you to produce spectacular slow motion video. 
• You will create high quality professional motion graphics & data driven infographics. 
• You’ll learn all about Premiere Pro’s responsive time and design tools so you can make graphics & animation once that can be used across multiple future productions. 
• You will learn file and footage techniques which will enable you to work with multiple editors. 
• Multi-camera editing will be a breeze. 
• You will learn stunning techniques to help clean up your audio by removing noise, hiss & echo. 
• Learn how to manipulate & extend your music in Premiere Pro & also in Adobe Audition. 
• You’ll learn which tools & techniques are best for removing the monotony of repurposing the same footage across multiple sizes for social media. 
• Learn about markers, subtitles and amazing plugins, 
• You will learn all the best tricks and settings which will enable you to get the most from your rendering in Premiere Pro and also in Adobe Media Encoder.   
We cover all these topics and more in this course. 
Take a look at the contents and read reviews from other students and you’ll see this is the course that will get you from adequate - to EXCELLENT in Premiere Pro.

In this course we use real world, practical projects and use exercise files which you can download and then work alongside me.

If you can’t remember the last time you sat down & went through the features & updates in Premiere Pro, let this course be your all-in-one professional development & upgrade.  

You owe it to yourself -  sign up and get ready to become a Premiere Pro Super Hero.
Daniel Scott

Daniel Scott

Founder of Bring Your Own Laptop & Chief Instructor

instructor

I discovered the world of design as an art student when I stumbled upon a lab full of green & blue iMac G3’s. My initial curiosity around using the computer to create ‘art’ developed into a full-blown passion, eventually leading me to become a digital designer and founder of Bring Your Own Laptop.

Sharing and teaching are a huge part of who I am. As a certified Adobe instructor, I've had the honor of winning multiple Adobe teaching awards at their annual MAX conference. I see Bring Your Own Laptop as the supportive community I wished for when I was first starting out and intimidated by design. Through teaching, I hope to bring others along for the ride and empower my students to bring their stories, labors of love, and art into the world.
True to my Kiwi roots, I've lived in many places, and currently, I reside in Ireland with my wife and kids.

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.

Downloads & Exercise files

Transcript

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.

  • Powered by Marvin
  • Terms of use
  • Privacy policy
  • © Bring your Own Laptop Ltd 2025