To export a channel’s videos with views and subscriber count, use the YouTube Data API through Google Apps Script: retrieve the channel’s uploads playlist, list every playlist page, fetch statistics for those video IDs, and write the joined results to Google Sheets. This produces an inventory of videos available to the API—not a guaranteed list of private or otherwise inaccessible uploads.
What the spreadsheet can include
A practical export can have one row per available uploaded video, with its title, video ID, and view count, plus the channel’s subscriber count in a separate summary cell or column. The subscriber figure belongs to the channel, not to individual videos.
As an Amazon Associate I earn from qualifying purchases.
For other channels, the export is limited to public data. An authenticated owner may be able to access private information for their own channel, subject to authorization and API permissions. The channel’s videoCount represents public videos, even when requested by the owner; it is not a count of every private upload. See Google’s channel resource reference and API overview.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Why use the uploads playlist instead of search
Each channel resource includes an uploads playlist ID in contentDetails.relatedPlaylists.uploads. Listing that playlist and following its continuation tokens is the documented way to enumerate uploads. A search can help discover videos, but it is not the same as walking the channel’s uploads inventory; search results are not themselves persistent video resources. Google describes the uploads-playlist workflow in its video implementation guide.
#1 Best Overall
- CRISP CLARITY: This 23.8″ Philips V line monitor delivers crisp Full HD 1920x1080 visuals. Enjoy movies, shows and videos with remarkable detail
- INCREDIBLE CONTRAST: The VA panel produces brighter whites and deeper blacks. You get true-to-life images and more gradients with 16.7 million colors
- THE PERFECT VIEW: The 178/178 degree extra wide viewing angle prevents the shifting of colors when viewed from an offset angle, so you always get consistent colors
- WORK SEAMLESSLY: This sleek monitor is virtually bezel-free on three sides, so the screen looks even bigger for the viewer. This minimalistic design also allows for seamless multi-monitor setups that enhance your workflow and boost productivity
- A BETTER READING EXPERIENCE: For busy office workers, EasyRead mode provides a more paper-like experience for when viewing lengthy documents
Build the export in Google Sheets
- Create the Sheet and open Apps Script. In Google Sheets, choose Extensions > Apps Script. Google’s Apps Script quickstart demonstrates connecting YouTube data to a spreadsheet.
- Enable the YouTube Data API advanced service. In the Apps Script editor, enable the YouTube Data API advanced service, then complete any required Google Cloud project setup shown by the editor.
- Authorize the script. Run it under the Google account whose permissions should apply, and approve the requested access. For public-channel exports, request public data; access to private channel information requires appropriate owner authorization and API permissions.
- Look up the channel and uploads playlist. Call
channels.listfor the target channel and request the fields needed for the export, including its uploads playlist ID and subscriber information. ReadhiddenSubscriberCountas well asstatistics.subscriberCountso the sheet can distinguish a hidden count from a numeric value. - Enumerate the playlist completely. Call
playlistItems.listfor the uploads playlist. After each response, check for a continuation token and request the next page until no token remains. Collect each video ID and its playlist-item details, such as the video title. - Fetch statistics and join by video ID. Request the video resources with the
statisticspart, batching IDs within the method’s limits. Match each response to its playlist row by video ID—not by row order—and add the view count to the spreadsheet. - Write the results and date the snapshot. Create a header row such as
Video ID,Title, andViews, then write the channel subscriber count and export date in clearly labeled cells. The Apps Script quickstart’s sample writes channel ID, title, and view count; the per-video inventory and subscriber field require extending that example.
Google documents pagination metadata for videos.list; its current reference lists a quota cost of one unit per call. The API also applies method limits and quota constraints, so an export with many videos may need several requests and should handle API errors rather than assuming one call is enough.
Read the counts with their limits in mind
Subscriber count is rounded
YouTube rounds the public subscriberCount down to three significant figures. It is therefore an approximate displayed count, not an exact subscriber total. If hiddenSubscriberCount is true, the count is not publicly visible; record that status instead of treating a missing number as zero. These fields are defined in the channel resource reference.
Rank #2
- CRISP CLARITY: This 22 inch class (21.5″ viewable) Philips V line monitor delivers crisp Full HD 1920x1080 visuals. Enjoy movies, shows and videos with remarkable detail
- 100HZ FAST REFRESH RATE: 100Hz brings your favorite movies and video games to life. Stream, binge, and play effortlessly
- SMOOTH ACTION WITH ADAPTIVE-SYNC: Adaptive-Sync technology ensures fluid action sequences and rapid response time. Every frame will be rendered smoothly with crystal clarity and without stutter
- INCREDIBLE CONTRAST: The VA panel produces brighter whites and deeper blacks. You get true-to-life images and more gradients with 16.7 million colors
- THE PERFECT VIEW: The 178/178 degree extra wide viewing angle prevents the shifting of colors when viewed from an offset angle, so you always get consistent colors
Views need an export date
Starting August 24, 2026, YouTube’s documented viewCount definition for all formats counts a view when a video begins to play, including autoplay, pointer hover, and click or tap to play. Because the counting definition can change over time, record the export date and avoid comparing totals across dates as though their definitions were necessarily identical. See the channel reference.
Do these 3 things before closing this tab:
1Clear out junk files and repair common Windows errors2Fix the driver behind crashes, sound loss and screen glitches3Repair Windows errors before they cause bigger problemsQuick Recap
Best Value
- 【INTEGRATED SPEAKERS】Whether you're at work or in the midst of an intense gaming session, our built-in speakers provide rich and seamless audio, all while keeping your desk clutter-free.
- 【EASY ON THE EYES】 Protect your eyes and enhance your comfort with Blue-Light Shift technology. This feature reduces harmful blue light emissions from your screen, helping to alleviate eye strain during long hours of use and promoting healthier viewing habits.
- 【WIDEN YOUR PERSPECTIVE】Our sleek minimal bezel design ensures undivided attention. The nearly bezel-free display seamlessly connects in a dual monitor arrangement, delivering an unobstructed view that lets you focus on more at once, completely distraction-free.
Rank #4
- CURVED FOR ENHANCED ENGAGEMENT: An immersive viewing experience with a curved monitor that wraps more closely around your field of vision; It creates a wider view, enhancing depth perception and minimizing peripheral distraction
- SMOOTH PERFORMANCE FOR SEAMLESS CONTENT: Stay in the action when playing games, watching videos, or working on creative projects; The 100Hz refresh rate reduces lag and motion blur so you don't miss a thing in fast-paced moments¹
- MORE GAMING POWER: Gain the edge with optimizable game settings; Color and image contrast can be adjusted to see scenes more vividly and spot enemies hiding in the dark; Game Mode adjusts any game to fill the screen so you can view every detail²
- KEEP IT EASY ON THE EYES: Care for your eyes and stay comfortable, even during long sessions; Advanced eye comfort technology certified by TÜV reduces eye strain by minimizing blue light and reducing irritating screen flicker²
- INCREASED VERSATILITY: Connect to more; Plug devices straight into your monitor for increased flexibility, making your computing environment even more convenient
Rank #3
- Clear visuals. Fluid motion: A 144Hz refresh rate and 1ms MPRT deliver smooth, tear‑free motion across work, gaming, and streaming for clearer, more fluid viewing.
- Eye comfort: TÜV Rheinland 3‑star* certification reduces harmful blue light while preserving stunning color quality without compromise. *TÜV Rheinland 3-star eye comfort certification.
- Wide viewing angle: Get consistent views across a wide 178° /178° viewing angle.
- In-Plane Switching (IPS): See excellent color accuracy and consistency across wide viewing angles with In-plane Switching (IPS) technology.
- Ultra-thin bezels: Maximize your viewing experience with thin bezels.
What this method does—and does not—cover
- It is repeatable: you can rerun the script to refresh the sheet, provided it repeats the playlist pagination and video-statistics lookup.
- It is not a private-video bypass: the rows represent uploads accessible to the requesting account under YouTube’s API rules.
- It is not the same as an Analytics report: this workflow inventories video resources and their available statistics. Owner-facing reporting uses a different API context; see Google’s YouTube Analytics API reporting documentation.
- It is more complete than manual copying for a large channel: following every playlist page avoids relying on only the videos currently visible in a page or on a single search result set.
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
