For baseball fans & spreadsheet explorers
Chart the
World Series.
Turn a list of World Series champions into a chart you can explore. Start with a pivot table, then decide which historical questions your data can answer.
Excel or Google Sheets · Sample first, full dataset with a pass
Wins within the sample
The teams with the most wins in the sample, the 2017–2026 World Series. These are not all-time totals.
Each team name is counted exactly as it appears in the WinningTeam column.
Your first baseball dashboard
Count team wins.
Build a bar chart.
The MLB World Series Champions list includes Year, WinningTeam, LosingTeam, Games, and manager fields. Check which years the dataset includes before choosing your date range.
Import the file and check the rows.
Open the CSV, confirm the headers, and sort Year numerically. Check for duplicate years and missing results. Keep Games as text: a value such as
4-3-(1)is a series result, not a single number.Create the pivot table.
Use WinningTeam for rows and a count of Year for values. Sort the counts from highest to lowest and insert a horizontal bar chart. Include the years covered by your file in the chart title, and note any gaps.
Account for team name changes.
The pivot table counts different team names separately, even when they belong to the same franchise. To combine them, make a separate table linking historical names to the franchise name you want to use. Check and document those links before adding the totals together.
When you need the whole list
Get the complete
datasets.
Use the sample to set up your chart. The Data Pass gives you every season in the dataset, plus the other sports lists.
The Data Pass includes complete files in CSV, JSON, and XML, API access, and category ZIPs across the whole catalog.
Data Pass
$69one payment / 365 days
Get the Data PassYour key arrives by email. No account to create and no automatic renewal.
Use it in your own projects, coursework, research, or products you sell; commercial use is allowed, free or paid. Check the dataset’s scope and sources before buying; the Data Pass is non-refundable under our terms.