Can't Get Excel Batch List Into FCP at DVinfo.net

Go Back   DV Info Net > Apple / Mac Post Production Solutions > Final Cut Suite

Final Cut Suite
Discussing the editing of all formats with FCS, FCP, FCE


Reply
 
Thread Tools Search this Thread
Old May 12th, 2008, 01:51 PM   #1
Regular Crew
 
Join Date: Nov 2006
Location: Bozeman, MT
Posts: 118
Can't Get Excel Batch List Into FCP

Hi All,

In the final cut manual it says that "Batch lists can be created using any popular spreadsheet program or word processor." You just have to title the columns correctly: "Name," "Media End," "Media Start," and "Reel." I then chose file - import - batch list...but the excel spreadsheet I did the batch list on does not highlight as a file I can choose to import.

Any thoughts on what I am doing wrong?

Thanks,
Sharon

ps - using most recent FCP on Intel MacBookPro and Excel 11.3.7
Sharon Pieczenik is offline   Reply With Quote
Old May 12th, 2008, 04:08 PM   #2
Major Player
 
Join Date: Jun 2003
Location: Hong Kong
Posts: 340
Make sure that you saved the file in Excel as text (tab delimited), also it depends on whether you are making a PAL or NTSC list. You need to have a : or ; between the numbers eg 01:00:00:00 or 01;00;00;00

Bob

PS I am not certain about the ; as I can't check as I am not in the office
Bob Thompson is offline   Reply With Quote
Old May 13th, 2008, 08:04 PM   #3
Regular Crew
 
Join Date: Nov 2006
Location: Bozeman, MT
Posts: 118
Hi,

I tried to format the cells to "Text" but I still could not get final cut to recognize my excel (.xls) file to import into fcp as a batch list. I don't know what to do. Thanks for the text format suggestion. Any others?

Cheers,
Sharon

ps - for some reason I always thought that ; vs : had to do with drop frame versus non-drop frame
Sharon Pieczenik is offline   Reply With Quote
Old May 14th, 2008, 12:27 AM   #4
Trustee
 
Join Date: Apr 2005
Location: Santa Cruz, CA
Posts: 1,116
Sharon, it's not a matter of formatting the cells, FCP cannot recognize the xls format, you have to export your file as text, CSV or tab delimited. Then point FCP to the .txt file and you should get what you want.
__________________
Paolo http://www.paolociccone.com
Demo Reel
Paolo Ciccone is offline   Reply
Reply

DV Info Net refers all where-to-buy and where-to-rent questions exclusively to these trusted full line dealers and rental houses...

Professional Video
(800) 833-4801
Portland, OR

B&H Photo Video
(866) 521-7381
New York, NY

Z.G.C.
(973) 335-4460
Mountain Lakes, NJ

Abel Cine Tech
(888) 700-4416
N.Y. NY & L.A. CA

Precision Camera
(800) 677-1023
Austin, TX

DV Info Net also encourages you to support local businesses and buy from an authorized dealer in your neighborhood.
  You are here: DV Info Net > Apple / Mac Post Production Solutions > Final Cut Suite

Thread Tools Search this Thread
Search this Thread:

Advanced Search

 



Google
 

All times are GMT -6. The time now is 03:30 PM.


DV Info Net -- Real Names, Real People, Real Info!
1998-2017 The Digital Video Information Network