Skip to content

How to export a table from a web page to CSV

Updated October 10, 2026

Copying a table from a web page into a spreadsheet usually works, until it does not: merged cells shift columns, long lists are split across pages, and accented characters turn into symbols. This guide covers a cleaner way to get page data into a CSV file.

Before you start

Only export content you are allowed to access and reuse. Check the website's terms, and do not use extraction to get around a login, a paywall or a rate limit. The extension works only when you ask. Automatic paging is optional, bounded and visible, and you should keep the delay polite.

Export an HTML table

  1. Open the page with the table and click the AnyTool Smart Data Extractor icon.
  2. Choose Find Tables. A workspace opens listing every table on the page with its size.
  3. Select a table, then use the checkboxes to choose columns and the text boxes to rename them.
  4. Check the preview. Cells are editable, so you can fix a value before exporting.
  5. Choose Download CSV, Download JSON or Download XLSX.

Export cards or list items

Many pages show data as cards or list rows rather than a real table. Choose Pick Repeated Items, then click one card. The extension highlights every similar item it can find and tells you how many. If it picked too little or too much, use Parent level or Child level to move the selection, then choose Extract. The workspace lists the text, link addresses and image addresses it found as columns.

Getting more than one page

Two ways. To do it yourself, extract the first page, open the next page in the same tab, click the extension icon and choose Append This Page. To let the extension do it, press Start collecting in the workspace, choose Next-page link or Infinite scroll, and set a page limit and a delay. Your browser asks for access to that one site while it runs, it stops at your limit or when nothing new appears, and Stop ends it at once. It never starts by itself and never leaves the site you are on.

Opening the CSV in a spreadsheet

  • Accented and non-Latin text is preserved. Files are UTF-8 with a byte-order mark by default, which Excel uses to detect the encoding. Switch the mark off if another program shows stray characters at the start of the file.
  • Cells that begin with =, +, -, @, a tab or a carriage return are prefixed with a single quote so a spreadsheet treats them as text instead of running them as a formula. Plain negative numbers such as -42 are left alone. JSON export is never altered.
  • Columns that look like email addresses, phone numbers, card numbers or credentials start unselected, so that personal data is not exported by accident.

Limits

  • Merged cells are expanded by repeating the value in each position they covered.
  • Extraction is capped at 20,000 rows, with a warning if a page has more.
  • Content inside cross-origin frames is not reachable.
  • If a page loads more rows as you scroll, scroll first so the rows are on the page, then extract.