Account

What new tool do you want?

Document Converters

Word Tables to Excel Converter

Pull every table out of a Word document into an Excel workbook, one sheet per table or all on one sheet. Merged cells stay merged, header rows are kept, and numbers, currencies and percentages typed as text become real numbers you can sum.

How to use

  1. 1Drop a .docx file. Its tables are listed with their size and caption, and you can preview each one.
  2. 2Untick any you don't need, choose one sheet per table or all on one sheet, and how numbers should be read.
  3. 3Convert and download the .xlsx, or save a single table as CSV.

Frequently asked questions

Why not just copy and paste into Excel?

Pasting a Word table often splits cells with several paragraphs across extra rows, leaves numbers as text (so SUM gives 0), and loses which row is the header. With many tables it's also slow. This keeps each cell in one cell, with line breaks inside it, and turns '1,234.50', '(200)' and '12%' into numbers.

What happens to merged cells?

Cells merged across columns (gridSpan) or down rows (vertical merge) are merged the same way in Excel. Nested tables inside a cell are flattened into that cell's text, one row per line.

How are numbers recognised?

Thousands separators, a currency symbol or code, brackets or a minus sign for negatives, and a percent sign are understood. On Auto, '1,234.5' and '1.234,5' are both read correctly; '12,5' is read as 12.5. Codes with leading zeros like '007', and digit strings longer than 15 characters such as card or phone numbers, stay as text.

Is the document uploaded?

No. The document is read and the workbook built in your browser.

Sources

Example: a supplier price list

A 14-page Word price list has 9 tables, each with a caption like 'Table 3: Fasteners'. Converting with one sheet per table gives a workbook with sheets named after the captions. A price cell written '€ 1.234,50' becomes the number 1234.5, '15 %' becomes 0.15 formatted as a percentage, and a product code '00412' stays as text so its leading zeros survive.

Sheet names and captions

Excel sheet names can be at most 31 characters and can't contain [ ] : * ? / or \. The tool uses the table's caption (a Caption-style paragraph or a line starting 'Table 1' just above the table, or the table's alt-text title), cleans it up, and adds ' 2', ' 3' when two names would clash. Tables without a caption become 'Table 1', 'Table 2' and so on, in document order.

What isn't a table

Only real Word tables are found. Text lined up with tabs or spaces and tables pasted as pictures aren't tables in the file, and tables placed inside text boxes or charts aren't picked up. For a document that was scanned or saved as PDF, use the PDF to Excel converter instead.

Related tools

More: Document Converters