Updated Music List Combiner Spreadsheet: What’s New?

I’ve recently realised that the original script attached to the music list combiner spreadsheet I posted here in September 2025 wasn’t quite as tight as it needed to be, specifically when it came to how it interacted with different sorts of fades. Although I showed it working in my tutorial with a simple transition, it turns out it didn’t handle crossfades or fades overlapping other music very well. I’ve updated the Google Apps Script to handle these properly, so if you’re using the old version, I definitely recommend swapping it out for this one.

Get the Updated Script by clicking here

Key Improvements:

• The Bridge Rule: The old script did merge songs, but this version is much smarter at bridging the gaps caused by complex fades and overlaps. It is more bulletproof to make sure we get the results we need: one single, continuous entry on your cue sheet from the very first frame to the last, including fades into the song or a fade out of the song if there are any involved.
• Selectable Frame Rates: You aren’t stuck with 25fps anymore. When you run the script, it asks for your project’s frame rate (23.98, 24, 25, etc.), so your durations stay accurate.

• Transition Snapping: It now automatically cleans up those 1-frame overlaps that usually happen with fades, ensuring your start and end times are frame-perfect every time.

• Simplified Workflow: No more manual prep. The spreadsheet
  layout has changed to make the whole process faster. You no
  longer need to manually filter or delete rows that are missing
  track names or have a duration of 00:00:00:00. Unlike the
  original tutorial where you had to delete these rows yourself,
  the script now cleans them up automatically. You just need to
  format your tabs to look like this example. Once set up, just
  paste your raw EDL into the EDL tab and the results automatically
  appear in the Cues tab after you press the “button” and type out your frame rate.

Note for anyone watching the tutorial video: The video is still the best way to see how to bring the script into Apps Script within Google Sheets and get it running. However, this updated version is much more efficient. It removes the need for manual column placement and includes smarter merging logic to handle transitions and fades automatically. Watch the tutorial here.