Send YouTube Transcripts to Microsoft Excel
Get any YouTube transcript into Excel in seconds
Or just change youtube.com to 2outube.com in your browser
Change youtube.com to 2outube.com in any video URL to instantly get the full transcript. Copy it and paste directly into Microsoft Excel for analysis, tagging, timestamping, or content repurposing — no tools, no signup required.
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 Microsoft Excel
Grab the YouTube video URL
Find the YouTube video you want to analyze or reference. Copy the full URL from your browser address bar — it will look like youtube.com/watch?v=VIDEO_ID.
Swap to 2outube.com
In the URL, change 'youtube.com' to '2outube.com'. Hit enter. The full transcript appears on the page — timestamped, clean, and ready to copy.
Copy the transcript text
Select all the transcript text on the 2outube page. You can grab timestamps alongside the text if you want time-coded rows in Excel, or just the plain text if you want a single column of content.
Paste into Microsoft Excel
Open your Excel workbook and paste into a cell. Use 'Paste Special → Text' to keep it clean. For structured data, paste into column A and use Excel's 'Text to Columns' tool to split timestamps from spoken content into separate columns. From there, apply filters, tags, COUNTIF formulas, or conditional formatting to analyze the content at scale.
Quick Start
Get the transcript
Navigate to the YouTube video you want. Copy the URL from your browser.
Change youtube to 2outube
In the URL bar, replace 'youtube.com' with '2outube.com' and press Enter. The transcript loads immediately — no login, no waiting.
Paste into Microsoft Excel
Copy the transcript text and paste it into any Excel cell. Use 'Text to Columns' to split timestamps from dialogue into separate columns for structured analysis.
Ready-Made Template
Column A: Timestamp (e.g. 00:01:23)
Column B: Speaker (optional — fill manually or with a formula)
Column C: Transcript Text
Column D: Topic Tag (manual or AI-assisted)
Column E: Key Quote? (TRUE/FALSE)
Column F: Notes
--- PASTE INSTRUCTIONS ---
1. Copy full transcript from 2outube.com
2. Paste into cell A1 using Paste Special > Text
3. Select Column A > Data > Text to Columns > Delimited > Space
(This splits timestamps like '00:01:23' into their own column)
4. Move text content to Column C
5. Add headers in Row 1: Timestamp | Speaker | Text | Tag | Key Quote | Notes
6. Use CTRL+T to convert to a Table for easy filtering
--- USEFUL FORMULAS ---
Count mentions of a keyword:
=COUNTIF(C:C,"*keyword*")
Find rows containing a phrase:
=IFERROR(SEARCH("your phrase",C2),"")
Word count per row:
=LEN(TRIM(C2))-LEN(SUBSTITUTE(TRIM(C2)," ",""))+1Questions
Does this work with any YouTube video?
Yes, any video with captions.
Is it really free?
Completely free. No account, no limits.
How do I get the transcript into Excel without it becoming one giant block of text?
Paste into column A using Paste Special → Text. Then select the column and go to Data → Text to Columns. Choose 'Delimited' and use a newline or space delimiter to split timestamps from spoken text into separate columns. This gives you a clean, structured spreadsheet.
Can I get timestamps alongside the transcript in Excel?
Yes. The 2outube transcript includes timestamps with each line. When you copy and paste the full transcript, timestamps come along. Use Excel's Text to Columns feature to separate the timestamp column from the dialogue column for clean, time-coded rows.
Can I analyze multiple YouTube videos in one Excel workbook?
Absolutely. Create a separate sheet tab for each video transcript, then use a summary sheet to pull data across tabs with formulas like COUNTIF or VLOOKUP. This is useful for comparing topics, keyword frequency, or content themes across a channel or playlist.
What can I actually do with a YouTube transcript in Excel?
Quite a lot: keyword frequency analysis with COUNTIF, topic tagging using conditional formatting, quote extraction, content repurposing planning, SEO research from spoken content, competitive analysis of a competitor's videos, and building training datasets. Excel's table and filter tools make large transcripts easy to navigate.
Do I need a Microsoft 365 subscription to do this?
No. The copy-paste workflow works with any version of Excel, including older desktop versions and Excel Online (free with a Microsoft account). The transcript is just plain text — no special import plugin or subscription required.
What if the YouTube video doesn't have captions?
2outube works with any video that has captions enabled — either auto-generated by YouTube or manually uploaded by the creator. If a video has no captions at all, no transcript will be available. Most videos published in English do have auto-generated captions.
Get any YouTube transcript into Excel right now
Free, no signup required
Try It Free