How Do I Use CSV Files to Add Metadata in Bulk?

CSV files allow you to add metadata to multiple uploads with one master file.

CSV stands for "Comma Separated Value". It's essentially a text file, but you can use any spreadsheet editor - including Excel, OpenOffice, or Google Docs to edit it.

Creating and applying a CSV File.

You can start from a blank file, but we suggest you use our CSV template here.

Applying CSV's are a powerful option to insert metadata such as titles, keywords, and prices in bulk, to several of your uploads at once!

Please note, the main Values required for a successful upload to our CSV system are:

  1. clipid or originalfilename → *for originalfilename, please make sure you delete/remove any special characters
  2. name
  3. description
  4. price
  5. keywords → *keywords should always be separated by a comma and a space

To avoid confusion, make sure you only apply either the ClipID or OriginalFilename — not both. We also recommend that you please delete all other columns that are not listed above. They are not required, and will, unfortunately, cause errors in our system.

Here is an example of how your CSV should look like:

Screen_Shot_2018-07-13_at_21.28.15.png

Once your metadata is added to the .csv file, you can apply (upload) the .csv via the Apply CSV page.

Apply_CSV___2018-08-02_17-12-48.png


Make sure to chose the clips you want to target and check these options:

Apply_CSV___2018-08-02_17-15-53.png


Key Metadata

Remember clipid and originalfilename are key metadata, the data based on which our database recognizes a file and assigns respective data. It is very important to include only one Key Metadata. If you included both keys, the database will be confused and there will be no result.


Best Practices

General recommendation is to delete from your CSV file all of the columns and rows you are not planning to update and keep the file slim. This is to avoid errors by shifted columns/rows.

Keep a copy of your originally downloaded, unmodified CSV file saved in your computer in case your modifications are not recognized. In that case you can simply use the original file to restore data as they were initially.

When saving a modified CSV file, it is important to pay attention how it is saved. To save spreadsheet as CSV using OpenOffice:

Go to Menu > File/Save as type: Text CSV (.csv)

Click Keep Current Format

This will open up a small popup window asking for details. Verify that the file is being saved as following:

Character set: Unicode (UTF-8)

Field delimeter: , <- Comma

Text delimeter: " <- The normal quotation mark

There are many great formulas and simple tricks in Excel or OpenOffice spreadsheets that can save time. We suggest checking lynda.com for quick walkthroughs.

 

Looking to download a CSV file listing your existing files? Check out this guide here.

Still need help? Contact us

 

Was this article helpful?
4 out of 6 found this helpful
Have more questions? Submit a request

0 comments

Please sign in to leave a comment.