MySmartCoPilot

Your country

Tools that support it use your country for local currency, number formats, units and paper size. Your choice is saved only in this browser.

HTML / Web Table to CSV & Excel

Copy a table from any web page, Word file or Wikipedia article — get clean CSV or Excel.

Data Works offline Uses live data Free, no sign-up

The table’s structure travels with the copied formatting, so merged cells and headers are kept. Nothing is uploaded.

Options

Next steps

About the HTML / Web Table to CSV & Excel

Get the tables out of a web page without retyping them. Copy a table in your browser and paste it here (the formatting on the clipboard keeps the table’s structure), open a saved HTML page, a Word .docx or an OpenDocument .odt, read a Wikipedia article, or enter a web address. Every table found is listed with a preview; download it as CSV, Excel (.xlsx) or JSON, copy it straight into Excel or Google Sheets, or export several tables at once into one workbook.

The tricky parts of real tables are handled the way a browser lays them out: cells merged with colspan and rowspan (the value repeated into every cell they cover, or kept merged in Excel), two or three header rows combined into one column name (“Population 2011”), thead/tfoot order, nested layout tables, hidden sort keys and footnote markers such as [1] or [citation needed], which are removed so numbers stay numbers.

How to use it

  1. Choose where the table is: Paste, File, Wikipedia or Web page.
  2. Paste: select the table on the web page (or in Word or Excel), copy it with Ctrl+C (⌘C) and paste it into the box. HTML source code works too.
  3. Wikipedia: paste the article’s address or type its title and pick the language. Web page: enter the address of a public page.
  4. Check the tables found: untick the ones you do not need, and adjust Header rows, Merged cells and the other options — the previews update.
  5. Download each table as CSV, Excel or JSON, use Copy for Excel, or download all selected tables as one Excel workbook or a ZIP of CSV files.

Examples

Two header rows and a merged heading
Input
| Country (2 rows) | Population (2 columns) |
|                  | 2011 | 2021 |
| India | 1,210 | 1,400 |
Result
Country,Population 2011,Population 2021
India,"1,210","1,400"

The heading over two columns is combined with the year below it. Choose Several header rows: Keep as rows to export the two rows as they are.

Wikipedia footnotes and sort keys
Input
<td><span class="sortkey" style="display:none">7000331</span>331.26<sup class="reference">[12]</sup></td>
Result
331.26

Hidden sort keys and citation markers are left out, so the value is a clean number in Excel.

Common uses

  • Statistics and lists from Wikipedia into a spreadsheet for analysis.
  • Price lists, schedules and results published as web pages.
  • Tables inside Word reports into Excel without copying cell by cell.
  • Turning a saved web page with many tables into one workbook.

How tables are read

  • Merged cells: placed with the HTML table model; Repeat in each cell fills every covered cell (best for sorting and pivot tables), First cell only leaves the others empty and keeps the cells merged in Excel.
  • Header rows: rows of a thead, or the top rows made only of header cells (th), are the header — or choose the number yourself. With Combine into one row, a heading over several columns is joined to the headings below it.
  • Footnote markers like [1], [a], [note 3] and Wikipedia’s citation superscripts are removed (switch it off to keep them); other superscripts become Unicode, so km<sup>2</sup> reads km².
  • Hidden text (display:none, the hidden attribute, screen-reader-only labels, sort keys), scripts and styles are left out; tables nested inside another table’s cells are listed as tables of their own.
  • Word documents: merged cells (gridSpan, vMerge), header rows that repeat on each page, and line breaks are kept; deleted text from tracked changes, field codes and hidden text are not.
  • Formulas: a cell whose text starts with =, +, - or @ (other than a plain number) gets an apostrophe in front in CSV files and in Copy for Excel, because a spreadsheet would otherwise run it as a formula — a web page, or a Wikipedia table anyone can edit, may hold =HYPERLINK(…). Excel and JSON files keep the text as it is (it is stored as text there).

Wikipedia and web pages

Wikipedia articles are read through the MediaWiki API directly from your browser. Wikipedia’s text is licensed under CC BY-SA 4.0: when you publish the data, credit the article (the tool gives you a ready-made credit line and adds it to the Excel file) and share your version under the same licence.

For other pages, MySmartCoPilot’s server fetches the page for you: it follows the site’s robots.txt (RFC 9309), only fetches public addresses, reads at most 1 MB, and sends back only the text of the tables — never the page itself. To protect the service, each visitor has a small number of page fetches per hour.

Limitations

  • Tables that a page builds with JavaScript after it loads, and pages behind a login, cannot be fetched by address — open the page in your browser, copy the table and use Paste.
  • Web pages are read as UTF-8 in the Web page tab (almost all are); for an older page in another encoding, save it and open the file, where the encoding is detected.
  • Pages over 1 MB are read only up to the first megabyte in the Web page tab.
  • Old Word .doc files (before 2007) cannot be read: save them as .docx first. PDFs have their own tool, PDF to Excel.
  • Cell formatting (colours, fonts) and images are not exported; with Image alt text on, an image’s description is added to its cell.

Privacy

Pasted content and opened files never leave your device. The Wikipedia tab asks Wikipedia for the article you name, straight from your browser. The Web page tab sends only the address to MySmartCoPilot, which fetches that page and returns the text of its tables.

Frequently asked questions

How do I copy a table from a website into Excel?

Select the table on the page, copy it, and paste it into the Paste box. Then press Copy for Excel and paste into Excel — or download it as an .xlsx file. Merged cells and header rows are sorted out on the way.

How do I download a table from Wikipedia as CSV?

Open the Wikipedia tab, paste the article’s address (for example https://en.wikipedia.org/wiki/List_of_largest_cities) and press Get tables. Every table of the article is listed; download the one you need as CSV or Excel. Remember to credit Wikipedia when you publish the data.

Why are some cells repeated?

In the source table they are one merged cell spanning several rows or columns. Repeating the value keeps every row complete, which spreadsheets need for sorting and filtering. Choose Merged cells: First cell only to keep them empty instead.

Does it work with tables in Word documents?

Yes — open the .docx (or .odt) file in the File tab, or copy the table in Word and paste it. Old .doc files need to be saved as .docx first.

Is the page or my data sent anywhere?

Pasted content and files are processed only in your browser. The Wikipedia tab requests the article from Wikipedia. Only the Web page tab uses MySmartCoPilot’s server, which receives the address you enter and returns the tables’ text; it does not keep the page.

More data tools

All data & spreadsheet tools →
Chart Maker (Graph from Data) Paste a table, pick a suggested chart, download it — all in your browser.
Excel Viewer (XLSX, XLS, ODS, Numbers) Open any spreadsheet without Excel — every sheet, formula and comment, nothing uploaded.
LaTeX Table Generator Edit a table like a spreadsheet and get clean LaTeX code with the packages it needs.
Bar Graph Maker Grouped, stacked, horizontal and diverging bar charts from your numbers.
CSV & Excel Splitter Cut big CSV and Excel files into smaller ones, header repeated in each. Pro
Excel to CSV Converter Turn any sheet into clean CSV — every sheet at once, title rows and merged cells fixed.