Free tools Windows power users keep installed
One-click scans. No signup required.
Some links on this page are affiliate links: if you buy through them we may earn a commission, at no extra cost to you.
Yes, ChatGPT can analyze Netflix’s public viewership files—but it cannot tell you how many unique people watched a title, whether a show made money, or whether it reduced churn. The most reliable workflow is to download Netflix’s official What We Watched or Top 10 data, audit the file, define the metrics, run exploratory analysis, and verify every conclusion.
This guide focuses on public, aggregate Netflix data—not private account viewing histories or subscriber-level analytics.
What you can learn from Netflix’s public data
Netflix publishes two especially useful sources:
- What We Watched reports: six-month global snapshots containing title-level viewing information such as hours viewed, runtime, premiere date, and global-availability details.
- Weekly Top 10 data: useful for studying recent momentum, country-level differences, English and non-English titles, films, television, and ranking movement.
Netflix’s current report is What We Watched: The First Half of 2026, covering January through June 2026. Netflix says it recorded more than 97 billion hours viewed during that period. Netflix also says it plans to move from twice-yearly reports to a yearly snapshot beginning in Q1 2027.
Recommended Free Tools
Weekly Top 10 lists measure viewing from Monday through Sunday and are generally published on Tuesday. The available categories and territories can change, so check the current Netflix Top 10 site when collecting data.
#1 Best Overall
- Wiley
- Language: english
- Book - storytelling with data: a data visualization guide for business professionals
Hours viewed and views are not the same thing
Hours viewed is total watch time reported for a title during a specified period. It is not a count of unique viewers.
Netflix’s principal comparison metric, views, is calculated as:
views = total hours viewed ÷ runtime in hoursFor example, a two-hour film with 10 million hours viewed would have:
10,000,000 ÷ 2 = 5,000,000 viewsFor a television season, runtime may represent the total runtime of the season rather than one episode. A Netflix “view” is therefore best understood as a standardized viewing equivalent—not necessarily one identifiable person watching every minute once.
This distinction matters. A long season may lead the hours ranking simply because it contains more viewing time, while a shorter film may rank better by views. Netflix introduced views to reduce the advantage longer titles receive when comparisons rely only on hours.
Neither measure proves revenue, profitability, subscriber acquisition, retention, satisfaction, completion rate, or the number of distinct people who watched.
Choose the right Netflix dataset
What We Watched
Use What We Watched when you want a broad, six-month view of Netflix engagement across its catalog. It is suitable for questions such as:
- Which titles accumulated the most hours during the reporting period?
- Which titles led by Netflix’s views metric?
- How much viewing went to older catalog titles?
- How did films, seasons, languages, or regions compare?
- How concentrated was viewing among the most-watched titles?
Read the methodology for the particular edition you use. Netflix has described earlier reports as covering titles watched for more than 50,000 hours, representing approximately 99% of viewing in that report, with hours rounded to 100,000-hour increments. Coverage thresholds and rounding conventions should not be assumed to be permanent.
Weekly Top 10 data
Use weekly lists when recency and momentum matter. They can help you compare:
- Rank movement from week to week
- Film and television performance
- English and non-English categories
- Countries and territories
- Weekly views and hours viewed
Netflix’s all-time television and movie pages also expose rankings based on views during the first 91 days after release. These lists are not interchangeable with six-month global reports or a particular week’s country ranking.
What Netflix’s public data does not contain
Do not use aggregate title data to claim that you know:
- How many unique people watched a title
- Which households or individuals watched it
- How many people started but did not finish
- Completion percentages or minute-by-minute audience curves
- Title-level churn, retention, revenue, profit, or marketing return
- Licensing costs or production costs
- Audience demographics
- Geographic results at any arbitrary level
“Most watched” must always specify the metric, reporting period, geography, and title type. “Popular” is an interpretation; “highest hours viewed in the first half of 2026” is a measurable claim.
Prepare the file before uploading it
Preserve the original Netflix file. Record the download date, reporting period, source URL, file name, notes in the report, and whether values are rounded.
A normalized analysis table might use these columns:
title
title_type
season_or_film
premiere_date
runtime_minutes
hours_viewed
views
report_period
global_availability
language
country_or_region
source_urlUse one title or season per row, one header row, consistent column names, numeric fields stored as numbers, consistent dates, and explicit missing values. Add source_report or report_period before combining files.
Do not silently combine global rows with country rows, weekly data with six-month data, or multiple report periods. A useful stable key is:
report_period + region + title + title_type + seasonConvert runtime explicitly
Runtime values such as 1:40, 2:14, and 6:49 can be misread as decimals or text. Convert them to minutes:
runtime_minutes = hours × 60 + minutes
runtime_hours = runtime_minutes ÷ 60Check several conversions manually before using runtime in calculations.
Upload the data to ChatGPT
Start a ChatGPT conversation and use the file-upload control in the tools menu. OpenAI documentation lists CSV and XLSX among supported formats, although available file types, limits, and features can vary by model, plan, workspace, and account.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
ChatGPT’s data-analysis environment can clean, transform, merge, summarize, calculate statistics, create charts, and run Python-backed analysis. See OpenAI’s data-analysis documentation and its guide to extracting insights from uploaded data.
Audit the file before asking what is “most popular”
The first prompt should inspect the data, not interpret it:
Inspect this Netflix viewership dataset before analyzing it.
1. List every sheet and its row and column counts.
2. Show the column names and inferred data types.
3. Identify duplicate rows, missing values, impossible runtimes, negative values,
inconsistent title types, and suspicious date formats.
4. Do not change the data yet.
5. Report any assumptions you would need to make.Ask for row counts before and after any cleaning. A file can upload successfully while still being too large, image-heavy, or poorly structured for complete analysis.
For a large workbook, use:
Confirm that every row in every sheet was included.
Report the number of rows read, rows discarded, and rows remaining.
If the full file was not processed, stop and explain how I should split it.Prefer spreadsheet or text-based downloads over scanned PDFs and screenshots. Image-based tables may not preserve exact values.
The Tool Desk
Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →Outbyte Driver Updater FREEFix the driver behind crashes, sound loss and screen glitchesFind Drivers →Confirm definitions before calculating
Use Netflix’s published views field when it exists. Do not replace it with a new calculation without documenting the difference:
Use the dataset's existing definitions for hours_viewed and views.
Do not recalculate views unless you first show the formula, the runtime units,
the rounding behavior, and the rows that would change.If you need to recreate the metric, request a separate derived field:
Calculate a new field called calculated_views as:
hours_viewed × 1,000,000 ÷ (runtime_minutes ÷ 60)
Compare calculated_views with the published views column.
Show absolute and percentage differences, and explain whether the differences
could be caused by rounding.Netflix reports that hours-viewed values are rounded. Small discrepancies between a calculation based on rounded hours and the published views value may therefore be expected. Do not describe recalculated values as official Netflix figures unless the methodology and rounding match.
Start with descriptive analysis
Useful first questions include:
Summarize the dataset by title type, language, report period, and region.
For each group, calculate title count, total hours viewed, median views,
mean views, and share of total hours viewed.Show the top 20 titles by hours viewed and the top 20 by views.
Place the two rankings side by side and identify titles that move by at least
10 positions.Calculate the median and interquartile range for views by title type.
Use medians rather than only averages because the distribution is likely skewed.Medians and distributions are often more informative than averages because a small number of breakout titles can dominate the total.
Quick wins for a faster PC:
Repair Windows errors before they cause bigger problemsFix Now →Scan for outdated or missing drivers - takes under a minuteDriver Scan →Clear out junk files and repair common Windows errorsFree Scan →Create charts that answer specific questions
Ask for one chart per analytical question, with units and filters shown in the title or subtitle.
Runtime versus hours viewed
Create a scatter plot with runtime on the x-axis and hours viewed on the y-axis.
Color by title type and label the most extreme outliers.
Show the correlation and explain why correlation does not establish causation.This chart can show whether longer titles tend to accumulate more watch time, but it cannot prove that runtime caused the viewing.
Hours versus views
Compare the two rankings rather than treating one as automatically correct. A long season can be prominent by hours and less prominent by views; a short film can show the opposite pattern.
Concentration of viewing
Sort titles by hours_viewed in descending order.
Calculate the cumulative share of total hours viewed.
Report how many titles account for 50%, 80%, and 90% of viewing.
Show the result as a cumulative-share chart.State whether the calculation uses titles, seasons, a global report, or country-level rows. Never add country totals to global totals.
Do these 3 things before closing this tab:
1Repair Windows errors before they cause bigger problems2Scan for outdated or missing drivers - takes under a minute3Clear out junk files and repair common Windows errorsAnalyze release age and the catalog
Current-period popularity is not the same as new-release performance. Group titles into release-age bands:
- 0–30 days
- 31–90 days
- 91–365 days
- More than one year
Then ask:
Compare title count, total hours viewed, median views, and share of all viewing
across these release-age bands. Separate titles released during the report period
from titles released earlier.You can also identify older titles with unusually high current-period viewing. Define your threshold before calling anything a “long-tail hit.” Netflix’s reports have highlighted the contribution of older seasons and licensed catalog titles, so a current-period leaderboard should not automatically be read as a new-release leaderboard.
Study seasons and franchises carefully
A season is not directly equivalent to a film. Analyze films, seasons, specials, and other title types separately unless there is a clear analytical reason to combine them.
For a franchise analysis, require defensible matching rules:
Group titles by franchise or series where the naming allows a defensible match.
Do not infer franchise membership from title similarity alone.
Show the matching rules and flag ambiguous cases for manual review.For returning shows:
For series with multiple seasons, compare each season's views and hours viewed.
Separate seasons released in the current report period from earlier seasons.This can reveal whether a new season coincided with more viewing of earlier seasons. It cannot prove that the new season caused that increase without stronger evidence.
Ask ChatGPT to show its work
For any result you may publish, request:
Perform the analysis with Python where appropriate.
Show the code used, the formulas, the filters, the row counts before and after
each filter, and the assumptions behind every derived metric.
For every conclusion, cite the exact columns and rows supporting it.
Separate observed facts, calculated results, and hypotheses.Review the generated code, output, filters, and assumptions. OpenAI specifically recommends checking these elements before relying on the result.
Request manual spot checks for totals, runtime conversion, duplicate handling, and a few individual titles. A plausible chart can still be based on an incorrectly parsed column.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Export an auditable result
ChatGPT can generally provide downloadable tables such as CSV files and charts such as PNG images, although controls vary by output and interface version.
Outdated Drivers Are Slowing You Down
One free scan finds every outdated or missing driver and matches the right update for your exact hardware.Free scan · exact hardware matchWindows Errors? Fix Them Before They Spread
Repair common Windows errors and clear accumulated junk for a smoother, more stable PC - no reinstall needed.Free scan · no reinstallSave:
- The original Netflix source file
- The cleaned and analysis-ready dataset
- Summary and ranking-comparison tables
- Chart images
- Generated Python code
- The prompt log
- Metric definitions and assumptions
- Download date, report period, geography, and source URLs
A chart without its source file, filters, formula, and reporting period is difficult to reproduce or audit.
What ChatGPT cannot do automatically
The Python environment used for data analysis cannot necessarily make external web requests or API calls. If your analysis depends on another dataset, download it and upload it first, or use an available connected source.
ChatGPT may also analyze only part of a complex workbook. Ask it to confirm coverage. If it cannot process the complete file, split it into smaller, clearly labeled files and document how they were recombined.
ChatGPT can invent explanations for patterns. Do not accept statements about audience motivation, demographics, or business impact unless the dataset actually contains evidence for them.
Recommended Free Tools
When ChatGPT is the right tool
ChatGPT is a strong fit for exploratory work, spreadsheet cleanup, first-pass charts, natural-language questions, formula explanations, and drafting an executive summary from a validated table.
Excel or Google Sheets may be better when formulas must remain visible, several people need to edit the workbook, or the result is a simple pivot table that must be reproduced without ChatGPT.
Python, R, or SQL is preferable when the dataset is large, the workflow must run repeatedly, joins are complex, or the analysis will be peer reviewed.
Tableau or Power BI is better for governed dashboards, recurring refreshes, access controls, filters, and drill-downs.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
A practical hybrid workflow is to use ChatGPT for exploration and code drafting, then run and validate the final analysis in a controlled notebook, spreadsheet, database, or BI system.
Privacy precautions
Public Netflix reports are aggregate and title-level, so their privacy risk is relatively low. Do not upload private Netflix viewing histories, subscriber-level records, confidential licensing or revenue data, or files containing names, email addresses, household identifiers, or account IDs.
OpenAI’s data-use treatment depends on the service, account, and plan. Review the policy that applies to your account before uploading sensitive material:
Quick Recap
Final validation checklist
- Did you save the original Netflix file?
- Did you record the source URL, download date, report period, and geography?
- Did you preserve Netflix’s metric definitions?
- Did you distinguish hours viewed from views?
- Did you keep films, seasons, specials, and other title types separate where appropriate?
- Did you avoid mixing global, country, weekly, and six-month rows?
- Did you check duplicates, missing values, dates, runtime units, and numeric fields?
- Did you confirm that every row was processed?
- Did you export the code, prompts, filters, and assumptions?
- Did you separate observed facts, calculated results, and hypotheses?
- Did you avoid calling views unique viewers or a completion metric?
- Did you avoid claims about revenue, profit, acquisition, retention, or satisfaction?
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.
The Tool Desk
Outbyte PC Repair FREERepair Windows errors before they cause bigger problemsFix Now →Outbyte Driver Updater FREEFix the driver behind crashes, sound loss and screen glitchesFind Drivers →
