Microsoft Excel Tutorial: Quickly download YouTube Thumbnails into Excel.
TubeBuddy Link: https://www.Tubebuddy.com/pricing?a=mrexcel
Formula for Edit Hyperlink: =HYPERLINK(“https://studio.youtube.com/video/“&B2&”/edit”,”Edit”)
Formula to Wrap Thumbnails into 9 columns: =WRAPROWS(FILTER(F2:F2417,G2:G2417=1),9)
Welcome to episode 2634 of MrExcel’s Net Cast! In this video, we will be exploring two new Excel functions that will help us quickly review over 2400 YouTube thumbnails. As we approach the 25th anniversary of MrExcel, I am grateful for the opportunity to connect with friends and followers from around the world through 67 books, thousands of articles, over 5 million posts on our message board, and 2400 videos on YouTube. If you enjoy this video, please click the like button below to help us reach more people. Thank you for your support!
As we prepare for November 21st, 2023, we have been updating all of our videos with new descriptions, a complete table of contents, and new thumbnails. However, with over 2400 videos, it can be challenging to ensure that all thumbnails have been updated. That’s where these two new Excel functions come in. The IMAGE function allows us to insert a web image into a cell, while the WRAPROWS function helps us arrange a long vertical list of 2400 images into a rectangular range. These functions were unimaginable back in 1998 when I wrote my first article, but now they make it possible for us to quickly review all of our YouTube thumbnails.
If you have a YouTube channel and want to try this out for yourself, make sure you have the IMAGE function by grabbing an image from the web and pasting it into Excel. Then, use the function =IMAGE(C10) to insert the image into a cell. You may need to increase the row height to see the image clearly. This feature is currently only available on the Microsoft 365 Monthly channel, but you can try joining Office Insiders or using the consumer version of Excel at home for a better chance of having the new IMAGE function.
Now, let’s take a look at how we can use these functions to review all of our YouTube thumbnails at once. Using a tool from TubeBuddy, we can export a backup of our entire channel, including the thumbnail URLs. After cleaning up the data and using the IMAGE function to display the thumbnails, we can easily identify any old style thumbnails that need to be updated. With the help of the FILTER function, we can quickly view and fix these thumbnails. However, there is one “gotcha” to be aware of – once an image has been cached by Microsoft, it will not recalculate even if we update the thumbnail. But with a little trust, we can confidently move forward and ensure that all of our thumbnails are up to date.
Thank you for joining me for this Net Cast. If you found this video helpful, please consider subscribing to our channel and ringing the bell to be notified of future videos. And as always, feel free to leave any questions or comments down below. See you next time!
Buy Bill Jelen’s latest Excel book: https://www.mrexcel.com/products/latest/
You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/
Table of Contents
(0:00) Review 2000 YouTube Thumbnails in Excel
(0:12) 25 years at MrExcel.com
(0:29) Inspirational Quote
(0:51) New IMAGE function in Excel
(2:05) Tedious to review at YouTube Studio
(2:15) TubeBuddy Backup of Channel
(2:50) Opening CSV in Excel
(3:10) Video IDs that converted to formulas
(3:45) Column J has thumbnail URL
(4:00) Using IMAGE function with YouTube thumbnail URL
(4:38) Double-click fill handle to copy formula
(4:56) Marking ones to fix
(5:11) Wrap videos into 9 columns & filter
(6:02) Filtering to videos to fix
(6:12) Adding Excel Hyperlink to edit video
(6:41) After fixing thumbnail, it won’t update in Excel
(7:20) Clicking Like really helps the algorithm
#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial #youtubetips #tubebuddy
This video answers these common search terms:
how to quickly analyze youtube thumbnails in excel
microsoft excel image function tutorial
tubebuddy backup and export for youtube channel
analyzing youtube video data with excel
new excel functions image filter and wraprows
download 2000 images to excel for sorting and filtering
excel wraprows and filter functions tutorial
youtube studio thumbnail update process
excel thumbnail review tutorial
mrexcel 25th anniversary video update
fixing and updating youtube thumbnails with microsoft excel