Making Storyboards with Excel and Adobe Premiere

The first part of a storyboard software is an ability to make frames. You can sketch them really easy or painstakingly model every frame in 3 D, which is an overkill.

Once you have all frames collected, then comes the second part of a storyboarding program and it’s even more important than the first part: Arranging frames in a proper way to get the right rhythm.

Storyboard in Celtx

I want to print the storyboard in different ways. According to locations, or according to time – Day, night shots, or by an appearance of actors or even by the framing of shots. And this is impossible to do in Celtx. I like to write additional brainstorm notes about the shots and I can do it only in the mainframe. Celtx is very basic and a free program but useless for storyboarding.
I can play my storyboard at the end but it is totally basic, just a slideshow. You can not control the duration of each frame. You can not ad sound to it, so useless again.

Storyboard in Excel

For me the best program for arranging frames is Excel. I can have as many columns as I like and I can rearrange them easily.
The only problem is that Excel doesn’t work well with pictures. But there is an awesome little add-in program which is called Excel Image Assistant which makes Excel ideal for arranging storyboard frames.
First, you must arrange the cells in excel so they all have the same hight.
Before you import the frames make sure they are at the same resolution.
All pictures should have the same aspect ratio. 16:9 is the most common of course.
That way you get all pictures aligned in Excel.
After you imported all pictures you should not move or resize them.
if you do it than Excel could act strangely.
When you put together your storyboard you want to see how it looks. Instead of a slideshow, it’s best to use Adobe Premiere and Adobe After Effects for that.
I just edit all frames there, ad music, transitions and I can see what’s working and what’s not.
In order to finish the storyboard, you should go back and forth from Premiere to Excel until you are not satisfied with the final result.
For production purposes you can print the storyboard as you like:
  • According to location,
  • Actors appearing in the shot,
  • Exterior interior,
  • By framing,
  • By night or day shots,
  • By location
After you shoot the video the final editing will look different but you would know exactly what you are doing. Very practical.