To see all comment threads in a video, you use below URL pattern. You can use a simple GET request (ie if you paste this URL in a browser or web extract tools like Power Query or Excel’s WEBSERVICE, it will work) to access YouTube Data API ( ref). If you want to know the behind scenes for this little extractor, read on. How to get YouTube comments with Power Query? Repeat steps 3 to 5 for every 100 comments.Refresh the query and copy the values to backup file.Use this value as page token for input parameters.Note the nextpageToken in the result table column G.Make a backup of those comments in a new file.This template will fetch first 100 comments of any video. Go to comments tab and press ALT+F5 to refresh it.
#Free excel download youtube download#
If you don’t care about the bits & bolts of how this works and just want to use the template, please download it here. optional – pageToken if you want to see comments beyond first 100.Your Google Developer API key – get it from Dev console.dislikes, listing of all videos in a channel etc.) What you need You can use this idea to export other data for a video too (views, likes vs.
#Free excel download youtube how to#
In this article, let me explain the process how to export Youtube video comments to Excel table. Turns out this is easily done once you have a Google developer API key. To make my job easier, I want to export video comments to Excel file. One of the criteria for picking winners is that they must comment on my video. If you would like to learn more about what your customers enjoy watching and the type of videos they share with their friends on social networks, then Excel Add-In for YouTube can help you gain more insight over this matter.This week, I am running a contest on YouTube. A tool that can make a difference in your next marketing campaign It is necessary to mention that the information is available only as read-only.Įven so, you can retrieve useful data, such as activities, captions, channels and sections of the channels accessed, comments, categories of videos or subscriptions, for instance, all of which can help you make a general idea about the interests and preferences of your audiences. The highlight of the app is the abundance of information that you can retrieve from YouTube and that is strictly related to the traffic, views, likes and parameters on your channel. Allows you to collect and examine relevant YouTube data Then again, you should know that the utility comes with a comprehensive help guide you could browse and overcome this challenge. It is necessary to mention that the app employs the OAuth authentication credentials, an option that might intimidate less-experienced users. However, before you can retrieve data for your team to analyze, first you need to establish a connection to your YouTube account. Since this is an add-in, it goes without saying that it borrows the looks and feels of the version of Excel you are currently using. Clean and intuitive UI, yet slightly challenging setup Then again, if you want to ensure that you are benefiting from the manifold advantages provided by this service, you need a tool that enables you to examine what your users like and share.Įxcel Add-In for YouTube is a utility designed to help you retrieve valuable information from your YouTube account, data that you can use to come up with more engaging videos for your target audience. Given YouTube's potential to reach the largest percentage of the population in any marketing medium, it is one of the tools no successful online marketing campaign can do without.