How do I export search results, choose columns and create video or channel links?

Q: How do I export search results, choose columns and create video or channel links?

Run a subtitle or metadata search and click Export . Choose CSV, Compact CSV, JSONL or ZIP, then select the columns you want, such as video ID, title, channel ID, channel name, upload date or view count. Stored descriptions are included only with patron benefits, and full subtitles can be selected where available. To list a channel's known videos without matching title words, select the channel in metadata search, leave the title query empty and export the results. To export only videos whose captions contain particular words, use subtitle search with the channel selected. Exports contain IDs rather than ready-made links: For a video URL, append its video ID to https://www.youtube.com/watch?v= . For a channel URL, append its channel ID to https://www.youtube.com/channel/ . To produce a channel list, select the channel ID and name columns and deselect other columns if you do not need them. An export has one row per matching video, so the same channel can appear repeatedly; remove duplicate channel IDs in a spreadsheet if you need unique links. Row limits apply to each export: Without patron benefits: up to 60 rows from subtitle search or 100 rows from metadata search. With patron benefits: up to 10,000 rows, or 2,500 when full subtitles are included. Subtitle search also offers a Subtitle Timestamps Export option. Use Export embed urls to create links to matching moments on YouTube.

Question

Accepted Answer

Run a subtitle or metadata search and click Export. Choose CSV, Compact CSV, JSONL or ZIP, then select the columns you want, such as video ID, title, channel ID, channel name, upload date or view count. Stored descriptions are included only with patron benefits, and full subtitles can be selected where available.

To list a channel's known videos without matching title words, select the channel in metadata search, leave the title query empty and export the results. To export only videos whose captions contain particular words, use subtitle search with the channel selected.

Exports contain IDs rather than ready-made links:

For a video URL, append its video ID to https://www.youtube.com/watch?v=.
For a channel URL, append its channel ID to https://www.youtube.com/channel/.

To produce a channel list, select the channel ID and name columns and deselect other columns if you do not need them. An export has one row per matching video, so the same channel can appear repeatedly; remove duplicate channel IDs in a spreadsheet if you need unique links.

Row limits apply to each export:

Without patron benefits: up to 60 rows from subtitle search or 100 rows from metadata search.
With patron benefits: up to 10,000 rows, or 2,500 when full subtitles are included.

Subtitle search also offers a Subtitle Timestamps Export option. Use Export embed urls to create links to matching moments on YouTube.