HTML Table Extractor — Clean Rows from Any Table

Turn every

on a page into clean rows of objects keyed by real headers — handling thead/th, header-row fallback, and colspan. One row per table-row or one row per table. Per-URL reporting.

Built reliability-first: every row reports what was found and what was missing — you never get a silent blank, and a run summary tells you exactly what happened.

What you get

Returns one clean, structured row per result. Every row reports its own status so you never get a silent blank.

How to use it

1. Fill in the input (see the example below).
2. Run it once for a snapshot, or schedule it to keep the data fresh.
3. Export to CSV/JSON/Excel, or push straight to Google Sheets, Notion, Airtable, Zapier, Make, or n8n.

Input

{
  "urls": [
    {
      "url": "https://en.wikipedia.org/wiki/List_of_largest_companies_by_revenue"
    }
  ],
  "output": "rows",
  "minRows": 1,
  "useProxy": false,
  "maxConcurrency": 10
}

Sample output

[
{
  "result": "example",
  "status": "ok",
  "scrapedAt": "2026-09-03T09:00:00.000Z"
}
]

Typical uses

• Wikipedia / reference data — pull ranked lists, specs, standings into CSV.
• Financial / stats pages — grab data tables without hand-writing selectors.
• Feed a pipeline — extract → convert (Format Converter) → export (Sheets/Notion).

Pricing

$1.00 / 1,000 results ($0.001 per result), plus a near-zero start fee. You are never charged beyond your limit, and blocked or failed items are reported honestly — not billed as data.

FAQ & limitations

• Public data only — no login walls, no cookies required.
• Rate limits on the source may require the proxy or a retry on very large pulls.
• Every row reports its own status, so partial results are always labeled, never faked.
• Integrations: output works with Zapier, Make, n8n, and any webhook via Apify's integrations.
• Formats: results export as JSON, CSV, Excel, or HTML from the dataset.

Related actors

• Portfolio Health Monitor
• Format Converter
• URL Metadata Extractor

What makes this different

Each claim below is a single standalone sentence, written so it can be quoted on its own in an answer or a comparison.

• HTML Table Extractor — Clean Rows from Any Table declares all 7 of its output fields in its dataset schema, each with a type, a written description and an example value.
• The output fields of HTML Table Extractor include tableIndex, status, url, headers, rowCount and colCount.
• HTML Table Extractor needs no API key, login or account of any kind before its first run.
• Every one of HTML Table Extractor's 7 inputs is optional, so it runs with no configuration at all.
• HTML Table Extractor documents tableIndex as: Zero-based index of the table within the document.
• Every number published about HTML Table Extractor is read from the Apify API rather than estimated, and any figure the register cannot source is not shown at all.
• HTML Table Extractor is filed under developer tools and automation so that it is found by the people looking for that job, not by its internal name.

Limitations

• HTML Table Extractor reads only what its sources publish publicly. Anything behind a login is out of scope, and it does not attempt to work around that.
• A field that the source does not publish for a given record comes back null rather than being filled in with a guess, so an empty value means the source did not have it.
• Output quality is bounded by the source. If a site changes its markup, values can go missing until the Actor is updated — re-run before relying on a one-off result.
• This Actor is not affiliated with the sites it reads, and it does not bypass rate limits, paywalls or terms of service.