You find a useful data table on a website — a price list, a statistics page, a comparison chart — and you want it in Excel. So you select the table, copy, paste into a spreadsheet… and the formatting collapses into a single column of jumbled text.
This happens because web pages render tables with CSS, and when you paste, most of that structure is stripped away. In this article, we will compare the common approaches and show you a faster one: screenshot the web table and convert the image directly into a clean, structured table.
Approach 1: Copy & Paste (The Classic Struggle)
Selecting and copying the table works sometimes, but you will often see:
- All cells pasted into one column
- Headers duplicated or missing
- Links and images mixed into the cells
- Numbers treated as text, breaking formulas
Fixing this manually with "Text to Columns" and regex cleanup can take longer than re-typing.
Approach 2: Browser Developer Tools
If the table is rendered as a proper <table> element, you can inspect the page, copy the HTML, and parse it. This works for developers, but it is slow, requires cleaning the HTML, and fails completely for tables rendered as canvases, images, or custom <div> grids — which are increasingly common in dashboards and BI tools.
Approach 3: Screenshot + AI Conversion (Recommended)
The most reliable method needs zero technical skills:
Step 1: Screenshot the table
- macOS:
Cmd + Shift + 4to select the table region. - Windows:
Win + Shift + Sto snip the region.
If the table is wide, shrink your browser zoom (Cmd/Ctrl + -) so the whole table fits in one screenshot.
Step 2: Convert the screenshot
Upload the screenshot to Image to Table. The AI detects rows, columns, and even merged cells, and rebuilds the table.
Prefer maximum privacy? Use Local Image to Table — the OCR runs completely inside your browser, so the screenshot never leaves your computer.
Step 3: Export
Download the result as Excel (.xlsx), CSV, or copy it as Markdown.
Comparison of the Three Approaches
| Method | Works on canvas/div tables | Keeps structure | Skill needed | Speed |
|---|---|---|---|---|
| Copy & paste | No | Often broken | None | Fast, but cleanup is slow |
| Dev tools | No | Yes | High | Slow |
| Screenshot + AI | Yes | Yes | None | Seconds |
Pro Tips
- Avoid scroll-capturing mid-animation. Wait until the page is fully loaded.
- Include the header row in the screenshot so the AI can keep column names.
- Dark mode is fine — the OCR handles dark backgrounds well, but pure low-contrast gray text can reduce accuracy; switch to light mode if results are poor.
- Pagination: if the table spans multiple pages, screenshot each page separately and merge the exported CSVs.
Conclusion
Stop fighting broken copy-paste. A two-second screenshot plus the Image to Table tool converts any web table — even ones rendered as images or custom components — into clean Excel or Markdown data. It also works for tables you find in PDFs, slides, and photos of printed documents.