Use Pokémon data to practice Excel with four concrete questions: which types are most common, how do base stats compare, how do generations differ, and which matchup multipliers shape a Pokémon’s defensive profile? Each project ends with a table, summary, or chart—and makes you choose clear rules for forms and dual types rather than treating a spreadsheet as a pile of rows.
Choose a dataset and set your scope
The Complete Pokédex Dataset repository describes a CSV with 55 columns, including species identifiers, primary and secondary types, six base stats, 18 type-matchup multiplier fields, evolution and form information, and Pokédex descriptions. Its metadata describes 1,025 Pokémon from Gen I–IX; treat that as the scope of this particular community-maintained dataset, not an official download or a permanent guarantee. The repository says its material draws on Serebii for stats and breeding or legendary status, Pokémon.com for Pokédex descriptions, and Bulbapedia for artwork. Check the dataset repository’s fields, files, and license before relying on them.
As an Amazon Associate I earn from qualifying purchases.
For the steps below, use the repository’s pokemon_utf8.csv, described as its recommended UTF-8 comma-separated file. It also describes an original UTF-16 tab-separated file and a long-format stats file; those alternatives may import or organize data differently. In Excel, use Data > From Text/CSV, select the UTF-8 CSV, inspect the preview, and choose Load. Confirm that each field appears in its own column and that names and punctuation display correctly.
Quick wins for a faster PC:
Clear out junk files and repair common Windows errorsFree Scan →Scan for outdated or missing drivers - takes under a minuteDriver Scan →If you prefer a smaller, configurable selection, Pokémon Database’s text-list generator can filter by form, generation, or type and lets you choose attributes such as number, name, form, type, and base stats. Select its tab-separated output, then copy and paste into Excel or LibreOffice. Your export may include fewer records or columns than the full CSV because the filters and selected attributes determine its contents. Open the Pokémon Database text-list generator.
#1 Best Overall
- Read Before You Buy — No Video Output: These adapters support charging and USB 2.0 data transfer, but cannot transmit video signals. Except for standard USB webcams (which use USB data only), they are not compatible with HDMI/DisplayPort cables, video-capable USB-C hubs, or docking stations with video output.
- Convert USB-A Ports to USB-C: Designed to connect USB-C earphones, cables, flash drives, card readers, and other USB-C accessories to standard USB-A ports. Plug-and-play with no drivers or software required.
- Aluminum Alloy Housing: Built with a sturdy aluminum alloy shell that aids in heat dissipation and protects against daily wear and scratches. Designed to maintain a stable and secure connection.
- Compact & Travel-Friendly: The ultra-compact design allows the adapter to stay plugged into your device without blocking adjacent ports or adding bulk, reducing wear and tear on your original USB ports.
- 12-Month Warranty: Backed by a 12-month manufacturer warranty for peace of mind. Designed to meet strict quality control standards for reliable everyday performance.
Before analysis, decide which records count. A dataset’s form handling can change totals and comparisons, and dual-type Pokémon require an explicit counting rule. Write that rule near the finished chart or table so readers know what it represents. The repository identifies its dataset license as CC-BY-NC-SA-4.0; check the current license and reuse terms for the specific files and any artwork before redistributing them.
1. Chart Pokémon by type
Question to answer
Which types appear most often in the dataset? The answer depends on whether you count only the primary type or count every type a Pokémon has. The first method gives each record one type; the second counts dual-type Pokémon under both types, so the totals can exceed the number of records.
Rank #2
- 5-in-1 USB-C Hub: Experience comprehensive connectivity featuring a Power Delivery input, two USB-A 2.0 ports, a USB-A 3.0 port, and an HDMI port. (Note: The USB-C power delivery input port is only for connecting an external wall charger to power your laptop and cannot power peripheral devices.)
- 90W Pass-Through Charging: Achieve optimal charging with 90W pass-through power to your laptop, supported by a total input of 100W, with the hub reserving 10W for operational efficiency. (Note: Wall charger not included.)
- Quick Data Transfers: Accelerate your productivity with rapid data transfers using a high-speed 5Gbps USB 3.0 port and two 480Mbps USB 2.0 ports.
- 4K HDMI Display: Enhance your visual experience with a hub capable of delivering 4K resolution at 30Hz in both mirror and extend modes. Please note that this hub is compatible with MacBook (macOS 12 and newer), Windows 10 and 11, ChromeOS, and laptops equipped with DP Alt Mode and Power Delivery. Note: This device is not compatible with Linux.
- What You Get: Anker USB-C Hub (5-in-1, 4K HDMI), welcome guide, 18-month warranty, and our friendly customer service.
Build the summary
- Choose one rule: count each Pokémon’s primary type only, or count it once for every type listed. Record whether alternate forms are included.
- For a primary-type count, create a PivotTable from the data: select a cell in the imported table, choose Insert > PivotTable, and place Primary Type in Rows and a nonblank identifier such as the Pokémon name or number in Values. Set the value calculation to Count if Excel does not choose it automatically.
- For counts that include secondary types, first reshape the type data so each Pokémon-type pairing is a separate row. Include the primary type and, when present, the secondary type; then count the resulting type column in a PivotTable. Do not simply add primary- and secondary-type counts without accounting for blanks or duplicates.
- Sort the count from largest to smallest and insert a bar or column chart. Label it with the inclusion rule, for example, “Primary type only” or “Each listed type counted.”
The Complete Pokédex Dataset documents separate primary and secondary type fields, and its companion exploratory notebook includes type-distribution analysis. Review the dataset schema and the documented exploratory analyses before adapting the exercise to a changed file layout.
Recommended Free Tools
2. Rank base stats and compare profiles
Question to answer
Which records rank highest for one selected base stat, and how do a few Pokémon compare across all six stats? Keeping those questions separate makes the result easier to read: a ranked list identifies leaders for one measure, while a profile chart shows each selected record’s shape.
Rank #3
- Sleek 7-in-1 USB-C Hub: Features an HDMI port, two USB-A 3.0 ports, and a USB-C data port, each providing 5Gbps transfer speeds. It also includes a USB-C PD input port for charging up to 100W and dual SD and TF card slots, all in a compact design.
- Flawless 4K@60Hz Video with HDMI: Delivers exceptional clarity and smoothness with its 4K@60Hz HDMI port, making it ideal for high-definition presentations and entertainment. (Note: Only the HDMI port supports video projection; the USB-C port is for data transfer only.)
- Double Up on Efficiency: The two USB-A 3.0 ports and a USB-C port support a fast 5Gbps data rate, significantly boosting your transfer speeds and improving productivity.
- Fast and Reliable 85W Charging: Offers high-capacity, speedy charging for laptops up to 85W, so you spend less time tethered to an outlet and more time being productive.
- What You Get: Anker USB-C Hub (7-in-1), welcome guide, 18-month warranty, and our friendly customer service.
Build the leaderboard and chart
- Choose one of the six base-stat columns, such as Speed or HP. Confirm the exact column labels in your imported file rather than assuming another version uses the same names.
- Filter out blank values if necessary, then sort the chosen stat from largest to smallest. Add a rank column if you want an explicit position; ties should share a rank or be clearly handled by your chosen ranking method.
- Select a small group of records for a profile comparison. Keep the same six stat columns for every record, and use the names as series labels.
- Insert a clustered column or radar chart, then check that the six stat categories and Pokémon names are legible. A table beside the chart preserves the exact values when visual shapes are close.
Describe what your file calls a base stat and which forms it includes; do not imply the values cover every game mechanic or alternate form. The dataset repository documents six base stats and also provides a long-format stats file. Its exploratory notebook includes stat distributions and correlations, which can inspire a follow-up question but do not establish that a stat causes another stat to change. Check the repository’s current field descriptions and its example analyses.
3. Compare generations
Question to answer
How many records does this dataset assign to each generation, or how does one chosen base stat vary across those assignments? A generation field is a dataset label; it should not automatically be read as a complete game-release chronology.
Rank #4
- Dual Converters, Infinite Potential：Includes 2× USB C male to USB A female adapters and 2× USB A male to USB C female adapters. Perfect for a wide range of uses—tablets with Bluetooth keyboards, expand USB ports on macbook, and more. Two different converters for all your daily needs
- Next-Level 10Gbps & 3A Charging: No more slow 480Mbps, this usb to usb c adapter has a transfer speed of up to 10Gbps, allowing you to do more transferring in less time. This usb adapter fits both USB A and USB C charger, supporting up to 3A fast charging
- Upgraded Exquisite Craftsmanship: With an aluminum alloy housing and metal connector, the usbc to usb adapter is extremely durable and sturdy. Rigorously tested to withstand more than 10,000 times of plugging and unplugging, ensuring long-lasting performance
- Broad Compatible: The usb c to usb adapter widely supports all USB C/ USB A devices like laptops, tablets, cellphones, car chargers, and phone chargers. Such as compatible with MacBook Pro/Air 2023/2022, Thunderbolt 4/3 Devices,Apple MagSafe Watch 9/8/7/SE/Ultra, iPad Pro 2022/2021, Samsung Galaxy S23/S20/S10, and iPhone 17/16/15 Pro. Plug and play
- Please Note: To reach 10Gbps speed, keep the cable under 3.3 ft. For USB A Male to USB C adapters, try flipping the USB C connector. USB C Male to USB A adapters support bidirectional 10Gbps transfer within 3.3 ft
Build a generation summary
- Choose whether you want to compare record counts or a stat. If comparing a stat, choose one measure and a consistent treatment of forms and missing values.
- Create a PivotTable with Generation in Rows. For counts, add a Pokémon identifier to Values and summarize by Count. For a stat comparison, add that stat to Values and select an appropriate summary such as Average or Median if available.
- Sort generations in numerical order, not by the displayed text if that puts labels out of sequence. Add a chart with a title that names the measure and summary.
- Check the dataset notes for unusual assignments before interpreting the result. The metadata notes that certain Legends: Arceus additions are assigned to Gen VIII.
The generation comparison describes the dataset’s assignments and inclusion rules; it is not, by itself, a claim about when every Pokémon first appeared in a particular release. Consult the repository metadata for its stated scope and generation notes.
Do these 3 things before closing this tab:
1Scan for outdated or missing drivers - takes under a minute2Clear out junk files and repair common Windows errors3Fix the driver behind crashes, sound loss and screen glitches4. Compare type-defence profiles
Question to answer
How do the dataset’s recorded matchup multipliers differ across Pokémon or types? The 18 against_* fields are matchup values supplied by the dataset. Inspect their definitions and the source’s assumptions before treating a value as a complete description of game behavior.
Best Value
- 5-in-1 Connectivity: Equipped with a 4K HDMI port, a 5 Gbps USB-C data port, two 5 Gbps USB-A ports, and a USB C 100W PD-IN port. Note: The USB C 100W PD-IN port supports only charging and does not support data transfer devices such as headphones or speakers.
- Powerful Pass-Through Charging: Supports up to 85W pass-through charging so you can power up your laptop while you use the hub. Note: Pass-through charging requires a charger (not included). Note: To achieve full power for iPad, we recommend using a 45W wall charger.
- Transfer Files in Seconds: Move files to and from your laptop at speeds of up to 5 Gbps via the USB-C and USB-A data ports. Note: The USB C 5Gbps Data port does not support video output.
- HD Display: Connect to the HDMI port to stream or mirror content to an external monitor in resolutions of up to 4K@30Hz. Note: The USB-C ports do not support video output.
- What You Get: Anker 332 USB-C Hub (5-in-1), welcome guide, our worry-free 18-month warranty, and friendly customer service.
Build a lookup or comparison
- Choose the comparison: one Pokémon against all listed attack types, or a small set of Pokémon compared across selected matchup columns.
- Filter to the records of interest, then keep the identifier and relevant
against_*columns. For a type-level comparison, summarize only after deciding how to group records and handle forms; state that rule with the result. - Use conditional formatting to highlight different multiplier values, or chart a selected subset of columns. Keep the column names visible so each value remains tied to the matchup it represents.
- Check a few values against the dataset’s field definitions before drawing conclusions, especially if the CSV version or source has changed.
The dataset schema lists 18 matchup multiplier fields, and its example notebook includes a type-defence profile analysis. Those establish a workable exercise, not a universal guarantee that every game, form, or mechanic is represented identically. Review the field definitions in the dataset and see the documented type-defence example.
Turn one project into deliberate Excel practice
For each project, save the question, inclusion rule, source file, summary table, and chart together in the workbook. That small record makes the result understandable when filters, forms, or data versions change. The four exercises naturally practice importing tabular data, filtering, sorting, counting, summarizing, and charting; they are proposed practice projects, not measured claims about learning outcomes.
A separate repository, lgreski/pokemonData, stated in a June 2026 update that its National Pokédex contained 1,025 Pokémon and identifies Pokémon Database’s generation-by-generation stats pages as its statistics source. That is a dated statement about that repository, not an official count or a guarantee for other files. Its README says its original data is CC0 1.0; that license does not apply automatically to unrelated datasets or their artwork. Check that repository’s current files, provenance, and terms if you choose it instead.
The Tool Desk
Outbyte Driver Updater FREEScan for outdated or missing drivers - takes under a minuteDriver Scan →Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →Quick Recap
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.
