Web Table to Excel

Web tables into clean spreadsheets

Copy a table from a statistics site, a price list or Wikipedia into Excel and columns often shift, merged cells throw rows out of line, and numbers paste as text you can't add up. This tool reads the actual HTML table structure from what you paste, lines up every row and column, and gives you an .xlsx or CSV file.

How to use it

• Select the table on the web page with your mouse and press Ctrl+C (⌘+C on Mac).
• Click the “Paste here” box and press Ctrl+V. If the copied content contains several tables, pick one from the list — the largest is chosen first.
• Have the HTML source (<table>…) from developer tools? Paste it under “Paste HTML source instead”.

Merged cells and numbers

Merged cells (colspan/rowspan) are the main reason pasted tables shift. They're split back into individual cells; “Split and repeat the value” fills each with the same value so sorting and filtering work, while “Value in first cell only” keeps the original look. “Clean numbers” turns values like 1,200, 35% or $5,000 into numbers (35% becomes 0.35) so Excel can total them. IDs with leading zeros stay as text.

There's no “import from URL” option: fetching a page would mean contacting the site from outside your browser, which goes against this site's privacy approach. For tables in images use Table Image to Excel; for lists in notes or chats use Text to Excel Table. Pasted content is never uploaded.