DEV Community: tHelloWorld

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

tHelloWorld — Thu, 02 Jul 2026 01:19:39 +0000

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)

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:

Open the Wikipedia article.
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").
Hover to preview and highlight the exact table on the page.
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

Turn Any Web Table into Clean Markdown in One Click

tHelloWorld — Mon, 29 Jun 2026 03:57:54 +0000

You're writing notes in Notion, Obsidian, or a GitHub README, and you want to drop in a table you found on a web page. Markdown tables are great — but turning a rendered HTML table into clean Markdown by hand is tedious: you retype every cell, count the pipes, line up the header separator row, and fix it when one cell had a comma or a line break in it.

Here's how to go from a web table to clean Markdown without the busywork.

The manual way (and why it's annoying)

A Markdown table looks like this:

| Name | Role | City |
| --- | --- | --- |
| Ada | Engineer | London |
| Linus | Maintainer | Portland |

To build that from a web table by hand you have to:

Retype or copy-paste every cell.
Add a | --- | separator row with the right number of columns.
Escape any | characters that appear inside cell text, or the table breaks.
Collapse line breaks inside cells, or the row splits.
Get the alignment colons (:---, ---:, :---:) right if you want alignment.

For a 3-row table, fine. For anything bigger, it's a chore — and copy-pasting from the browser usually gives you tab-separated junk, not Markdown.

Online converters: paste HTML, get Markdown

There are web tools where you paste raw HTML and get Markdown back. They work, but they assume you already have the table's HTML:

You have to open DevTools, find the <table> element, copy its outer HTML, and paste it into the converter — several steps before you even start.
Pasting the rendered text instead of the HTML usually fails, because the converter needs real <table> markup.
You're pasting page content into a third-party site, which you may not want for anything sensitive.

Good in a pinch; clumsy as a daily workflow.

One click, straight from the page

A browser extension can read the table the way your browser already rendered it and give you Markdown directly — no DevTools, no copying HTML, no third-party site.

Table Grab is a small, free Chrome extension that does exactly this:

Open the page with the table.
Click the Table Grab icon — it lists every table on the page, each with a smart title.
Hover to preview and highlight the right one on the page.
Pick Markdown and click Copy.

Paste straight into Notion, Obsidian, a GitHub issue or PR, or any Markdown doc.

It handles the things that break a hand-rolled table:

| inside cells are escaped so the table stays intact.
Line breaks inside cells are collapsed cleanly.
Merged cells (rowspan / colspan) are expanded into the right columns instead of misaligning.
It also reads JavaScript-rendered and <div>-based tables that "copy HTML" tricks miss, because it works off the rendered page, not the raw source.

And it's not only Markdown — the same click can give you CSV, Excel or JSON when you need those instead.

Why local-only

Table Grab reads the table on the page you're looking at, only when you click the icon. No login, no account, no analytics — nothing leaves your browser. For something that touches whatever page you're on, local-only felt like the only honest default.

Try it

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

If you hit a table it converts wrong, drop the URL in the comments — that feedback shapes the next version.

How to Copy a Table from a Website into Excel or Google Sheets (Without Breaking Columns)

tHelloWorld — Sun, 21 Jun 2026 06:46:34 +0000

You found a table on a web page — a pricing list, a sports stat sheet, a stock table, a Wikipedia comparison. You want it in Excel or Google Sheets so you can sort, filter or do math on it. You select it, copy, paste… and the whole thing collapses into one mangled column. Numbers become text. Merged cells scatter. You end up retyping it by hand.

Here are the ways to get a web table into a spreadsheet cleanly — starting with the built-in methods (free, no install), and when each one breaks.

Method 1 — Excel's built-in "From Web"

Excel can pull a table straight from a URL.

In Excel, go to Data → Get Data → From Web (on Excel for Windows; on Mac it's Data → From HTML or From Web depending on version).
Paste the page URL and click OK.
Excel's Power Query window lists the tables it detected. Pick one, click Load.

When it works: simple, well-structured tables on a public URL.

Where it breaks:

The page is behind a login, or built by JavaScript after load — Power Query fetches the raw HTML and sees nothing.
The "table" is actually a grid of <div>s (lots of modern sites) — Power Query won't recognize it as a table at all.
You only want one small table on a page full of them, and Excel shows you a confusing list of "Table 0, Table 1, Table 2…" with no labels.

Method 2 — Google Sheets `IMPORTHTML`

Google Sheets has a formula for exactly this:

=IMPORTHTML("https://example.com/page", "table", 1)

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

When it works: public pages with real <table> elements.

Where it breaks:

Same login / JavaScript-rendered problem as above — IMPORTHTML only sees the initial HTML.
You have to guess the index. Getting the right table is trial and error: change the number, wait, check, repeat.
It pulls a live link, not a snapshot — if the page changes or disappears, your data changes or breaks.
No control over formatting; merged cells often land in the wrong place.

Method 3 — Paste Special

Sometimes plain paste fails but Paste Special → Text (or Paste values only in Sheets) does better, because it forces the spreadsheet to re-parse the clipboard.

Where it breaks: still chokes on merged cells (rowspan / colspan) and on tables that were styled with <div>s rather than real table markup.

Why copy-paste breaks in the first place

A rendered HTML table and a spreadsheet grid are two different data models. When you copy a table, the browser hands over a blob of text that looks tabular but rarely maps cleanly — especially with merged cells, nested markup inside cells, or <div>-based layouts pretending to be a grid. The spreadsheet does its best guess, and the guess is often wrong.

Method 4 — One-click with a browser extension

If you do this often, the fastest path is a browser extension that reads the table the same way your browser already rendered it (so JavaScript-built and <div>-based tables work), and hands you clean output.

Table Grab is a small, free Chrome extension that does this:

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

Because it reads the table from the page you're actually looking at:

Pages behind a login or built by JavaScript work fine.
Merged cells (rowspan / colspan) are expanded into the correct columns instead of collapsing.
The CSV is UTF-8 with a BOM, so accented and CJK characters don't turn into garbage in Excel.
No row limit, no sign-up, no API key, no backend — everything runs locally in your browser, nothing is uploaded.

Which method should you use?

Situation	Best method
One simple table, public URL, you live in Excel	Excel From Web
You want a live, auto-updating link in Sheets	`IMPORTHTML`
Table is behind a login / built by JavaScript / made of `<div>`s	Browser extension (Table Grab)
You want it once, clean, in any of CSV/Excel/Markdown/JSON	Browser extension (Table Grab)

The native methods are great when they work and cost nothing to try first. When they break — and on modern, login-gated, JavaScript-heavy pages they often do — a one-click extension is the reliable fallback.

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

How to Export Any Web Table to CSV, Excel, Markdown or JSON (No Code)

tHelloWorld — Mon, 15 Jun 2026 02:13:10 +0000

You see a table on a web page. You want it in a spreadsheet. You select it, copy, paste into Excel — and the columns shatter into a single mangled cell. Numbers turn into text. Merged cells go everywhere. You end up re-typing it by hand.

I hit this often enough that I built a small tool to never do it again. Sharing it here in case it saves you the same annoyance.

The problem with copy-paste

HTML tables and spreadsheet cells are two different worlds. When you copy a rendered table, the browser hands the spreadsheet a blob of text that looks tabular but rarely maps cleanly — especially when the table uses rowspan / colspan, has nested markup inside cells, or is styled with <div>s pretending to be a grid.

The usual escape hatches all have a tax:

Write a scraper — overkill for one table, and now you're maintaining Python and a CSS selector.
Paste into a "paste special" dialog — fiddly, and still breaks on merged cells.
Use a heavyweight extension — most cap the free tier at a few hundred rows or push you to sign up.

I wanted something that's one click, free, and doesn't send my data anywhere.

Table Grab

Table Grab is a tiny Chrome extension that copies and downloads any HTML table on a page to CSV, Excel, Markdown or JSON — in one click.

No sign-up. No API key. No backend. Everything runs locally in your browser; nothing is uploaded.

How it works

Open any page that has a table.
Click the Table Grab icon. It instantly lists every table on the page — each with a smart title pulled from the surrounding content, not a useless "Table 1, Table 2, Table 3".
Hover a table in the list to preview it, and watch it get highlighted right on the page so you know exactly which one you're grabbing.
Pick a format — CSV, Excel, Markdown or JSON — and click Copy or Download.

That's the whole loop. On a heavy page with dozens of tables it still opens instantly, because it only reads each table's structure up front and extracts the full cells lazily, when you actually pick one.

Four formats, and when to reach for each

CSV — opens directly in Excel, Google Sheets or Numbers. UTF-8 with a BOM, so accented characters and CJK text don't turn into garbage.

Excel — same data, spreadsheet-ready.

Markdown — paste straight into Notion, Obsidian, GitHub issues, or your docs. This one is my favorite; turning a web table into a clean Markdown table used to be a manual chore.

JSON — structured rows for quick reuse: feed it to a script, a notebook, or an LLM without writing a parser.

The details that usually break

Merged cells (rowspan / colspan) are expanded correctly instead of collapsing into the wrong columns.
Excel-friendly CSV — no more "why is my CSV one giant column" or garbled UTF-8.
Lots of tables on one page? A search box filters them by title or content, so you find the right one fast.

Why local-only

The extension only reads the table on the page you're looking at, only when you click the icon. No login, no account, no analytics, nothing leaves the browser. The privacy practices are declared right on the Chrome Web Store listing: no data collected.

For something that touches whatever page you happen to be on, that felt like the only honest default.

Try it

It's free, with no row limit: Table Grab on the Chrome Web Store

If you try it, I'd genuinely like to hear about any table it fails to parse — drop the URL in the comments and I'll dig into it. That feedback is what shapes the next version.

Life after MythX: A Drop-in Solidity Security API

tHelloWorld — Tue, 21 Apr 2026 03:19:41 +0000

On March 31, 2026, Consensys shut down MythX — the Solidity security API that had quietly sat inside many teams' CI for 6+ years.

I was one of those devs. My side-project Hardhat repo had a yarn security script pointing at MythX. One day it 500'd, and that's how I found out.

I looked around for a replacement. The options:

Run Slither locally — powerful, but compiler pinning, Docker, and false-positive triage eat an afternoon per project.
SolidityScan — $29.99 per 1,000 LOC per month, which scales weirdly if you're scanning the same small contract often.
CertiK / OpenZeppelin Defender — enterprise audit pricing ($10k+), not built for "I just want to sanity-check my DAO's treasury contract before a weekend upgrade."

So I built SmartScan. One POST request, structured audit JSON back, Solidity 0.8.x today, more EVM languages on the roadmap.

What a scan looks like

Here's a classic reentrancy vulnerability to scan:

pragma solidity ^0.8.0;
contract VulnerableBank {
    mapping(address => uint) public balances;
    function deposit() external payable {
        balances[msg.sender] += msg.value;
    }
    function withdraw() external {
        uint amount = balances[msg.sender];
        require(amount > 0);
        (bool success,) = msg.sender.call{value: amount}("");
        require(success);
        balances[msg.sender] = 0;
    }
}

Save it as VulnerableBank.sol, then scan it:

curl -X POST "https://smart-contract-security-scan.p.rapidapi.com/api/v1/scan/sync" \
  -H "Content-Type: application/json" \
  -H "X-RapidAPI-Key: YOUR_KEY" \
  -H "X-RapidAPI-Host: smart-contract-security-scan.p.rapidapi.com" \
  -d "$(jq -n --rawfile src VulnerableBank.sol '{source_code:$src, contract_name:"VulnerableBank"}')"

Get back structured findings:

LLM-reasoned triage means you don't drown in warnings you'd have to filter by hand. A risk score 0–100 gives you a single number to gate CI on.

Pricing (no per-LOC weirdness)

Free — 1 scan / month, entry-tier model
Starter — $48.9 / 100 scans
Pro — $134.9 / 300 scans
Business — $399 / 1,000 scans

Or one-off $9.9 / scan on our API.market listing if you don't want a subscription.

Who this is for

Indie Solidity devs with 2–10 repos who can't justify $5k+ per audit
Hackathon teams needing a quick sanity check before demo day
Small DAOs doing routine upgrades

If you're an enterprise with a $100k/year security budget, this isn't for you — CertiK and Trail of Bits serve that market. SmartScan fills the MythX-shaped hole: API-first, cheap enough to not think about, accurate enough to trust.

Try it

Landing page: 👉 smartscan.dev

Or go straight to the free tier on RapidAPI (no credit card, 1 scan/month): SmartScan listing.

If you try it, DM me on Twitter @smartscan_dev — I'm collecting feedback from the first 10 real users and giving 3 months of Pro free in exchange for 3 sentences: what worked, what didn't, what you'd pay.

DEV Community: tHelloWorld

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

Why Wikipedia tables are extra messy

Method 1 — Google Sheets IMPORTHTML

Method 2 — Excel "From Web"

Method 3 — One click with a browser extension

Which one should you use?

Turn Any Web Table into Clean Markdown in One Click

The manual way (and why it's annoying)

Online converters: paste HTML, get Markdown

One click, straight from the page

Why local-only

Try it

How to Copy a Table from a Website into Excel or Google Sheets (Without Breaking Columns)

Method 1 — Excel's built-in "From Web"

Method 2 — Google Sheets IMPORTHTML

Method 3 — Paste Special

Why copy-paste breaks in the first place

Method 4 — One-click with a browser extension

Which method should you use?

How to Export Any Web Table to CSV, Excel, Markdown or JSON (No Code)

The problem with copy-paste

Table Grab

How it works

Four formats, and when to reach for each

The details that usually break

Why local-only

Try it

Life after MythX: A Drop-in Solidity Security API

What a scan looks like

Pricing (no per-LOC weirdness)

Who this is for

Try it

Method 1 — Google Sheets `IMPORTHTML`

Method 2 — Google Sheets `IMPORTHTML`