Importing Excel files

[Josh Olenslager]

We’ve imported logging data this way as batch lists. Not the most complete data sets, but if your column headers match the FCP headers, you can get basic TC and reel data in place.

Josh

[Mike Simpson]

This is possible and is probably explained in the FCP user guide.

I’m not sure whether i did it the only way but i saved my excel sheet as tab delimited (i think) txt file and then imported it into FCP via batch list import.
If you pop me an email or give me an email address i can send you just a line of my recent log to get you going.

Mike

[Mark Welch]

Mike,

Thanks,
My email address is sailingpodcast(at)gmail.com

cheers,
Mark

[Derick Joe]

Mike,

Can I get a copy of your header as well? I’ve been trying to create an Excel template for our loggers to use, but I can’t seem to get the headers right. I keep getting errors when trying to import the log into Final Cut Pro. I appreciate it.

derick.joe@kw.com

-Derick

[Mike Simpson]

will do Derick…it’s not a complicated document by any means but it may help you.

Mike

[John Pilgrim]

I recently wrote a Python script to import clip logging data that my clients had entered into a Google spreadsheet.

Export the spreadsheet data as a CSV file, do a tiny bit of cleanup in a text editor, and run the script. The script converts the CSV entries into an XML file of an FCP bin containing all the clips, with the Clip Name, Reel, Log Note, Description, Master Comment 1-4, et al columns populated with the data from the spreadsheet. Import the XML into FCP, reconnect the media, and viola, all the logged clips are right there.

Caveats:
(A.) The script is designed for a file-based workflow, as the footage for the current project originated on an EX1. It could theoretically be expanded to include TC IN and OUT for tape-based logging, but I’d leave that up to you.
(B.) It’s a command line script with no GUI. If you’re comfortable typing something like
python csv2xml.py path/to/loggingdata.csv path/to/mynewbin.xml
in the Terminal, then check out the script: https://johnpilgrim.net/color/csv2xml.html

Feature requests are welcome, but please be circumspect that this is simply a quick in-house workflow tool that I’m sharing, not a commercial product. I will keep working on it as time permits. Better documentation is the first task!

Cheers,
John
SF, CA