YouTube to Excel: one row for every point in the video
When you review a batch of videos, a sheet beats a stack of summaries. You can sort, filter and paste rows into the tracker you already keep.
BlogPen turns the note into a workbook. Each key point becomes a row with the time it was said and the section it belongs to, and the whole sentence stays in the cell.
A real example
NASA Science · ScienceCasts: The Mystery of Nanoflares · 4:22 · Public domain: US government work (NASA)
TL;DR from the note
- Nanoflares are powerful explosions that occur on the Sun almost continuously, despite their small name.0:30
- The Sun’s million-degree corona remains a major astrophysical mystery, and nanoflares may help explain its heat.1:57
- NuSTAR may reveal whether nanoflares heat the corona by observing their X-ray flickers during Solar Minimum.3:25
| Time | Section | Key point |
|---|---|---|
| 0:03 | Nanoflares and Their Energy | Remember that “nano” does not mean these solar explosions are weak. |
| 0:03 | Nanoflares and Their Energy | A typical nanoflare releases energy comparable to 240 megatons of TNT. |
| 0:03 | Nanoflares and Their Energy | Unlike large flares, nanoflares occur almost continuously on the sun. |
| 0:03 | Nanoflares and Their Energy | Look for nanoflares as small brightenings at extreme ultraviolet and X-ray wavelengths. |
| 1:03 | The Corona Heating Mystery | Remember that the Sun’s outer atmosphere is far hotter than its visible surface, despite being farther away. |
| 1:03 | The Corona Heating Mystery | The corona reaches a million degrees—almost 200 times hotter than the furnace below. |
| 1:03 | The Corona Heating Mystery | Recognize that the cause of the corona’s extreme heat remains an unresolved problem in astrophysics. |
| 2:00 | NuSTAR Investigates Nanoflares | Nanoflares may help keep the corona hot because their activity appears steady through the solar cycle. |
| 2:00 | NuSTAR Investigates Nanoflares | NuSTAR’s sensitivity and resolution make it well suited to detecting nanoflares’ telltale X-ray flickers. |
| 2:00 | NuSTAR Investigates Nanoflares | Solar Minimum should reduce magnetic clutter, allowing NuSTAR to survey the sun and gather data on nanoflares. |
Written by BlogPen (note:v1) on 2026-11-05 and shown unedited. Times open the video at that second.
What you get
- A Note sheet with Time, Section and Key point columns
- Wrapped, top-aligned cells so long points stay readable
- A Summary sheet with sections, points and the time span
- A native Excel bar chart of minutes per section
- A real .xlsx file that opens in Excel, Numbers and Google Sheets
How it works
- Create a note from the YouTube link.
- Open the Excel tab to see the sheet exactly as it will download.
- Download the .xlsx and merge the rows into your own workbook.
Good to know
Is the chart a picture or a real chart?
A real chart. It is an Excel bar chart bound to the Summary sheet, so it updates if you edit the minutes.
Can I get one row per moment instead of per point?
The sheet lists points by section. Key moments live in the note; you can add any moment to the sheet from the note view.
Does Excel export need a plan?
Previewing the sheet is free. Downloading files is part of a plan.