tool · one of 34free, 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 itPress ⌘+K on any tab and type tables.Ctrl+Kon Windows and Linux
TWO BUILDS9 browsers
Chromelisting in reviewFirefoxlisting in reviewBravelisting in reviewOperalisting in reviewEdgelisting in review4 moreChromium browsers: Arc, Vivaldi, Chromium, Opera GXthe Chrome buildin 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.
TWO BUILDS9 browsers
Chromelisting in reviewFirefoxlisting in reviewBravelisting in reviewOperalisting in reviewEdgelisting in review4 moreChromium browsers: Arc, Vivaldi, Chromium, Opera GXthe Chrome build63 of these · no host permissions · three free audits