Skip to main content
L
leolac58028824
Participant
June 6, 2021
Question

Importing CSV file for metadata - Premiere Pro

  • June 6, 2021
  • 1 reply
  • 8909 views

Hello All,

 

Is there a way to import metadata logging from a CSV file into Premiere Pro so that the metadata attaches to the imported files?  We have a heavy archival project in which the material has been tracked in a spreadsheet and it would save time if we coould import the descriptions, keywords, etc into Premiere rather than log it again.  Thanks in advance!

    This topic has been closed for replies.

    1 reply

    Joost van der Hoeven
    Community Expert
    Joost van der HoevenCommunity Expert
    Community Expert
    June 6, 2021

    I suggest you take a look at the .ALE workflow:
    https://www.youtube.com/watch?v=ctcDvGQSuHY

    Joost van der Hoeven
    Community Expert
    Joost van der HoevenCommunity Expert
    Community Expert
    June 17, 2021

    An .ale file is a .csv but it uses tabs instead of comma's, if you know how a .csv works, then you know this doesn't matter.

    S
    seb.reategui
    Participant
    April 26, 2024

    Joost, it is true that ALE is TSV (tab separated values), but it contains substantial header lines like video format, audio format and column names separated from the actual data rows. A basic CSV will have only one row for columns and the remaining rows are data.

     

    Of course both can be opened inside Excel or Google Sheets or Notepad and edited by hand to a human that can see and edit the data by eye regardless of these differences.

     

    But because of the differences in structure, it means that ALE is truly not the same as CSV and they are really not compatible, both in the sense of NLEs or other applications reading the data from the file in a structured way, and for applications that export data in a structured way like CSV export.

    So no, someone with a spreadsheet or VFX shot logging platform or similar would not be able to export metadata in CSV format and import it into Premiere Pro. And it would also not always be easy to convert this data into an ALE! At least in an automatic or user friendly way, without manually reformatting it to add ALE headers.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices