For baseball fans & spreadsheet explorers

Make the records
tell a story.

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

Worked exampleCSV → pivot chart

Wins within the sample

Selected team-name counts in the ten-row sample, spanning played series from 1903–1913. These are not all-time totals.

Grouped by the WinningTeam text exactly as stored.

Your first baseball dashboard

From seasons
to a comparison.

The MLB World Series Champions list includes Year, WinningTeam, LosingTeam, Games, and manager fields. Inspect the latest preview and scope before choosing your date range.

  1. Import and inspect.

    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.

  2. Create the pivot table.

    Use WinningTeam for rows and a count of Year for values. Sort the counts descending and insert a horizontal bar chart. Title it with the actual period and coverage of your file.

  3. Choose what a “team” means.

    Exact-name grouping keeps historical names separate. If you want franchise totals, create and document a separate mapping of old and current names before regrouping. The file does not do that interpretation for you.

When you need the whole list

Take your project
past the sample.

Use the sample to set up your chart. A pass gives you every season currently held in the dataset, plus other available sports lists.

A Data Pass includes complete files in CSV, JSON, and XML, API access, and category ZIPs across the available catalog.

Data Pass

$39one payment / 365 days

Choose your pass

Your key arrives by email. No account to create and no automatic renewal.

For your own projects, coursework, teaching, research, and internal work. If you incorporate data into a product or service you provide to others, choose a Commercial Pass. Check the dataset’s scope and sources before buying; passes are non-refundable under our terms.