← All guides · Open the private viewer
How to Export YouTube Liked Videos to CSV (Excel & Google Sheets)
This page is about the spreadsheet result—not Takeout setup. For product picks and download steps, use Google Takeout for YouTube likes. If the in-app playlist stopped listing older likes, see the 5,000 limit and find old likes guides first.
1. What's in Takeout's Liked videos.csv (and what's missing)
Inside a typical Takeout archive, the playlist file is often at `Takeout/YouTube and YouTube Music/playlists/Liked videos.csv`. Community documentation of that file shows a two-column header: `Video Id,Time Added` (timestamps in UTC). It does not include video titles or channel names.
Missing from that raw file: title, channel, and a ready-made watch URL. You can still build a URL yourself as `https://www.youtube.com/watch?v=` plus the Video Id. Titles and channels come from the My Activity (YouTube) export—JSON or HTML entries whose titles start with a “Liked …” verb (including localized forms).
If you open Liked videos.csv alone in Excel, you get IDs and times only. That is expected—not a broken download. Pair it with My Activity when you want a human-readable spreadsheet.
| Column | What it contains |
|---|---|
| Video Id | 11-character YouTube video ID |
| Time Added | When the video was added to Liked videos (UTC) |
2. Raw CSV vs LikesR CSV
LikesR merges playlist CSV rows with My Activity (and other supported sources) in your browser, then writes one spreadsheet-friendly file. The export starts with a UTF-8 byte-order mark (BOM) so Excel keeps non-English titles readable, and cells use RFC 4180 quoting with formula-injection escaping for values that begin with `=`, `+`, `-`, or `@`.
Column meanings in the LikesR file: `index` is the row order in the current view; `videoId` and `url` identify the watch page; `title`, `channelName`, and `channelUrl` come from imported activity when available; `likedAt` is the like timestamp; `sources` lists which import files contributed (joined with `|`); `status` is a local availability hint such as ok, unavailable, or unknown.
These are the actual header names written by LikesR’s CSV exporter—not invented labels:
| Detail | Takeout Liked videos.csv | LikesR CSV export |
|---|---|---|
| Columns | Video Id, Time Added | index, videoId, url, title, channelName, channelUrl, likedAt, sources, status |
| Titles / channels | Not included | Filled when present in My Activity (or other imported sources) |
| Watch URL | Not included (build from Video Id) | url column |
| Encoding / quoting | Plain CSV from Google | UTF-8 with BOM; RFC 4180 quoted fields |
| Processing | Downloaded from Google | Built on your device in the browser |
3. Step by step
Keep Takeout creation on the dedicated guide; here you only open the archive and leave with a spreadsheet. LikesR does not use the YouTube API or ask you to log in with Google.
- Export My Activity → YouTube (and playlists if you want Liked videos.csv) via Google Takeout, then download every archive part.
- On the LikesR homepage, drop the ZIP (or .json / .html / .csv). Duplicate video IDs are merged. Search, filter by year, or keep likes beyond the newest 5,000 before you export.
- Choose Export CSV. Open the file in Excel or Google Sheets. For searchable browsing without a spreadsheet, see search liked videos.
4. Open in Excel
Double-clicking the download often works because of the UTF-8 BOM. If titles look garbled or columns collapse into one, use Data → From Text/CSV, pick UTF-8, and confirm the comma delimiter.
Treat `likedAt` / Takeout Time Added values as UTC. LikesR quotes fields so commas inside titles do not break columns, and prefixes risky leading characters so Excel does not treat a title as a formula.
After the sheet opens, freeze the header row and sort or filter by `channelName` or `likedAt` like any other table. You can delete columns you do not need; the file is yours once downloaded.
5. Open in Google Sheets
In Google Sheets, choose File → Import → Upload, select the CSV, and import. Sheets usually detects UTF-8 and commas automatically; if a column looks wrong, re-import and set the separator to comma.
After import you can sort by `likedAt`, filter by `channelName`, or keep only rows whose `sources` include playlist or activity—whatever matches the backup you want.
Sheets is useful when you want to share a filtered view with yourself across devices. The original Takeout archives stay local; only the CSV you choose to upload to Drive leaves your machine.
6. More than 5,000 likes?
YouTube’s Liked videos playlist displays at most 5,000 videos (YouTube Help). A Takeout export may include older likes than that playlist UI shows; whether your Liked videos.csv has more than 5,000 rows is not verified here.
For why the playlist stops and how to hunt older likes, read YouTube liked videos 5,000 limit and how to find old liked videos.
FAQ
Why does my Liked videos.csv have no titles?
Takeout’s Liked videos.csv is documented with only Video Id and Time Added (UTC). Titles and channels come from My Activity (YouTube) JSON or HTML “Liked …” entries. Export both, then open them in LikesR to produce a CSV that includes title and channelName when those fields exist in the import.
Can I export YouTube likes to Excel without an extension?
Yes. Download your Google Takeout archive yourself, open it in LikesR in the browser (no extension and no Google sign-in to LikesR), then choose Export CSV and open the file in Excel or Google Sheets.
Does the export include likes older than 5,000?
It may include older likes than the playlist UI shows, depending on what Google still has in My Activity and your Takeout. The playlist display cap is 5,000; row counts beyond that in Liked videos.csv are not verified here.
Is my data uploaded?
No. Parsing and CSV export run on your device in the browser. Optional metadata lookups (for example oEmbed) are separate, disclosed, and need your consent.
Privacy note
Your files are processed on your device. Optional metadata lookups are separate, disclosed, and require explicit consent. Questions: gdxingchen@gmail.com · FAQ.