YouTube data selectors

Selectors for YouTube Video URLs

Want to extract YouTube video data straight into your spreadsheet?

You can see below the exhaustive list of selectors designed for any YouTube video pages. These built-in data selectors are used within your =IMPORTFROMWEB( ) function; just pick them up directly in our YouTuve video scraper template or use them by yourself in your own spreadsheet.

=IMPORTFROMWEB("YouTube video url", "title, views_count,likes_count")
=IMPORTFROMWEB(A2,B1:C1)

1. Video Information

SelectorDescription
titleVideo’s title
description_headerVideo’s description
published_dateDate video was first published
upload_dateDate video was uploaded
video_idThe unique identifier for the video on YouTube.
channel_urlThe unique identifier for the channel that uploaded the video.
unlistedWhether the video is unlisted or not.
categoryThe category that the video belongs to on YouTube.
thumbnail_image_urlThe URL of the thumbnail image for the video

2. Video Metrics

SelectorDescription
views_countNumber of views
likes_countNumber of likes
comments_countNumber of comments
isFamilyFriendlyIndicates if video is appropriate for all ages
paidIndicates if video is for free users or paid
durationLength of video

3. Creator information

Selector Description
authorVideo’s author
author_urlAuthor’s YouTube channel URL

Selectors for YouTube Channels

Want to extract YouTube channel data straight into your spreadsheet?

You can see below the exhaustive list of selectors designed for any YouTube channel. These built-in data selectors are used within your =IMPORTFROMWEB( ) function; just pick them up directly in our YouTube channel scraper template or use them by yourself in your own spreadsheet.

=IMPORTFROMWEB("https://www.youtube.com/@espn/about", "title, description, subscribers_count")

1. Channel information

Selector Description
titleChannel’s title
descriptionChannel’s description
locationChannel’s location
join_dateDate channel was created
logo_urlURL of the channel’s logo
banner_urlURL of the channel’s banner

2. Channel metrics

Selector Description
views_countCumulated number of videos views
subscribers_countNumber of channel subscribers
videos_countNumber of videos in channel

3. Channel videos

You can see below the exhaustive list of selectors designed for any YouTube channel video list.

Note that you can retrieve the 30 first videos along with their meta data, and the channel URL must respect the format as written below:

=IMPORTFROMWEB("https://www.youtube.com/@espn/videos", "video_title,video_description,views_count")

SelectorDescription
video_titleReturns the title of the channel videos list
views_countExtracts the views number of the channel videos list
video_durationExtracts the duration of the channel videos list
video_descriptionReturns the description of the channel videos list
video_published_dateReturns the pubished_date of the channel videos list
video_thumbnail_sourceImport the thumbnail source URL of the channel videos list
video_urlExtracts the URLs of the channel videos list

Selectors for YouTube Search URLs

These selectors will retrieve data for the first 30 videos (in average) found with the YouTube search query.

SelectorDescription
video_titleReturns the title of the videos
video_channel_nameReturns the channel name of the videos
video_views_countReturns the number of views for each video
video_published_dateReturns the published date for each video
video_thumbnail_image_urlReturns the thumbnail image URL for each video