Automation Blocks - Spreadsheet Being Generated with Combined Columns

[Citizen_Sam]

Hi Mathias and Premiere Community,

I followed the tutorial on Export Properties of Selected Clips to Spreadsheet for Automation Blocks.

When viewing the .csv in Open Office, the Clip Name, Parameter, and Value are all combined in column A, instead of in separate columns like in the video. Each cell in column A has clip name, parameter and value all together, separated by commas. Quite a jumble.

Column B has "Path"

Any idea why?

[Mathias Moehl · Accepted solution]

Hi Sam,

there are different flavors of cvs files - some use tabs as as separator symbol between the cells, some use tabs and some use ;

In Open Office during import you can choose which separator symbol you want. Make sure to use comma.

This is what the import dialog looks like in my German Open Office:

[Citizen_Sam]

That worked! Thank you!
There wouldn't be a way to export only the 'source file' parameter, would there?

[Mathias Moehl]

You can write custom tools which export exactly what you want.

See 

and