Excel metadata

Overview

Roku only accepts Excel metadata delivered in one of the approved templates below. The same workbook rules apply to all three templates. For individual field requirements, use the reference for your content type:

• Roku Excel: Film
• Roku Excel: TV
• Roku Excel: Clip

---

Templates

---

Template Completion Rules

You must complete all required fields before submitting the Roku Excel metadata template.

• Row 2 of each template identifies required cells and explains any special formatting. Refer to these hints as you complete the template.
• Do not delete the legend/hint row (row 2).

---

Formatting Requirements

• Dates must use YYYY-MM-DD format. If Excel changes the value automatically, set the cell format to "Text".
• File names must not contain special characters or spaces.

---

Workbook Structure Rules

• Do not link to external data or other Excel workbooks. All data must be included in the workbook delivered to Roku.
• Do not add additional sheets to the workbook.
• Do not add additional columns to the workbook.
• Any formulas used must be converted to plain text before submission. Live formulas cause rejected deliveries and processing delays or failures.

---

Data Population Rules

• Do not supply a value of "N/A" or "n/a" anywhere in the workbook.
  • Required cells must contain valid data.
  • Optional cells may be left blank.

---

Multiple Entries and Volume Limits

You may include multiple entries of the same content type in one workbook, such as several movies in a Film workbook or several episodes in a TV workbook. Each content type has its own template; a workbook is not intended to combine Film, TV, and Clip rows.

• Each row represents one episode, movie, or clip.
• Do not leave a blank row between entries. Roku's system stops processing at the first empty row. Later rows will not be processed, and no warning will be issued.
• Do not include more than 900 rows in a single sheet.

---

File Format and Export

Roku accepts .xlsx and .csv. The .xls format is not supported.

• If exporting from Microsoft Excel, save as .xlsx.
• If your spreadsheet program cannot produce a valid .xlsx file, export as .csv.