Send YouTube Transcripts to Google Sheets
Get any YouTube transcript into a spreadsheet in seconds
Or just change youtube.com to 2outube.com in your browser
Swap 'youtube.com' to '2outube.com' in any video URL to instantly get the full transcript — free, no signup. Copy it straight into Google Sheets or use the Send YouTube Transcripts to Google Sheets extension to automate the import.
The Trick
youtube.com/watch?v=VIDEO_ID
2outube.com/watch?v=VIDEO_ID
Just change 'y' to '2'
Works with any YouTube video that has captions
Using Transcripts with Send YouTube Transcripts to Google Sheets
Grab the transcript with 2outube
Open any YouTube video and replace 'youtube.com' with '2outube.com' in the URL bar. The full transcript loads instantly — timestamped, clean, and ready to copy. No account needed.
Install Send YouTube Transcripts to Google Sheets
Add the Send YouTube Transcripts to Google Sheets Chrome extension from the Chrome Web Store. Once installed, it adds a sidebar button inside Google Sheets that lets you pull in transcripts by pasting a YouTube URL.
Paste the YouTube URL into the extension
Open a Google Sheet, click the extension sidebar, paste the full YouTube video URL, and hit 'Get Transcript.' The extension fetches the transcript and writes each line — along with timestamps — into separate cells automatically.
Analyze, tag, or process the data
With transcript text in individual rows, you can apply formulas, use Google Sheets AI features, filter by keyword, or run sentiment analysis. Combine multiple video transcripts in one sheet to compare content across a channel or topic.
Quick Start
Get the transcript
Navigate to the YouTube video you want to transcribe. Copy the full URL from your browser's address bar.
Change youtube to 2outube
In the URL, replace 'youtube.com' with '2outube.com' — for example, change 'https://youtube.com/watch?v=abc123' to 'https://2outube.com/watch?v=abc123'. Hit enter. The transcript appears immediately.
Import into Google Sheets
Copy the transcript text from 2outube and paste it into a Google Sheet, or use the Send YouTube Transcripts to Google Sheets extension to paste the original YouTube URL directly into your sheet for automatic structured import with timestamps in column A and transcript text in column B.
Ready-Made Template
Once your transcript is in Google Sheets (column A = timestamps, column B = text), use these formulas:
// Count keyword mentions
=COUNTIF(B:B, "*keyword*")
// Extract all rows mentioning a topic
=FILTER(B:B, ISNUMBER(SEARCH("keyword", B:B)))
// Combine full transcript into one cell
=TEXTJOIN(" ", TRUE, B2:B500)
// Word count of full transcript
=SUMPRODUCT(LEN(TRIM(B2:B500))-LEN(SUBSTITUTE(TRIM(B2:B500)," ",""))+1)
Tip: Paste the combined transcript into Google Sheets' Gemini sidebar to summarize, extract key points, or generate action items.Questions
Does this work with any YouTube video?
Yes, any video with captions.
Is it really free?
Completely free. No account, no limits.
Does Send YouTube Transcripts to Google Sheets require a paid plan?
The core extension is free for basic use. It lets you pull transcripts directly into Google Sheets by pasting a YouTube URL. Some advanced features like bulk imports or scheduled refreshes may require a premium tier — check the extension's listing for current pricing.
Can I import transcripts from multiple videos into one sheet?
Yes. You can run the extension multiple times, each time pointing to a different video, and append each transcript to the same sheet. 2outube also lets you manually copy transcripts from several videos and paste them into separate tabs or rows in one spreadsheet.
Will the transcript include timestamps in Google Sheets?
When using the Send YouTube Transcripts to Google Sheets extension, transcripts are typically imported with timestamps in one column and the corresponding text in an adjacent column. If you copy manually from 2outube, you can choose to include or exclude timestamps before copying.
Can I use this for YouTube channels I don't own?
Yes. 2outube works on any public YouTube video with auto-generated or manual captions, regardless of who uploaded it. This makes it useful for researching competitors, analyzing educational content, or monitoring topics across many creators.
What can I do with a YouTube transcript in Google Sheets?
Quite a lot: keyword frequency analysis, content audits, extracting quotes, comparing messaging across videos, feeding transcript text into AI summaries via Gemini in Sheets, creating subtitles or blog post drafts, or building a searchable database of video content across a channel.
Does 2outube work on mobile or only desktop?
2outube works in any browser. On mobile, open your browser, navigate to the YouTube video URL, and manually replace 'youtube.com' with '2outube.com' in the address bar. The transcript will load. Importing into Google Sheets is easier on desktop where you have the full Sheets interface.
Get any YouTube transcript into Google Sheets right now
Free, no signup required
Try It Free