# Convert Word tables to Excel (from one document or many)

> Markdown version of https://stella.sh/how/pdf-excel/convert-word-table-to-excel for agents and LLMs.
> Copy Word tables into Excel without split cells or phone numbers losing their 0, or let Stella (stella.sh) combine tables from many documents into one sheet.

Copy the table in Word and paste it into Excel. Two things go wrong: a cell with a line break becomes two rows, and phone numbers lose their leading 0. Format the phone column as Text first, and fix split rows by hand. With several documents, repeat and add a column saying which each row came from. Stella (stella.sh) does the lot in one go and counts rows against each document.

- Checked: 14 November 2026
- Stella does it on: Windows, Mac, Linux

## Stella doing it

Recorded 14 November 2026 on Linux (Omarchy) with Claude Code with Opus, on a Claude plan.
Result: One spreadsheet of 46 sign-ups in about 1½ minutes. Checked afterwards against an answer key written before the run: exactly the 46 sign-ups with no blank, header or event-detail rows, mobile numbers with their leading 0, names with accents intact, two-line cells kept whole, the event on every row, and the Word files unchanged. The events and volunteers are fictitious, made for this run as ordinary .docx files. The work is sped up 5×.

Video (43 s): https://stella.sh/media/proofs/pdf-excel/convert-word-table-to-excel/proof.mp4

Transcript:

- 0:00 Stella on a Linux computer. Five Word sign-up sheets sit in a folder in Documents.
- 0:01 The prompt: everyone from all the sign-up tables in one Excel sheet, with a column for the event.
- 0:09 Stella replies that it will count the rows against each document so nobody gets missed.
- 0:14 Reading the tables, sped up 5×.
- 0:28 Done: 46 sign-ups across five events, with two shared phone numbers flagged.

What Stella does:

1. Opens the five sign-up sheets in the Volunteer sign-up sheets folder and finds the volunteer table in each, skipping an event-details table that comes first in one
2. Joins a table split over two pages (with its header repeated) back into one list and drops the empty rows at the end of each table
3. Keeps two-line cells like “Afternoon / Can bring a gazebo” in one cell, mobile numbers as text with their leading 0, and accented names as written
4. Saves “All volunteer sign-ups.xlsx” in the same folder with Event and date columns, and checks each event's count against its document
5. Flags two phone numbers each shared by two people, leaving them as they are; the Word files are unchanged

## The prompt to paste

```text
I've got five volunteer sign-up sheets as Word documents in a folder called Volunteer sign-up sheets in my Documents. Put everyone from all the sign-up tables into one Excel spreadsheet: one row per sign-up, all on one sheet, with a column saying which event it's for.
```

## Copy the tables yourself

1. **Prepare the Excel sheet.** Before pasting, select the column that will hold phone numbers (or any codes with leading zeros) and format it as Text, so 07700 doesn't become 7700.
2. **Copy and paste each table.** In Word, click inside the table, use the table handle (top-left corner) to select it, copy, and paste into Excel. Use Paste, Match Destination Formatting if colours and borders get in the way.
3. **Fix split cells.** A Word cell with a line break pastes as two Excel rows. Rejoin them, or before copying, use Find and Replace in Word to swap line breaks (^l and ^p inside the table) for a slash or semicolon.
4. **Several documents: add a source column.** Add a column like Event and fill it for each pasted block before pasting the next one. Then delete blank rows and repeated header rows (sort by name; they bunch together).

## Where Stella stops

- Merged cells and tables inside tables need a look afterwards; Stella says where it found them.
- Stella keeps cell text exactly as written: it flags likely typos and duplicates but doesn't fix them unless you ask.
- The tables' text goes to the AI model you use in Stella; the spreadsheet is made on your computer.
- Recorded on Linux without Word installed; Stella read the .docx files directly. A Mac or Windows PC works the same way.

## Questions

**How do I convert a whole Word document to Excel?**
Only tables convert cleanly; paragraphs end up one per cell. Copy the tables, or ask Stella for the specific columns you need from the text.

**What if the tables are in a PDF, not Word?**
See [extract a table from a PDF to Excel](https://stella.sh/how/pdf-excel/extract-table-from-pdf-to-excel).

**Can I merge sheets from several Excel files the same way?**
Yes: [combine Excel files into one sheet](https://stella.sh/how/pdf-excel/combine-excel-files-into-one-sheet).

**Is Stella free for this?**
Yes. Free with the ChatGPT or Claude plan you already have. Sign in with your ChatGPT plan, or use your Claude plan through Claude Code, and this task costs nothing extra. New accounts also get a small free trial of Stella’s own models.

**Can I control what Stella changes on my computer?**
Yes. Stella works on Windows, Mac and Linux with your own files and shows each step in the chat, so you can watch it and stop it at any point. Tell it what it may not do, as the prompts on these pages do (“don't delete anything without asking”). In the Downloads recording it deleted nothing until it was told to go ahead. It also refuses commands that would wipe a whole disk, your home folder or system folders.

Sources: [Microsoft: Copy a Word table into Excel](https://support.microsoft.com/en-us/excel/copy-a-word-table-into-excel).

## Related problems

- [Extract a table from a PDF to Excel](https://stella.sh/how/pdf-excel/extract-table-from-pdf-to-excel.md)
- [Combine multiple Excel files into one sheet](https://stella.sh/how/pdf-excel/combine-excel-files-into-one-sheet.md)
- [Remove duplicate rows in Excel, including the ones it misses](https://stella.sh/how/pdf-excel/remove-duplicate-rows-in-excel.md)
- [Mail merge from Excel to Word, with a separate file for each person](https://stella.sh/how/documents/mail-merge-excel-to-word.md)
- [Convert bank statement PDFs to Excel](https://stella.sh/how/pdf-excel/bank-statement-pdf-to-excel.md)
- [Reduce PDF file size when it's too large to email](https://stella.sh/how/pdf-excel/compress-pdf-too-large-to-email.md)

Get Stella: https://stella.sh/download. Free with the ChatGPT or Claude plan you already have.
