How to Automatically Create a Numbered List from Word Form Entries
Question details
The user wants to automate the extraction of text entered into form fields scattered throughout a document, consolidating them into a single numbered list or table without manual copy-pasting.

- Product
- Word
- Device & OS
- not provided
- Scenario
- Collecting multiple user responses or questions from a filled-out document form into a summarized, structured list.
- Observed behavior
- Ordinary text fields do not automatically consolidate into a list; users are forced to repeatedly copy and paste entries manually.
Ensure your document is set up with standard text form fields or structured content controls before attempting to extract or link the data.
Use Bookmarks and Cross-References
Assign bookmarks to your form fields and use cross-references to dynamically pull those entries into a numbered list elsewhere in the document.
This is the most straightforward native method for documents without relying on complex scripting. It links the data directly so that any changes to the original fields update the summary list.
Highlight the text field or entry you want to collect. Go to the 'Insert' tab, select 'Bookmark', type a unique name (e.g., Question1) with no spaces, and click 'Add'.
Navigate to the section of the document where you want the summary list to appear. Type '1. ' to begin a numbered list.
Go to 'Insert' > 'Cross-reference'. In the dialog box, change the 'Reference type' to 'Bookmark'. Select the bookmark you created.
Ensure 'Insert reference to' is set to 'Bookmark text', then click 'Insert'. The form entry will appear in your list. Repeat this process for all entries.
When form entries are modified, the list will not update instantly. Press 'Ctrl + A' to select the entire document, then press 'F9' to refresh all cross-references automatically.

Use a VBA Macro to Extract Entries
For complex documents with numerous fields, a VBA macro can automatically loop through content controls and populate a summary table.
Automate Document Forms and Lists with WPS Writer
WPS Writer provides robust support for form fields, bookmarks, and cross-references, allowing you to easily build dynamic documents that automatically compile lists from scattered text entries without manual copying.
- 1. Open your document: Launch WPS Writer and open the document containing your input fields.
- 2. Assign Bookmarks: Highlight the input text, go to the 'Insert' tab, and click 'Bookmark' to assign a unique name to the entry.
- 3. Insert Cross-references: Move to your summary section, start a numbered list, and navigate to 'Insert' > 'Cross-reference'.
- 4. Link and update: Choose your bookmark to insert the linked text. Whenever the source text changes, simply select all and press F9 to update the list automatically.

Frequently Asked Questions
Why doesn't my cross-referenced list update automatically when I change the form entry?
Word processors do not dynamically update cross-references as you type to save system resources. You must manually trigger the update by selecting the document text (Ctrl + A) and pressing the F9 key to refresh all fields and references.
Can I extract form data to Excel instead of creating a list in Word?
Yes. If your document uses legacy form fields, you can change the save options by going to Word Options > Advanced, and checking 'Save form data as delimited text file'. This exports a CSV file that opens directly in Excel.
What is the difference between legacy form fields and content controls for data collection?
Legacy form fields are older tools that are easily linked via bookmarks directly in their properties. Content controls offer more robust, structured data mapping but often require XML mapping or VBA macros to automatically compile into a secondary list.




