HTML Table to CSV

How this reads your output

Rows and cells are pulled from the first table element in what you paste, tags inside cells are stripped, and HTML entities are decoded back to the characters they represent. The result is re-quoted for CSV, so a cell containing a comma or a quotation mark comes out correctly instead of splitting the row. Merged cells and rows with an unexpected column count are counted and reported, because both produce data that looks valid and is not.

What the results mean

Merged cells

Cells with a colspan or rowspan. CSV has no equivalent, so a merge becomes one value and the columns after it shift left in that row.

Rows with a different column count

Usually a section heading spanning the full width, or a footer row with a different shape. Both need checking by hand.

Tables found

How many tables were in the markup. Only the first is converted, so paste just the one you want if there are several.

Common problems and fixes

The data is shifted by one column on some rows

Merged cells, almost certainly. Look at the original table for cells spanning more than one column, since each one leaves a hole the conversion cannot fill. The fix is to add the repeated value back by hand in the affected rows, which is quick once you know where to look.

Nothing is found in markup that clearly has a table

Check that you pasted the opening and closing table tags rather than just the rows. If the page builds its table with script, copy the rendered markup from the browser inspector instead of the page source, because the server response contains no table at all.

Frequently asked questions

More in Data

• CSV to HTML TableConvert a CSV into accessible, escaped HTML table markup.
• CSV ViewerView a CSV as a table — and find the rows that do not line up.
• CSV to Markdown TableTurn a CSV into a Markdown table, with pipes escaped properly.