Download and sort list of all videos from a youtube channel with youtube-dl

Question

I want to download a list of all videos of a youtube channel and sort it by duration. Here is what I tried with youtube-dl resp. yt-dlp:

yt-dlp --skip-download "url_to_channel" --get-duration --get-title > list

Then something like cat list | sed '$!N;s/\n/ /g' | sort. However this doesn't work since the duration is printed second (and sort -k2 doesn't help since the title contains spaces).

At the end of the day I want to get also the urls and titles and then pipe it to a html file (or latex -> pdf) to get a list with clickable urls and thumbnails (that's not the content of this question, but you may have this in mind when you write an answer; I just want to solve the simple case above first).

Edit

For example:

yt-dlp --skip-download "https://www.youtube.com/user/emacsrocks/videos" --get-duration --get-title > list_test

results in

cat list_test

Parens of the Dead Live - Preparing for a new game, bonus stream, live on Twitch
1:06:45
Parens of the Dead Live - Improving the code 3 years later, live on Twitch
1:55:55
Emacs Rocks! Episode 17: Magit
2:39
Emacs Rocks! Episode 16: Dired
1:35
Parens of the Dead - Episode 8: The Hour of Reckoning
9:52
Parens of the Dead - Episode 7: Eaten by Zombies
3:50
Parens of the Dead - Episode 6: Quickly, hide!
9:44
Parens of the Dead - Episode 5: Re-animated
9:09
Parens of the Dead - Episode 4: Waking the Dead
4:59
Parens of the Dead - Episode 3: What Lies Beneath
9:27
Parens of the Dead - Episode 2: Frontal Assault
8:02
Parens of the Dead - Episode 1: Lying in the Ground
11:33
Emacs Rocks! Episode 15: restclient-mode
2:24
Emacs Rocks at WebRebels! Part 05: more js2-refactor
55
Emacs Rocks at WebRebels! Part 04: more js2-refactor
1:58
Emacs Rocks at WebRebels! Part 03: js2-refactor
59
Emacs Rocks at WebRebels! Part 02: multiple-cursors
41
Emacs Rocks at WebRebels! Part 01: Jumping to the next slide
2:19
Emacs Rocks! Episode 14: Paredit
3:25
Extending Emacs Rocks! Episode 08
8:10
Extending Emacs Rocks! Episode 07
11:06
Emacs Rocks! Episode 13: multiple-cursors
3:56
Emacs Rocks! Episode 12: Working with HTML
1:54
Extending Emacs Rocks! Episode 06
9:26
Emacs Rocks! Episode 11: swank-js
4:35
Extending Emacs Rocks! Episode 05
9:18
Extending Emacs Rocks! Episode 04
10:44
Extending Emacs Rocks! Episode 03
10:32
Extending Emacs Rocks! Episode 01
11:15
Extending Emacs Rocks! Episode 02
8:00
Emacs Rocks! Live at WebRebels
18:18
Emacs Rocks! Episode 10: Jumping around
2:07
Emacs Rocks! Episode 09: expand-region
2:39
Emacs Rocks! Episode 08: mark-multiple
1:30
Emacs Rocks! Episode 07: Mind. Exploded.
1:30
Emacs Rocks! Episode 06: Yeah! Snippets!
1:41
Emacs Rocks! Episode 05: Macros in style
1:31
Emacs Rocks! Episode 04: A rebind controversy
2:32
Emacs Rocks! Episode 03: A vimgolf albatross
2:15
Emacs Rocks! Episode 02: A vimgolf eagle
3:15
Emacs Rocks! Episode 01: From var to this
2:47

Answer 1

You could ask youtube-dl to output the json data, then process it with jq (you will have access to all the fields, not just the ones with get-... flags).

This command:

youtube-dl --dump-json "https://www.youtube.com/user/emacsrocks/videos" | jq -r '[.duration,.title]|@csv'

will output this:

4005,"Parens of the Dead Live - Preparing for a new game, bonus stream, live on Twitch"
6955,"Parens of the Dead Live - Improving the code 3 years later, live on Twitch"
159,"Emacs Rocks! Episode 17: Magit"
95,"Emacs Rocks! Episode 16: Dired"
592,"Parens of the Dead - Episode 8: The Hour of Reckoning"
230,"Parens of the Dead - Episode 7: Eaten by Zombies"
...
91,"Emacs Rocks! Episode 05: Macros in style"
152,"Emacs Rocks! Episode 04: A rebind controversy"
135,"Emacs Rocks! Episode 03: A vimgolf albatross"
195,"Emacs Rocks! Episode 02: A vimgolf eagle"
167,"Emacs Rocks! Episode 01: From var to this"

You can then use, for example, sort.