Guides

Getting a table off a web page goes wrong in a small number of predictable ways. These pages explain each one and say what to do about it, with or without an extension.

• Copy a table from a website into ExcelFive ways to do it, and where each one breaks.
• Export a React, AG Grid or other div gridWhy most extractors find nothing there, and what works instead.
• The export only has the rows you can seeVirtualised grids, how to confirm it, and how to get the rest.
• CSV, JSON and Markdown that open cleanlyThe BOM, the delimiter, formula injection, leading zeros, escaping.
• Copy a Wikipedia table into ExcelRowspan, reference markers and hidden sort keys, and how to clean them.
• Import a web table into Google SheetsIMPORTHTML, IMPORTXML, the one-hour cache, and the four causes of #N/A.
• Everything landed in one columnFive different problems that all look like a broken paste.
• What to check before you install an extractorNine things that vary between these tools, and how to test each one.