HTML Table Extractor: Any Web Page Tables to JSON/CSV

Extract every data table from web pages into clean rows, with no login, no browser and no code. Export to JSON, CSV or Excel, or use the API.

Extract every data table from web pages into clean rows: header detection, colspan/rowspan handling, nested-table safety, captions and per-table row/column counts. Pick a single table by index or take all of them. Export the dataset as CSV, Excel or JSON. Works great on Wikipedia, docs, pricing pages and public reports.

Use cases

• Turn Wikipedia or report tables into spreadsheets
• Track pricing or spec tables on public pages
• Feed clean table rows to an LLM or database

Input

Field	Type	Notes
urls	array
minRows	integer	Skip layout tables smaller than this.
tableIndex	integer	-1 = all tables; 0 = first...
respectRobots	boolean
maxConcurrency	integer

Example input

{
 "urls": [
  "https://en.wikipedia.org/wiki/List_of_largest_companies_in_the_United_States_by_revenue",
  "https://en.wikipedia.org/wiki/List_of_U.S._states_and_territories_by_population",
  "https://example.com",
  "bad ::"
 ],
 "minRows": 3
}

Output

One dataset item per result. Main columns: sourceUrl, tableIndex, caption, headers, rowCount, columnCount, error. A RUN_SUMMARY record is saved to the default key-value store. See the sample output in the Output tab.

Example output

{
  "sourceUrl": "https://en.wikipedia.org/wiki/List_of_largest_companies_in_the_United_States_by_revenue",
  "tableIndex": 0,
  "caption": null,
  "headers": [
    "Rank",
    "Name",
    "Industry"
  ],
  "rowCount": 100,
  "columnCount": 7,
  "rows": [
    {
      "Rank": "1",
      "Name": "Walmart",
      "Industry": "Retail",
      "Revenue (USD millions)": "680,985",
      "Revenue growth": "5.1%",
      "Employees": "2,100,000",
      "Headquarters": "Bentonville, Arkansas"
    },
    {
      "Rank": "2",
      "Name": "Amazon",
      "Industry": "Retail and cloud computing",
      "Revenue (USD millions)": "637,959",
      "Revenue growth": "11.0%",
      "Employees": "1,556,000",
      "Headquarters": "Seattle, Washington"
    },
    {
      "Rank": "3",
      "Name": "UnitedHealth Group",
      "Industry": "Healthcare",
      "Revenue (USD millions)": "400,278",
      "Revenue growth": "7.7%",
      "Employees": "400,000",
      "Headquarters": "Minnetonka, Minnesota"
    }
  ]
}

Pricing

Pay per result, with no monthly rental or subscription:

• Table extracted: $0.002

Example: 1,000 results cost about $2.00 in fees. Apify's free plan includes $5 of monthly credit, which is enough to test this Actor.

FAQ

Do I need an account, cookies or a login for the source site? No. HTML Table Extractor uses public data sources only, so there is nothing to connect and no account to risk.

How much will a run cost? You pay only for results delivered (see Pricing above), plus Apify platform usage, which the free plan's monthly credit easily covers for test runs. Start with a small limit to see the exact cost per run.

Can I export to CSV, Excel or Google Sheets? Yes. Every run's dataset can be downloaded as JSON, CSV, Excel, XML or HTML, or pushed to Google Sheets, Make, Zapier, n8n, Slack or a webhook through Apify integrations.

Can I run it on a schedule or from my own code? Yes. Add an Apify Schedule (hourly, daily, weekly) or call it through the Apify API / Python & JavaScript clients. It also works with AI agents through the Apify MCP server.

What happens if an input is invalid or a source is down? The run keeps going. The bad input gets a row with an error field so you can see what failed, and you are not charged for results that were not delivered.

Is this legal to use? It collects publicly available data. You are responsible for using the output in line with the source's terms and privacy laws such as GDPR/CCPA; don't use it for spam.

Something missing or broken? Open an issue on the Issues tab. Feature requests are usually added within a few days.

Scheduling / monitoring

Create a Schedule (daily/weekly) and connect a webhook or Slack/email integration.

Fair use

Official public APIs only, no login. Do not use output for spam or harassment. Respect the data sources' rate limits and terms.

REST API

GET https://api.mediaprotools.com/v1/html-tables?items=... (header X-API-Key). Up to 5 items per call, separated by ,. Or POST {"items":[...],"options":{...}}.

Parameter	Type	Notes
items	token	Page URLs
minRows	integer 1-1000	Skip layout tables smaller than this.
tableIndex	integer -1-500	-1 = all tables; 0 = first...
respectRobots	boolean	Respect robots.txt

Output fields: caption, columnCount, error, headers, rowCount, rows, sourceUrl, tableIndex.