How to Extract Data From Multiple Word Documents Into Excel
To pull the same details out of many Word documents into one Excel sheet, one row per document, start by checking how the documents were built. Forms built with legacy form fields can export their entries as text that Excel imports. A VBA macro can loop through a folder if every document follows the same template. Without a template or code, a document extraction tool such as Scrape AI suggests the fields and fills one row per file.
First, check how your Word documents were made
- Word forms: documents with fill-in fields (legacy form fields or content controls), such as an intake form someone completed.
- One template, filled in by hand: every document has the same headings and labels ("Name:", "Date:", "Project number:"), but the values are typed as normal text.
- Different layouts: reports, letters, resumes or proposals from different people, where the same detail appears in a different place each time.
Method 1: Export Word form data as text, then import it into Excel
For forms built with legacy form fields, Word can save only the data typed into those fields, as a delimited text file. The steps below follow TechRepublic's walkthrough and Chron's guide:
- Open one completed form.
- Go to File, Options, Advanced. Under Preserve fidelity when sharing this document, tick Save form data as delimited text file.
- Save the document as a plain text (.txt) file.
- In Excel, import the text file as delimited data, choosing the separator the file uses.
- Repeat for each form, adding each one as a new row.
Where it stops working: it handles one document at a time, so 100 forms means 100 saves and imports. It's meant for legacy form fields: on Microsoft Q&A, a user got no data saved, and the accepted answer explained that the form used content controls (Microsoft Q&A). Documents with plain typed text have no form data to export.
Method 2: Write a VBA macro that loops through the folder
When every document follows one template, a macro can do the copying for you. Forum threads such as Microsoft Tech Community share macros that loop through a folder of Word files and write each file's values to the next row. If you write or adapt one:
- Search for each label rather than counting paragraphs, so an extra line doesn't shift every value.
- Test it on a copy of a few documents before running it on the whole folder.
- Have it write the file name in the first column, so you can trace every row back to its document.
Where it stops working: a macro only knows the layout you wrote it for. If documents come from different people or templates, it needs a rule for each variation, and someone has to maintain it.
Method 3: Let Scrape AI suggest the fields and fill the rows
Scrape AI (getscrape.ai) is a document data extraction tool that turns PDFs and Word files into spreadsheets. Every value is checked against the document's text and highlighted where it's printed. On Word files, values are checked against the text; the gold highlight is for PDFs. There's no macro or template to build.
- Create a run, name it, and pick a type: Smart Scan for any PDF or Word document, or Employee Data, Project Data, or Finance & Legal.
- Upload your Word (.docx) files (uploading files).
- Scrape AI reads a sample of the files and suggests fields based on what's in them. Add, rename, remove or reorder fields until they match the columns you want.
- Press Scrape. Each document becomes one row, with one column per field.
- Review the results in the app. Every value is checked against the document's text, and a cell stays blank if the value isn't there (how values are checked).
- On a paid plan, export to Excel (.xlsx), CSV or Google Sheets.
Limits to know: each Word document can be about 10 pages (40,000 characters of text) and up to 25 MB. Word files don't get the click-to-highlight page preview that PDFs do. The Free plan includes 10 documents to try it on your own files and review the results in the app; editing and export start on the Standard plan (see pricing).
Which method should you use?
| Your Word documents | Best fit | Watch out for |
|---|---|---|
| Completed Word forms, a handful | Save form data as delimited text, then import | One file at a time; form fields only |
| One template, many files | A VBA macro that searches for labels | Breaks when the layout changes; needs upkeep |
| No template, or no time for code | Scrape AI | .docx only; about 10 pages per file; export on paid plans |
Frequently asked questions
Can I get Word form data into Excel without a macro?
If the form uses legacy form fields, yes: Word can export its entries as a delimited text file that Excel imports, one document at a time. For ordinary documents, use a macro or a document extraction tool.
Does Scrape AI work with .doc files?
Scrape AI accepts Word files in .docx format. If you have older .doc files, open them in Word and save them as .docx first.
Can I see where each value came from in a Word file?
No. The gold highlight that shows a value on the page works for PDFs only. Values from Word files are still checked against the document's text, and the cell stays blank if a value isn't there.
How long can each Word document be?
About 10 pages (40,000 characters of text) per document, and up to 25 MB per file.
Working with PDFs instead? See how to extract data from multiple PDFs into one spreadsheet.