Convert Word tables to Excel (from one document or many)
Five sign-up sheets in Word turned into one clean list of 46 volunteers.
A real run on 14 November 2026, on a Linux computer, using Claude Code with Opus, on a Claude plan. The waiting is sped up; it took 1 min 40 s in real time.
The short answer.
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.
Stella does this on Windows, Mac and Linux.
What happened.
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×.
How Stella does it.
- 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
- 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
- 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
- Saves “All volunteer sign-ups.xlsx” in the same folder with Event and date columns, and checks each event's count against its document
- Flags two phone numbers each shared by two people, leaving them as they are; the Word files are unchanged
The prompt.
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.
This is the exact prompt from the recording. If your files are somewhere else, say where.
Do it yourself.
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.
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.
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.
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 it 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?
Can I merge sheets from several Excel files the same way?
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.
Checked against these sources on 14 November 2026.