Make a Spreadsheet From Someone Else's YouTube Playlist
You don't need to own a playlist, copy it, or ask permission to turn its public data into a spreadsheet. Here's the difference between reading it and copying it.
Updated 26 September 2026 · 6 min readA friend sends you a playlist link, or you find one built by someone you follow, and what you actually want is a portable list — the titles, the channels, the links — not the playlist sitting on YouTube's site where it's hard to search or take notes on. You don't need to own the playlist for that, and you don't need to copy it to your own channel either.
This guide covers the real difference between exporting and copying a playlist, what data you actually get when the playlist isn't yours, why it only works for public and unlisted playlists, and the kinds of research and reference use cases this is built for.
Exporting is not copying
These sound similar but are two different operations. Exporting reads a playlist's public data and writes it into a spreadsheet — nothing on YouTube changes, and nothing is added to your own account. It's the same kind of access as opening the playlist page in a browser, just returned as structured data instead of a scrollable feed.
Copying is different: it's a write action that rebuilds the playlist as a brand-new one on your own channel, video for video. That needs your explicit permission grant to YouTube because it's creating something in your account, not just reading someone else's.
If you're not sure which one you need, ask what changes
What data you actually get
Paste the playlist URL
The tool reads what's publicly visible
Choose your format
Nothing changes on the source
Public and unlisted only — never private
This only works because the data is public in the first place. A public or unlisted playlist can be read by anyone with the link, which is exactly what an export does. A playlist someone else has set to private is a different situation entirely — it simply isn't visible outside their own account, and no export tool can read data YouTube doesn't expose.
| Playlist privacy | Can you export it by pasting the URL? |
|---|---|
| Public | Yes — anyone with the link can read it. |
| Unlisted | Yes, if you have the link — it's not searchable but is readable by URL. |
| Private, owned by someone else | No — not visible outside their account under any circumstances. |
| Private, owned by you | Yes, but by connecting your own YouTube account (read-only), not by pasting a URL. |
What this is actually used for
- Saving a friend's shared playlist as a reference
Turn a link someone sent you into a list you can actually search or annotate later, instead of re-opening the link each time.
- Auditing an influencer's curated playlist
See exactly what's in a publicly curated list — every title, channel and link — without manually noting each one down.
- Building a spreadsheet from a course syllabus playlist
Convert a public video-course playlist into a reference sheet with titles and links you can check off as you go.
How MyFreshTools Helps
What the tool does
YouTube Playlist Export turns any playlist's URL into a CSV, Excel, JSON, Markdown, HTML, Text, XML or SQL file with title, channel, duration, view/like/comment counts, dates, tags, description and link for every video — regardless of who owns the playlist, as long as it's public or unlisted.
Who it's for
- Anyone saving a playlist a friend or colleague shared, for their own reference.
- Researchers reviewing an influencer's or brand's public curated playlist.
- Students or self-learners turning a course playlist into a checklist.
How to use it
- Paste the public or unlisted playlist URL — no login or connection to the owner's account.
- Choose a format and download the spreadsheet.
Requirements and limits
- A free MyFreshTools account. No card, free credits on signup.
- 1 credit per 1,000 videos exported (most playlists are 1 credit).
- Free exports return part of a long playlist and show the count pulled against the total; paid plans return every video.
- Works only on public or unlisted playlists — a private playlist someone else owns can't be read from a pasted URL at all.
- This only reads data; it does not add the playlist to your own account. For that, use Playlist Copier, which needs a write permission grant.
Frequently asked questions
No — exporting is read-only. It reads publicly available data the same way opening the playlist page in a browser does; nothing is copied to your account and the source playlist is never changed.
No. Exporting reads the playlist's data into a spreadsheet and touches nothing on YouTube. Copying is a write action that rebuilds the playlist as a new one on your own channel — that needs a separate tool with a write permission grant.
Only if they've set it to public or unlisted. A playlist someone else owns and kept private can't be read from a pasted URL at all — that restriction is on YouTube's side, not the export tool's.
The same fields as any public playlist: title, channel, duration, view/like/comment counts, publish and added dates, tags, description and a link — whatever YouTube shows publicly for that playlist and its videos.
That's a copy, not an export, and it's a different tool: Playlist Copier rebuilds a public playlist on your own channel, video for video, using a write permission grant. The source playlist is only read, never altered.
The takeaway
You don't need to own a playlist, or copy it, to get its data as a spreadsheet — reading a public or unlisted playlist's titles, channels and links is a one-paste export with no permission needed and nothing changed on the source. Copying the playlist itself onto your own channel is a separate, deliberate action with its own tool.