{"id":637,"date":"2018-06-04T17:46:55","date_gmt":"2018-06-04T17:46:55","guid":{"rendered":"http:\/\/www.editspecialists.com\/blog\/?p=637"},"modified":"2018-06-04T17:46:55","modified_gmt":"2018-06-04T17:46:55","slug":"used-footage-from-excel","status":"publish","type":"post","link":"https:\/\/www.editspecialists.com\/blog\/index.php\/used-footage-from-excel\/","title":{"rendered":"Create Used Footage List From EDL Using Excel"},"content":{"rendered":"
\"image_pdf\"<\/a>\"image_print\"<\/a><\/div>
    \n
  1. File> Open > Browse to .EDL file> import wizard opens>Choose Delimited > Click Next.\u00a0 \"\"<\/a><\/li>\n
  2. Choose Space, Uncheck the Tab button. > click Next.\"\"<\/a><\/li>\n
  3. Choose Text > hit Finish\"\"<\/a><\/li>\n
  4. Save the spreadsheet as Excel workbook.<\/li>\n
  5. Switch to the Data Tab > Top menus.<\/li>\n
  6. Select all then click the Filter button. This makes each column a sortable category.\"\"<\/a><\/li>\n
  7. Click the little arrow next to the column you want to sort and choose Sort A to Z in the menu that pops up.\"\"<\/a><\/li>\n
  8. Bam your EDL is now sorted \u00a0It doesn’t really matter which column you sort, the point is to get lines that are named to same together for the next step.<\/li>\n
  9. Select all rows that are NOT the rows you are interested in, for example: you need the SOURCE names of clips in the edl<\/li>\n
  10. Delete all rows that are not SOURCE by selecting them and choosing delete rows (CRTL – (minus sign))<\/li>\n
  11. Congratulations, you now have a list of clips used in the sequence without any other clutter. To neaten it up remove all duplicate rows.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

    File> Open > Browse to .EDL file> import wizard opens>Choose Delimited > Click Next.\u00a0 Choose Space, Uncheck the Tab button. > click Next. Choose Text > hit Finish Save the spreadsheet as Excel workbook. Switch to the Data Tab > Top menus. Select all then click the Filter button. This makes each column a sortable … <\/p>\n

    Read more “Create Used Footage List From EDL Using Excel”<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-637","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.editspecialists.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/637","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.editspecialists.com\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.editspecialists.com\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.editspecialists.com\/blog\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.editspecialists.com\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=637"}],"version-history":[{"count":1,"href":"https:\/\/www.editspecialists.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/637\/revisions"}],"predecessor-version":[{"id":644,"href":"https:\/\/www.editspecialists.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/637\/revisions\/644"}],"wp:attachment":[{"href":"https:\/\/www.editspecialists.com\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=637"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.editspecialists.com\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=637"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.editspecialists.com\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=637"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}