DEV Community

tHelloWorld
tHelloWorld

Posted on

How to Export a Wikipedia Table into Excel or Google Sheets (3 Ways)

#productivity #excel #googlesheets #tutorial

Wikipedia is full of tables you'd love to actually use — country GDP rankings, film box office, election results, sports records, chemical properties. But when you select one, copy it, and paste into Excel or Google Sheets, the columns shatter, footnote markers like [1] come along for the ride, and you spend ten minutes cleaning it up.

Here are three ways to get a Wikipedia table into a spreadsheet cleanly.

Why Wikipedia tables are extra messy

Wikipedia tables look simple but carry a lot of baggage:

  • Footnote references ([1], [a], [note 2]) sit inside cells and end up polluting your data.
  • Merged header cells (rowspan / colspan) are common in ranking and comparison tables — plain copy-paste misaligns them.
  • Sort arrows and tiny icons inside header cells paste as stray characters.
  • Flag images and links inside cells turn into junk or duplicated text.

So the goal isn't just "get the table" — it's "get the table without the cruft."

Method 1 — Google Sheets IMPORTHTML

Google Sheets can pull a Wikipedia table by URL with a formula:

=IMPORTHTML("https://en.wikipedia.org/wiki/List_of_countries_by_GDP_(nominal)", "table", 2)
Enter fullscreen mode Exit fullscreen mode

The last number is the table's position on the page (1 = first table, 2 = second, and so on).

Good: free, and the result auto-updates if Wikipedia changes.

Annoying:

  • You have to guess the index — most Wikipedia pages have several tables (infoboxes count too), so it's trial and error.
  • Footnote markers and some inline junk still come through.
  • It's a live link, not a snapshot — if the article is edited, your data shifts.

Method 2 — Excel "From Web"

In Excel: Data → Get Data → From Web, paste the Wikipedia URL, and Power Query lists the tables it found. Pick one and Load.

Good: stays inside Excel; Power Query lets you delete unwanted columns before loading.

Annoying:

  • Power Query shows tables as "Table 0, Table 1, Table 2…" with no labels — you preview each to find the right one.
  • Cleaning footnotes and merged-cell artifacts still takes a few manual steps.

Method 3 — One click with a browser extension

If you grab Wikipedia tables often, the fastest route is an extension that reads the table straight from the rendered page and hands you clean output.

Table Grab is a small, free Chrome extension:

  1. Open the Wikipedia article.
  2. Click the Table Grab icon — it lists every table on the page, each with a smart title pulled from the content (not "Table 1, 2, 3").
  3. Hover to preview and highlight the exact table on the page.
  4. Pick a format — CSV (opens in Excel / Sheets / Numbers), Excel, Markdown or JSON — and Copy or Download.

Because it reads the rendered table directly:

  • Merged cells (rowspan / colspan) in ranking tables are expanded into the right columns.
  • The CSV is UTF-8 with a BOM, so country names, accents and CJK characters open correctly in Excel instead of as garbled text.
  • No index guessing — you see every table by name and pick visually.
  • No sign-up, no API key, no backend — everything runs locally; nothing is uploaded.

Which one should you use?

Situation Best method
You want a live link that updates with the article IMPORTHTML in Google Sheets
You live in Excel and don't mind a little cleanup Excel From Web
You just want the table, clean, in one click Browser extension (Table Grab)

The native methods cost nothing to try first. When you're tired of guessing table indexes and scrubbing [1] footnotes out of every cell, a one-click extension is the faster path.

Free, no sign-up: Table Grab on the Chrome Web Store

Top comments (0)