Word to Excel converter
Turn the tables in a Word document into an Excel spreadsheet. Every table gets its own sheet, and your file never leaves your browser.
Drop a Word file here
A .docx file, up to 100 MB. It stays on your computer.
- No sign-up
- Nothing uploaded
- Every table, one sheet each
Every table in your document, ready to sort.
Your file stays on your computer
The document is read and the Excel file is built in your browser. Nothing is sent to Mammoth or anyone else.
Every table on its own sheet
A report with three tables becomes a workbook with three sheets, named from each table's title row.
Merged cells filled in
A region merged down two rows is written into both, so every row sorts and filters on its own.
How to convert Word to Excel
Each table's first row gives the column names. Numbers become numbers, codes like 0007 stay text, and the header row is bold and frozen.
- 1
Add your Word file
Drop a .docx file on the box, choose one, or paste a table you copied from Word.
- 2
Check the tables
A preview shows each table as it will look in Excel. Pick a table from the menu to see the others.
- 3
Download
Save one .xlsx with every table, or one table on its own. It opens in Excel, Google Sheets or Numbers.
Other ways to do it
Excel takes a Word table by copy and paste, and Python can read every table in a file. Both leave some tidying to you.
Copy and paste into Excel
One small table
- Every table at onceNo
- Merged cells filled inNo
- Keeps leading zerosNo
- No software to installNo
Python with python-docx
Many files, by script
- Every table at onceYes
- Merged cells filled inPartly
- Keeps leading zerosYes
- No software to installNo
- This page
This converter
A clean .xlsx in one step
- Every table at onceYes
- Merged cells filled inYes
- Keeps leading zerosYes
- No software to installYes
How to copy a table from Word to Excel
For one small table, copy and paste works. Check the result before you use it.
| A | B | C | |
|---|---|---|---|
| 1 | Order | Region | Customer |
| 2 | 71 | North2 | Ana Costa |
| 3 | 1042 | Ben Ellis |
1The order code 0007 can turn into the number 7.
2A merged cell stays merged, so the column will not sort.
Is your table in a PDF instead? The PDF to Excel converter reads tables out of PDF files.
- 1
In Word, click the table, then the four-way arrow at its top-left corner. The whole table is selected.
- 2
Copy it with Ctrl+C, or Cmd+C on a Mac.
- 3
In Excel, click the cell where the table should start and paste with Ctrl+V.
- 4
Select Paste Options and pick Match Destination Formatting, so Word's fonts and borders are left behind.
Your file stays private
The converter runs inside this page. Your Word document is read and turned into a spreadsheet on your computer, and nothing is sent to Mammoth. That makes it safe for contracts, reports and anything with customer data in it.
Once the page has loaded, it works with your internet switched off.
Getting the same report every month?
Mammoth can take it from there. Save each month's tables as Excel, put the files in a folder, and the rows are added to one table.
Monthly reports
| August | Aug | North | 1,284 | |
| August | Aug | South | 962 | |
| September | Sep | North | 1,310 | |
| September | Sep | South | 1,005 | |
| October | Oct | North | 1,198 |
Illustration. Every new file in the folder is added to the same table.