tool · one of 34 free, no counter
Tables
How do I get this HTML table into a spreadsheet?
Selecting an HTML table and pasting it into a spreadsheet works right up until the table has a colspan, at which point every row after it is one column out. This captures the table as a rectangle: spans are expanded into the cells they cover, ragged rows are padded to the widest, and what comes out lines up.
Reach it Press ⌘ + K on any tab and type tables. Ctrl + K on Windows and Linux
in the panel · free, no counter
What this actually is
any table on the page out as csv or jsonAny time a table on a page has to become a file. It is also the honest way to check what a table actually contains, because the expansion makes a merged header visible as the several columns it really spans.
Asked about this tool
4 of themWhat happens to merged cells?
They are expanded - a cell spanning three columns appears in all three. That is what makes the output a rectangle, and it is why a paste into a spreadsheet lines up where a browser selection does not.
Does it handle a table inside a table?
Yes. A cell belongs to its nearest <table> ancestor, so the inner table is captured as its own rectangle rather than being flattened into the outer one.
Why is the row count higher than what I can see?
A rowspan="0" means "to the end of the section", and hidden rows are still rows. The capture reads the markup rather than what is painted.
Is this the same walk the Markdown converter uses?
Yes, exactly the same one - the converter calls it rather than walking the table a second time, so a table in your Markdown and a table in your CSV can never disagree.
how to use tables
- Open Tables to list every table element on the page.
-
Pick one.
colspanandrowspanare expanded into the cells they cover. - Read the rectangle that came back: ragged rows are padded out to the widest.
- Export it as CSV, TSV or JSON.
70 of these · no host permissions · three free audits