VFX Sheet Creator

This tool allows you to easily create a VFX shot list with clip timecodes and additional metadata from a sequence file. You can also add more metadata by merging data from ALE files.

Drop your files here or click to browse Sequences: .edl, .xml, .fcpxml or .csv · up to 15 files
Framerate
VFX Shot ID
Use the variable {COUNT,10,3} to generate a number increasing in steps of 10 with 3 digits. Use {LOCATOR} to add the Locator Name. Use {SCENE} to add the Scene number (from ALE). Use {TAKE} to add the Take number (from ALE).
ALE Files
Merge by
Export
Export
Timecode formatting
VFX Sheet

in progress...
✔ Free tool
✔ EDL, XML, FCPXML & CSV
✔ Excel, ODS & CSV export
Archive.Kitchen

Do it properly in Archive.Kitchen

This free tool does one step. Archive.Kitchen, our archive production manager for film and series, includes it and connects it to the whole production.

  • Manage archive footage, VFX shots, stock clips, vendors, budgets and credits in one place
  • Upload a new cut and shot lists, previews and statuses update automatically
  • Track licensing status and costs per clip across the whole production

What does this tool do?

This tool allows you to create a VFX shot list from a sequence file. Simply upload an XML or EDL file from your sequence and export the list as Excel, OpenDocument or CSV file (e.g. for MS Excel, Google Sheets or Apple Numbers).

Sequence to VFX sheet

What file formats can I upload?

EDL

Edit Decision List CMX3600 (.edl)

XML

Final Cut 7 XML (.xml) from Premiere or DaVinci Resolve.

FCPXML

Final Cut Pro XML (.fcpxml) [Experimental]

CSV

CSV - Comma-separated values (.csv)

preset_edl.csv

Add more data with ALE files

You can upload ALE files to automatically add more technical metadata to your VFX sheet. When merging metadata, be sure to select a merge option that is unique.

Create VFX Shot IDs

This option allows you to automatically generate shot IDs. There are several options to choose from, but most of them require additional metadata from ALEs to work.

Add thumbnails

For a better overview, the tracker document should be provided with thumbnails or preview screenshots. This step can be partially automated:

  • Extract images from a video using our image extraction tool.
  • Use our Marker Converter to generate a script (with ffmpeg) you can run locally: select "Convert clips from EDL to markers (.edl)" and "ffmpeg Shell Script: Markers to Stills (.sh)", then download and run the script.

Quick Guides

How do I import a csv file into Google Sheets?

Open Google Sheets and go to "File -> Import". Upload the generated CSV file and press "Import Data" to generate a Sheet with all shots.

How do I import a csv file into Apple Numbers?

Open Numbers and go to "File -> Open". Simply open the CSV file.

Helpful Links

Beta

This tool is currently in the testing phase and we would like to know what features you would like to see in this tool. We would be happy to add your wishes to make the tool perfect.