HTML table extractor

2026-06-29 · Source: Simon Willison's Weblog · Field: Technology & Digital — Data Science & Analytics, Software Development & Engineering · Depth: Fundamental Awareness, quick

Summary

The HTML table extractor is a new web-based tool released on June 29, 2026, designed to automatically detect and convert tables from various pasted content types. Users can paste HTML, rich text, or plain text containing tables, and the tool provides a preview before allowing export into multiple formats, including HTML, Markdown, CSV, TSV, and JSON. This utility expands a collection of paste-conversion tools. A recent update further enhanced its functionality by integrating with Wikipedia's open CORS API, enabling users to search for a Wikipedia page and directly import and display its tables. This development follows a similar rebuild of the "Rich text to markdown" tool, which also gained improved UI and table support.

Key takeaway

For data analysts or developers frequently needing to extract structured data from web content, this HTML table extractor streamlines your workflow significantly. You can quickly convert tables from pasted rich text or HTML into formats like CSV or JSON, bypassing manual parsing. Consider integrating this tool into your data acquisition pipeline, especially for Wikipedia data, to save time and reduce errors.

Key insights

The tool simplifies table data extraction and format conversion from diverse sources, including direct Wikipedia integration.

Principles

• Direct data conversion streamlines workflows.
• API integration enhances content acquisition.
• User-friendly interfaces improve utility.

Method

Paste content (HTML, rich text, plain text), tool detects tables, previews them, then export to HTML, Markdown, CSV, TSV, or JSON. Optionally, search Wikipedia to import tables directly.

In practice

• Convert web tables for spreadsheet analysis.
• Extract structured data from rich text.
• Quickly get Wikipedia table data.

Topics

• HTML Table Extraction
• Data Format Conversion
• Web Data Extraction
• Wikipedia API
• Rich Text Processing
• Data Utility Tools

Code references

• simonw/tools

Best for: Data Analyst, Software Engineer, Data Scientist

Related on AIssential

• Ai_extract in Databricks — Databricks' `AI_extract` function, combined with regex and SQL, efficiently extracts structured data from PDF-derived HTML tables.
• Extract Structured Data from Any Document | Enterprise h2oGPTe — Extractors in h2oGPTe convert unstructured document data into structured JSON using defined schemas.
• Stop Returning Flat Text from a PDF: The Relational Tables RAG Needs — PDF parsing for RAG should produce a relational set of linked tables, not flat text, to preserve document structure.
• Website Content Analysis: Keyword and Terminology Extraction. Implementation on Apify — Automated keyword and terminology extraction from websites aids content analysis, SEO, and trend identification.
• Co-Scraper: query-aware DOM Pruning and Reusable Scraper Synthesis for Lightweight Web Data Extraction — Query-aware DOM pruning and stable strategy induction enable reusable web scrapers for scalable data extraction.
• LlamaSheets | AI Parsing and Extraction for Spreadsheets — Llama Sheets converts unstructured spreadsheet data into structured Parquet files for AI agent processing.

Open in AIssential →

Editorial summary, takeaway, and curation by AIssential. Original article published by Simon Willison's Weblog.