You can make course and training videos from a spreadsheet by designing each kind of lesson video once, as a template, and letting each row of the sheet supply the lesson title, the step text, the presenter’s name, the language and the clips. Change a cell and you can render that lesson again, so a course that changes does not mean re-editing every video by hand. It works best for the parts of a course that share a structure, and it is the wrong tool for the one-off explainer that needs its own animation.
This article is for the learning and development team, the e-learning producer or the instructional designer who already keeps the course outline in a sheet and is tired of rebuilding the same title cards, step cards and recap screens in a video editor. We will walk through which parts of a course fit this approach, how the sheet should be shaped, what happens when a fact changes six months later, how languages fit in, and where our own tool, Templater, helps and where it does not.
Which parts of a course belong in a spreadsheet
Most courses look varied from the outside and repetitive from the inside. Open any training program and count the videos that share a skeleton. There is the module opener with a module number and a title. There is the lesson intro with the lesson name, the learning objective and the instructor. There are step-by-step procedure clips where the layout is the same and only the step number, the instruction and the screen recording change. There is the recap card at the end with three takeaways. There is the certificate or completion video with a learner’s name. Each of those is one design used dozens of times with different words.
Those are the videos a spreadsheet can drive. The test is simple. Try to describe the video as a sentence with blanks in it. “A lesson intro with a module number, a lesson title, an objective and the instructor’s name and photo.” If the sentence comes easily, you have a template. If you need a paragraph of exceptions, you probably have a hand-built video, and that is fine. Plenty of good courses have a handful of those.
The usual split looks something like this. The repeating, structured videos, the openers, the step cards, the recaps, the quiz intros and the completion messages, go to the template. The few videos that carry the creative weight of the course, the scenario dramatization, the animated explainer of a hard concept, the welcome from the head of the department, stay in the hands of an editor. Trying to force those into a template produces a stiff video and a frustrated designer. Leaving the repeating ones to hand editing produces a tired editor and a course full of small inconsistencies.
Those inconsistencies are worth naming, because they are the real argument for this approach. When a team builds forty lesson intros by hand over a few months, the font size drifts, a logo gets nudged, the lower third moves a few pixels in lesson twelve and nobody knows why. A learner will not name the problem, but the course feels less finished. A template removes the choice. Every layer that is not connected to data stays exactly as the designer built it, in every lesson, in every language.
There is also a quieter benefit for the people who own the content. In most L&D teams the subject matter experts already live in documents and sheets. They are comfortable editing a cell. They are not comfortable opening a motion design project. When the course structure lives in a sheet, the person who knows that step four of the procedure changed can make that change in the sheet, and the designer does not have to retype it. That moves each piece of work to the person who is best at it.
How to shape the sheet so it survives a whole course
The sheet is the part people underestimate, and it is where most of the long-term pain or relief comes from. A few decisions made on day one keep the system working through every revision of the course.
One row is one video. In Templater, each row of a spreadsheet, or each object in a JSON array, becomes one render job. Each column maps to a dynamic layer in the template. So a sheet for lesson intros has one row per lesson and columns for the module number, the lesson title, the objective, the instructor name and the path to the instructor photo. Keep it that literal. If you find yourself wanting one row to make three videos, you want three rows.
Keep everything a template needs on one tab. Templater maps to a single worksheet of a single data source. Course outlines often sprawl across tabs, one per module, with a separate tab for instructors. Before you rig anything, merge what each template needs into one tab, or build a dedicated output tab that pulls from the others with ordinary formulas. Templater reads Google Sheets, tab-separated files exported from a spreadsheet app, JSON files and feeds, and Que, our cloud job queue. It cannot read an Excel file directly, so an Excel outline is exported to a tab-delimited file first.
Type the words exactly as they should appear. Templater reads text the way it appears in the cell, commas, quotes, apostrophes and new lines included. That is helpful for a step instruction that needs a line break in a particular place. It also means a stray space or a typo in the sheet will appear on screen. Treat the sheet as copy, and have someone proofread it as copy.
Plan for the longest step and the shortest one. A lesson called “Safety” and a lesson called “Completing the quarterly equipment inspection checklist” will both arrive at the same title layer. Templater’s layout rules adjust dynamic layers relative to their containing composition and to each other, so a longer title can resize or push its background plate instead of spilling off the screen. Timing has the same problem. A screen recording for step two might run eight seconds and the one for step three might run twenty. Time Sculpting, our patented set of time-based rules, crops, trims, shifts and stretches layers so footage of different lengths fits the design without anyone re-timing the edit. Fill the sheet with your real extremes before you finish rigging, because a rule is only as good as the worst row you tested it on. Our piece on managing text expansion in a fixed video layout goes deeper on the space side of this.
Use control columns for the variations. A course rarely needs only one version of each template. Some lessons have an instructor on camera and some do not. Some step cards need a warning icon. Templater lets the sheet carry these decisions. A flag is a term in double braces, and the off flag hides a dynamic layer for that row, so a lesson without an instructor photo can simply hide that layer. Wrapping a composition name in double braces in a cell swaps a composition layer’s source for that named composition, which is handy for switching between, say, a standard and a warning version of a step graphic. A target column chooses which composition in the project to render for a row, and an aep column can switch between whole project files row by row. Our post on using flags in data sources shows the first two in action.
Name the output files from the sheet. A course is delivered as many files that have to land in the right place in a learning platform. An output column lets you set the file name for each render, and a relative path at the start of that value sorts files into sub-folders, so lesson intros for module three can land in a module three folder already named for upload. Keep periods out of those names, because our documentation warns they can cause output errors.
A worked example
Picture the training team at a company that runs a twelve-module onboarding course for new warehouse staff. Each module has a module opener, five to eight procedure clips and a recap card. The team’s instructional designer already keeps the course outline in a shared sheet.
The motion designer builds three templates in After Effects. The module opener has a module number, a module title and a background clip. The procedure clip has a step number, a one-line instruction, a short caution line that can be hidden, and a slot for the screen or floor recording. The recap card has three takeaway lines and the next module’s title. She rigs each one, mapping layers to columns, and sets layout rules so long titles stay inside the safe area and Time Sculpting rules so recordings of any length still end on the branded closing beat.
The instructional designer reshapes the outline into three tabs that match the three templates, one row per video. The procedure tab has a column for the recording’s file path, a column for the caution line that holds the off flag in rows with no caution, and an output column that builds names like module-04/step-03 from the other cells. The designer previews the rows with the longest instruction and the longest recording, fixes two layout rules, and the first full course renders as a batch.
Three months later the safety team changes a procedure. Step three of module four now has a different instruction and a new recording. The instructional designer edits two cells and replaces one file. That one row renders again with the same output name, the new file replaces the old one in the module four folder, and the rest of the course is untouched. Nobody opened the old project, and nobody had to remember which font the step cards used.
When a fact changes, and when the language changes
The update story is where this approach earns its keep for training teams. Compliance content, product training and software walkthroughs all go stale. A policy changes, a button moves, a product is renamed. When the course lives as edited video files, every change means finding the right project, hoping it still opens cleanly, re-editing and re-exporting. When the course lives as templates plus a sheet, a change is an edit to the data and a re-render of the affected rows.
How you trigger that re-render depends on how much you want to automate. With Templater Pro, a person selects the rows and renders the batch. With Templater Bot, the sheet can work as an inbox. Bot looks for a render-status column, and a person or an application types ready into a row to mark it for processing. Templater then updates that cell itself as the row moves through queued, processing and done. So a changed lesson is re-made by editing its cells and typing ready again. One caution from our documentation is worth repeating here. Because Bot is fully automated, it overwrites an existing file when it renders to the same output name. For an update, that is usually exactly what you want, the new step three replaces the old one. For a sheet where two rows accidentally share a name, it means one silently replaces the other, so keep output names unique.
Before a changed batch goes anywhere near learners, check it. Templater lets you preview the compositions with your data and step through rows inside After Effects, so you can see the long instruction or the missing recording before anything renders. In Pro and Bot you can also generate spot checks, which export stills or short clips of chosen frames from the data-merged compositions. Name timeline markers for the frames you care about, such as the frame where the caution line appears, and those are the frames you get. That is a fast way to send a subject matter expert a page of stills to approve instead of a folder of videos. Our guide to preview modes and spot checks covers the details.
Languages are the other place a sheet pays off. A course that runs in several languages is a course with several columns, or several rows per lesson, one per language. You can put characters from any language in the sheet and they appear in your text layers, and right-to-left scripts are supported, as long as the fonts installed on the rendering machine contain the glyphs you need. Check the fonts first, because a missing glyph shows up as a blank or a box in the finished video and that is an embarrassing thing to find after upload. Templater’s dynamic text styling lets the font and the text direction come from the data too, so one template can serve a left-to-right and a right-to-left language without a second project.
Translated text is longer or shorter than the original, and it takes a different amount of time to read. The layout rules handle the space. Timing needs more thought, because a line that suits English may vanish before a slower reader in another language finishes it. Our piece on reading-speed budgets and language-aware timing describes how to let each row decide how long its text holds instead of branching the template per language.
Subtitles are often the biggest language job in a training library, and they fit the same pattern. Templater 3.4 added Dynamic Subtitles, a rigging utility that builds a subtitle rig on a dynamic footage layer. A reserved srt-data column in the sheet holds the path to each video’s SRT subtitle file, and the rig’s display layer controls the font, color, size, position and background for every subtitle. So a lesson in four languages can be four rows pointing at four SRT files, all rendered through one styled rig. Our walkthrough of setting up dynamic subtitles has the steps.
Now the honest limits, because a training team should know them before a pilot.
A spreadsheet does not write the course. The instruction on step three is only as good as the person who wrote it, and a template will render a confusing sentence beautifully. Instructional design stays a human job.
A spreadsheet does not record a voice or shoot footage. If your lessons have narration or screen recordings, someone still records them and puts the files where the sheet can point at them. The template places what you give it.
A text layer holds one style. You cannot make half of a step instruction bold inside a single layer. If your design needs a bold term inside a sentence, build it from separate text layers placed side by side, each mapped to its own column, and decide that before rigging rather than after.
Our product pages do not list direct connections to learning management systems. The realistic route is that Templater renders named files into organized folders, and you upload them or let your own scripts handle it. Teams with developers can write scripts that run when a render finishes, for example to move a file or write a value back somewhere, and we offer custom development if you want help with that part.
And the creative showpieces stay manual. The video that explains the hardest concept in the course with custom animation is a hand-built video. Many teams end up with both, a template system for the steady structure and an editor’s time spent on the few videos that deserve it.
Where does Templater fit in all this? It is a plugin that lives inside After Effects, so it suits teams that already have, or can borrow, someone who designs in After Effects. The designer builds and rigs the templates once. The people who own the course content then work in the sheet. Templater comes in three editions that work as steps. Rig is for the designer who maps data to layers and previews, and it cannot batch render. Pro adds batch rendering and replicating, started by a person, which suits a team that rebuilds a module when an outline is ready. Bot adds the render-status inbox, which suits a team that wants changed rows re-made without anyone pressing a button. Training and onboarding videos are one of the families we describe Templater being used for, alongside marketing, product and sports work. If you want to see it on your own course, the 30-day free trial of Templater Bot lets you rig one real template and run one real module through it, with a watermark on the dynamic layers and replication inside the project file turned off. Our Google Sheets reference is a good companion while you build the sheet.
The bottom line: a course is mostly structure, and structure belongs in a sheet. Template the openers, the step cards, the recaps and the language versions, keep one row per video and one tab per template, name the files from the data, and preview the worst rows before you render. When a fact changes, you change a cell. Keep the creative centerpieces in an editor’s hands, and let the spreadsheet carry the rest.
Training teams weighing this tend to ask us a familiar set of questions. Here are the short answers.
Frequently Asked Questions
Which training videos are a good fit for a spreadsheet-driven template?
The ones that share a skeleton. Module openers, lesson intros, step-by-step procedure clips, recap cards, quiz intros and completion videos are usually the same design with different words and clips. If you can describe the video as one sentence with blanks in it, it is a template. Custom animated explainers, dramatized scenarios and one-off welcome videos are better left to an editor, because a template controls what changes through data and does not invent new motion for each row.
How do I update a course video when a fact or procedure changes?
Edit the cells for that lesson, replace any changed clip, and render that row again. With Templater Pro a person selects the rows and runs the batch. With Templater Bot, you type ready in the render-status column and the Bot re-renders it. Bot overwrites an existing file that has the same output name, so the new version replaces the old one in its folder. Keep output names unique across rows so two lessons never overwrite each other.
Can one template produce the same lesson in several languages?
Yes. Characters from any language can go in the sheet and appear in your text layers, and right-to-left scripts are supported, as long as the installed fonts contain the glyphs you need. Dynamic text styling lets font and text direction come from the data. Layout rules handle longer translated text, and timing can be set per row so slower-reading languages hold on screen longer. Check fonts on every rendering machine before the first batch.
Can Templater add subtitles to training videos from SRT files?
Yes. Templater 3.4 added Dynamic Subtitles, a rigging utility that builds a subtitle rig on a dynamic footage layer. A reserved srt-data column in your sheet holds the path to each video’s SRT file, and the rig’s display layer sets font, color, size, position and background for all subtitles. One styled rig can then render the same lesson with a different subtitle file per row, which suits a library in several languages.
Can I use our Excel course outline as the data source?
Not directly. Templater cannot read an Excel file as it is, so you export the sheet to a tab-delimited file first. Templater also reads Google Sheets, JSON files and feeds, and Que. It maps to a single worksheet, so put everything one template needs on one tab, either by merging module tabs or by building an output tab that pulls from the others with formulas.
Does Templater upload finished videos to our learning platform?
Our product pages do not list direct learning platform connections. Templater renders files with names you set from the sheet, and a relative path in the output value sorts them into sub-folders, so each module can arrive in its own named folder ready to upload. Teams with developers can add scripts that run when a render finishes to move or register files, and we offer custom development for that part.
Who on the training team needs to know After Effects?
Only the person who builds and rigs the templates. Templater runs inside After Effects, so a designer creates each template and maps its layers to columns. After that, instructional designers and subject matter experts work in the sheet, editing titles, steps and language text as ordinary cells. If nobody on the team works in After Effects, you will need a designer for the first build or outside help.
