DehumanizeGet the extensions

Guides

Convert an HTML table to Markdown, CSV or JSON without writing code

By Dehumanize14 November 20262 min read

In short

  • Choose the format by the job: Markdown for AI, TSV for spreadsheets, JSON for code.
  • Manual copying breaks on merged cells and number formats.
  • Convert the table instead of copying it.
In this guide
  1. Which format for which job
  2. Where manual copying goes wrong
  3. Doing it in one step
  4. A quick check after converting

Tables on web pages are built from nested HTML elements. Copy and paste often flattens them into a jumble of lines, or pulls in hidden cells and styling. The fix is to convert the table, not to copy it. First decide which format you need.

Which format for which job

  • Markdown. Best for AI chats, notes and documentation. Small, readable, and models understand it well.
  • CSV or TSV. Best for spreadsheets and data tools. TSV pastes cleanly into Excel and Google Sheets because tabs do not clash with commas in the data.
  • JSON. Best when a script or an API will read the data. Each row becomes an object with the column names as keys.
  • HTML. Best when you want to put the table in another web page and keep its structure.
  • Excel file. Best when you want to open it, filter it and send it on.

Where manual copying goes wrong

  • Merged cells shift columns.
  • Numbers with thousand separators or currency signs turn into text.
  • Hidden rows and sort arrows get copied along.
  • Long tables are split across pages, so you have to repeat the work.

Doing it in one step

Tables for AI finds every table on the page, lets you pick the one you want, and copies it as Markdown, CSV, TSV, JSON or HTML. Pro adds export to an Excel file and a collection where you can gather several tables before exporting. The conversion happens in your browser, so the table content is not sent anywhere.

A quick check after converting

Look at the header row and the first and last row. If the column count matches the page, the rest is almost always right. For tables with merged cells, check the rows under the merged part.

Copy tables without the mess

Tables for AI copies any web table as Markdown for AI chats, or as CSV, TSV, JSON and Excel. Merged cells, footnotes and hidden rows are handled for you. Free, no account.

Add to Chrome, free: coming soonSee Tables for AI

More: all guides · Scrub for AI · Copy for AI · Tables for AI