Producer’s Best Friend 4+

Spreadsheet reports from FCPX

Intelligent Assistance Software, Inc

    • 5.0 • 9 Ratings
    • $99.99



Eliminate Clip Reporting hell! Every Report you need from Final Cut Pro X, in a formatted spreadsheet with no EDL or copy and paste!

Producer’s Best Friend creates a formatted .xlsx spreadsheet report (for Numbers, Excel, Preview, etc.) about the video clips, audio clips, titles, generators, markers, keywords, effects and transitions in your timeline or event to help you make batch lists, cut lists and music cue sheets. Producer’s Best Friend reports on Clips in a Library, Event, Compound Clip or Project. The report includes sheets for:
• Summary (with missing media and generators)
• Clips (with optional thumbnails)
• Roles/Subroles (with optional thumbnails)
• Keywords
• Ratings
• Markers
• Titles & Generators
• Video & Audio Effects
• Transitions

Producer’s Best Friend takes the tedious work out of creating all kinds of clip usage reports. Report on clips in an Event (like Batch List in FCP7), clips in a Compound Clip or clips in a Project in an Excel spreadsheet in seconds. Why spend days doing a boring task when it can take minutes?

Producer’s Best Friend can generate music use reports as well as Video and Audio Effects, Roles and Subroles, Transitions and Markers directly to a fully formatted Excel spreadsheet, without the convoluted use of an EDL or copy/paste techniques. 

You can choose which Roles to include in the report (Video, Titles, Dialogue, Music, Effects, and any roles and subroles you’ve created), and Preferences lets you choose whether times are displayed as seconds, frames, feet+frames or HH:MM:SS:FF timecode format.

Producer’s Best Friend will get you home earlier by:
• Speeding the reporting of clip usage for music reports, stock footage requests, effects used, markers and keywords with amazing flexibility. Reports are complete in seconds, not hours or days.
• Providing full control over the report: choose which roles/subroles are included.

Producer’s Best Friend will save you money because:
• Your clip reports are completed in seconds instead of hours or days.
• You have full control over the report: choose which Roles to include in the report(s) including Roles and Subroles you’ve created.
• Generate as many reports as you need: create a music usage report; create a report of every clip used in a Compound Clip or Project, or every clip in an Event; report stock footage used, to order the full resolution for online; list out all Effects, Transitions, Titles and Generators used to smooth online finishing (the Apple column shows whether it’s a standard effect or transition compared to one created by a third-party); report all the comments in your Markers.
• Generate one report for the whole timeline, or report role-by-role.

Reports can be further processed in your spreadsheet application for formatting and additional detail, if required.

Clips and Roles/Subroles Reports
• Video thumbnail; Role ▸ Subrole, Clip Name, Category (primary, secondary, connected); Enabled; Timeline In; Timeline Out; Clip Duration; Source In; Source Out; Source Duration; Markers; Keywords; Effects; Notes; Reel; Scene; Take; Camera Angle; Camera Name; Frame Rate/Sample Rate; Frame Size/Audio Config; Source File Path; then columns for clip metadata.

Markers Report
• Marker Name; Type (Standard, Incomplete to-do, Completed to-do, or Chapter); Notes; Timeline Position; Visible; Clip Name; and Role ▸ Subrole; Reel; Source In; Source Out; and Source Duration.

Keywords and Ratings Reports
• Keyword; Notes; Timeline In; Timeline Out; Duration; Clip Name; and Role ▸ Subrole.

Titles & Generators Report
• Name; Enabled; Apple (Apple vs third-party generators); Role ▸ Subrole; Timeline In; Timeline Out; Clip Duration; Font; and Title Text.

Video & Audio Effects Report
• Effect name; On/Off; Apple (Apple vs third-party effects); Clip Name; Role ▸ Subrole; Timeline In; Timeline Out; and Clip Duration.

Transitions Report
• Transition name; Category; Apple (Apple vs third-party transitions); Timeline In; Timeline Out; and Duration.

What’s New

Version 1.4.71

• Critical bug fix to read and process "Final Cut Pro Document" binary files exported from Final Cut Pro

Ratings and Reviews

5.0 out of 5
9 Ratings

9 Ratings

Coach264 ,

Saved me time and Money on my Documentary

We did a two hour documentary. The documentary aired on PBS stations across the country, I had 3 different music providers, over 5 thousand pictures and 70 reels of film which was donated to us. We had arcival buyout footage and 3 sources of buy out music. We went up to hollywood to use a post house for the final mix down. to figure were everything came from for the TV networks would have taken me a few weeks, Producer's Best Friend took seconds. I even had a 15 second song clip, that I wasn't supposed to use. I was lucky that I had sent a spreadsheet copy of Producer's Best Friend to all of the composers and one of the one composer found that clip in the spreadsheet I sent him and we took the song out. If I didn't have Producer's Best Friend, that 15 second music clip could have cost me thousands. I promise you won't be dissapointed in this app.

CamelioMack ,


Thank you, thank you, thank you!

Using with Resolve. Exporting to Final Cut X XML file, and then converting to spreadsheet.

It worked. Big time saver.

Thanks again.

Esplosuin ,

It's so clever

You export the project notes, markers and notes from a FCPX project via XML into Producer's Best Friend which then it generates reports of everything in Excel format. So in seconds you have a list of things to do, clips that you've used, transitions, with times, durations, everything all in a spreadsheet.

I take the spreadsheet, move the columns around, remove those I don't need, and (exporting via a .csv file) start it up in an outliner (Novamind, which will import from a text file) so I can start a paper edit using my favorite Outliner app on the iPad, so I can do that with all the notes that I've made on the clips, mull that over then go back to FCPX to finish the edit. I prefer to do the thinking in an outliner first, and because I'm outlining with all the actual timings and notes and markers from the project, the paper edit is very easy to put together,.

The spreadsheet is a good intermediate as you can rearrange, format, edit, search to your heart's content on the data without touching any clips. You don't need a database, Numbers is plenty good enough.

The outliner is really fast for grouping information about clips, thematically, to-do's, notes, ideas.

Producer's Best Friend is worth its weight in gold, many times over.

App Privacy

The developer, Intelligent Assistance Software, Inc, indicated that the app’s privacy practices may include handling of data as described below. For more information, see the developer’s privacy policy.

Data Not Collected

The developer does not collect any data from this app.

Privacy practices may vary, for example, based on the features you use or your age. Learn More


  • Family Sharing

    Up to six family members can use this app with Family Sharing enabled.